Issue Bug Closed

#59349Update Reference Index failed by SQL errors (INSERT INTO sys_refindex )

Johannes C. Laxander 06/04/14, 21:04 updated 10/02/18, 11:56

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.