Bug #87138

indexed_search: Duplicate entry for key 'Primary' in index_rel

Added by Reinhard Hiebl over 1 year ago. Updated over 1 year ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2018-12-12
Due date:
% Done:

0%

TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Wondering, why always 0 words was indexed on a specific page.

So i just inspected the query in \sysext\indexed_search\Classes\Indexer.php ~ 2010

$res = $GLOBALS['TYPO3_DB']->exec_INSERTmultipleRows('index_rel', $fields, $rows);

Result is a dublicate key and the whole page will not be indexed.
DB: Last query log

Might be the exact same issue as here (but for "index_rel"):
https://forge.typo3.org/issues/84541

Screenshot_32.png View - DB: Last query log (27.4 KB) Reinhard Hiebl, 2018-12-12 22:42

Screenshot_33.png View (52.7 KB) Reinhard Hiebl, 2018-12-12 22:52


Related issues

Related to TYPO3 Core - Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error New 2018-03-27

History

#1 Updated by Reinhard Hiebl over 1 year ago

  • Related to Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error added

#2 Updated by Reinhard Hiebl over 1 year ago

  • Related to Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error added

#3 Updated by Reinhard Hiebl over 1 year ago

  • Related to deleted (Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error)

#4 Updated by Reinhard Hiebl over 1 year ago

Temporary Fix (\sysext\indexed_search\Classes\Indexer.php):

Also available in: Atom PDF