Bug #81469

Upgrade from 7.6 to 8.7 - "Execute database migrations on single rows" wizard ends with error

Added by Vladimir Kubak about 2 years ago. Updated 4 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Install Tool
Target version:
-
Start date:
2017-06-05
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Have problem with following upgrade wizard:

Execute database migrations on single rows
Some row updaters have not been executed:
Migrate values in database records having "l10n_mode" either set to "exclude" or "mergeIfNotBlank"
Migrate values in sys_file_reference crop field
Scan for old "<link>" syntax in richtext and text fields and update to "<a href>"

After long running time it throws:

An exception occurred while executing 'INSERT INTO `sys_refindex` (`tablename`, `recuid`, `field`, `flexpointer`, `softref_key`, `softref_id`, `sorting`, `deleted`, `workspace`, `ref_table`, `ref_uid`, `ref_string`, `hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["tt_content", 13016, "bodytext", "", "typolink_tag", "9e432bda251dba06e251b6d0d955e310:3", -1, 0, 0, "_STRING", 0, "http:\/\/apps.webofknowledge.com\/CitingArticles.do?product=UA&SID=W29E4puidsTbO54KORu&search_mode=CitingArticles&parentProduct=UA&parentQid=1&parentDoc=1&REFID=1092331&betterCount=1102&excludeEventConfig=ExcludeIfFromNonInterProduct", "eff983bdfbb4a6f87f30fbd9b97c6b84"]: Data too long for column 'ref_string' at row 1

Probably unable to handle longer links?

History

Also available in: Atom PDF