ke_search:indexing: hidden_content specified twice

[infabo]

An exception occurred while executing 'PREPARE insertStmt FROM "
			INSERT INTO tx_kesearch_index
			(pid, title, type, targetpid, content, tags, params, abstract, language, starttime, endtime, fe_group, tstamp, crdate, breadcrumb, sortdate, orig_uid, orig_pid, directory, hash, hidden_content, breadcrumb, sortdate, orig_uid, orig_pid, directory, hash, hidden_content)
			VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
		"':

Column 'hidden_content' specified twice

https://github.com/tpwd/ke_search/blob/v5.0.2/Classes/Indexer/IndexerRunner.php#L460

TYPO3 11.5.30
ke_search 5.0.2

[AstCommodore]

Hello folks,

the error message related to the column seems to be random:

An exception occurred while executing 'PREPARE insertStmt FROM "       
         			INSERT INTO tx_kesearch_index                                          
         			(pid, title, type, targetpid, content, tags, params, abstract,         
         language, starttime, endtime, fe_group, tstamp, crdate, sortdate,      
         orig_uid, orig_pid, directory, hash, hidden_content, sortdate,         
         orig_uid, orig_pid, directory, hash, hidden_content)                   
         			VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,     
         ?, ?, ?, ?, ?, ?)                                                      
         		"':                                                                    
                                                                                
         Column 'sortdate' specified twice  

TYPO3 11.5.28
ke_search 4.6.6
PHP 8.1.21
MySQL 8.0.25

[christianbltr]

Unfortunately I could not reproduce the error.

It seems that the "additionalFields" have been registered twice, which I could only enforce by duplicating the lines

    // use hooks for generation of sortdate values
    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['registerAdditionalFields'][] =
        \Tpwd\KeSearch\Hooks\AdditionalFields::class;

in ext_localconf.php of ke_search.

Do you have some custom code which extends ke_search and maybe adds that lines by accident?

BTW: Please use https://github.com/tpwd/ke_search/issues for further issues because this issue tracker is not used anymore.

[infabo]

I have one single occurrence in my project inside ext_localconf.php of my site package.

    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['modifyPagesIndexEntry'][] = \MMC\SitePackage\Hooks\KeSearchHooks::class;
    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['modifyExtNewsIndexEntry'][] = \MMC\SitePackage\Hooks\KeSearchHooks::class;
    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['registerAdditionalFields'][] = \MMC\SitePackage\Hooks\KeSearchHooks::class;
    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['additionalResultMarker'][] = \MMC\SitePackage\Hooks\KeSearchHooks::class;
    $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['ke_search']['modifySearchWords'][] = \MMC\SitePackage\Hooks\KeSearchHooks::class;

    public function registerAdditionalFields(&$additionalFields): void
    {
        $additionalFields[] = 'breadcrumb';
    }

[infabo]

Still experiencing this error. The only pattern I see: it appears once a week. Exactly. Indexing task is running once every hour, but this error occurs only once a week. 🍿