#59349Update Reference Index failed by SQL errors (INSERT INTO sys_refindex )
Description
I’ll update a website from 4.7.17 to 6.2.3. By updating the reference Index I get this errors:
76054 records from 57 tables were checked/updated.
Record backend_layout:1 had 1 added indexes and 0 deleted indexes
Record backend_layout:3 had 1 added indexes and 0 deleted indexes
Record tx_news_domain_model_media:1 had 1 added indexes and 0 deleted indexes …
Record tx_news_domain_model_file:1 had 1 added indexes and 0 deleted indexes …
Record tx_gridelements_backend_layout:1 had 1 added indexes and 0 deleted indexes …
As a result of this I have set debugSQL to true and get these SQL errors:
INSERT INTO sys_refindex (tablename,recuid,field,flexpointer,softref_key,softref_id,sorting,deleted,workspace,ref_table,ref_uid,ref_string,hash) VALUES (‘tx_news_domain_model_media’,‘119’,‘image’,’‘,’‘,’‘,‘0’,‘0’,‘0’,NULL,NULL,’‘,‘238eecf9c5c65e14bb7bbbb39f1ba839’)
debug_backtrace require(.2.3/typo3/sysext/lowlevel/dbint/index.php),.2.3/typo3/mod.php#45 // TYPO3\CMS\Lowlevel\View\DatabaseIntegrityView->main#39 // TYPO3\CMS\Lowlevel\View\DatabaseIntegrityView->func_refindex#221 // TYPO3\CMS\Core\Database\ReferenceIndex->updateIndex#318 // TYPO3\CMS\Core\Database\ReferenceIndex->updateRefIndexTable#958 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#143 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#215
OR
INSERT INTO sys_refindex (tablename,recuid,field,flexpointer,softref_key,softref_id,sorting,deleted,workspace,ref_table,ref_uid,ref_string,hash) VALUES (‘tx_gridelements_backend_layout’,‘15’,‘icon’,’‘,’‘,’‘,‘0’,‘0’,‘0’,NULL,NULL,’‘,‘903729ceee40d48661c4b5ce1f3e8e82’)
These records are in affect to the ‘image’ or ‘icon’ field with ‘group’ configuration:
'image' => array(
'exclude' => 0,
'l10n_mode' => 'copy',
'label' => $ll . 'tx_news_domain_model_media.media',
'config' => array(
'type' => 'group',
'internal_type' => 'file',
'allowed' => $GLOBALS['TYPO3_CONF_VARS']['GFX']['imagefile_ext'],
'max_size' => $GLOBALS['TYPO3_CONF_VARS']['BE']['maxFileSize'],
'uploadfolder' => 'uploads/tx_news',
'show_thumbs' => 1,
'size' => 1,
'minitems' => 1,
'maxitems' => 1,
)
),
'icon' => array(
'exclude' => 1,
'label' =>
'LLL:EXT:gridelements/Resources/Private/Language/locallang_db.xml:tx_gridelements_backend_layout.icon',
'config' => array(
'type' => 'group',
'internal_type' => 'file',
'allowed' => 'jpg,gif,png',
'uploadfolder' => 'uploads/tx_gridelements',
'show_thumbs' => 1,
'size' => 5,
'minitems' => 0,
'maxitems' => 2,
)
),Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.