Bug #88557

Indexed Search: generates identical word ids for different words

Added by Dan Ilea 8 months ago. Updated 8 months ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Indexed Search
Target version:
-
Start date:
2019-06-13
Due date:
% Done:

0%

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

Description

Because of the method used for hashing it, there are cases when a word id (wid) is a duplicate of the hash for a different word.
And the following error occurs because wid is primary key in the index_words table:

Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing ‘INSERT INTO `index_words` (`wid`, `baseword`, `metaphone`) VALUES (?, ?, ?)’ with params [36468906, “nussholz”, “76382384"]: Duplicate entry ‘36468906’ for key ‘PRIMARY’ | Doctrine\DBAL\Exception\UniqueConstraintViolationException thrown in file deploy/releases/177/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 66.

Test case:

\TYPO3\CMS\IndexedSearch\Utility\IndexedSearchUtility::md5inthash('nam')
and
\TYPO3\CMS\IndexedSearch\Utility\IndexedSearchUtility::md5inthash('nussholz')

will both return 36468906


Related issues

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

History

#1 Updated by Dan Ilea 8 months ago

Duplicate to https://forge.typo3.org/issues/84541 .

Please close this issue.

#2 Updated by Jonas Eberle 8 months ago

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

#3 Updated by Jonas Eberle 8 months ago

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

#4 Updated by Jonas Eberle 8 months ago

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

Also available in: Atom PDF