Bug #88557
closed
Indexed Search: generates identical word ids for different words
0%
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
Updated by Dan Ilea almost 5 years ago
Duplicate to https://forge.typo3.org/issues/84541 .
Please close this issue.
Updated by Jonas Eberle almost 5 years ago
- Related to Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error added
Updated by Jonas Eberle almost 5 years ago
- Related to deleted (Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error)
Updated by Jonas Eberle almost 5 years ago
- Is duplicate of Bug #84541: Uncaught TYPO3 Exception in indexed_search: duplicate key (hash) error added
Updated by Riccardo De Contardi about 4 years ago
- Status changed from New to Closed
I close this issue as a duplicate of #84541; please continue the discussion there.
If you think that this is the wrong decision, please reopen it or ping me. Thank you.