Bug #102375
closed
Data too long for column 'cookie' when inserting into index_stat_search
0%
Description
Hi there,
today I updated a website to TYPO3 ELTS 10.4.41 and now the indexed_search throws the following error when performing a search request:
An exception occurred while executing 'INSERT INTO `index_stat_search` (`searchstring`, `searchoptions`, `feuser_id`, `cookie`, `IP`, `hits`, `tstamp`) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["...", "...", 123, "4acf8ddc34c4bd2f20fe09de9b95e1dd.a0434104194776105dcb902219b99f71af58d82724f5e7ea2eaac9d7e89d7ac3", "...", 4, 1700048704]: Data too long for column 'cookie' at row 1
I guess it is a combination of MySQL strict mode and the cookie security fix: https://github.com/typo3/typo3/commit/8fdec56561
Most likely TYPO3 11.5.33 and 12.4.8 are also affected (not tested).
- Remove cookie column from index_stat_search (why is this stored anyway?)
- Truncate cookie value after 32 chars
- Increase size of cookie column
Updated by
Updated by Georg Ringer over 1 year ago
thanks for the issue! this is a problem which only happens in v10 (ELTS) as the functionality has been removed with v11 (See #92993)
I am closing the issue - nevertheless should be fixed in the ELTS
Updated by Oliver Hader over 1 year ago
Table index_stat_search (and the feature) was removed in TYPO3 v11. Thus, it seems to be ELTS only - up to and including TYPO3 version 10.
Updated by Oliver Hader over 1 year ago
- Related to Task #92993: Remove personalized search statistics from indexed search added
Updated by Christian Kuhn 12 months ago
- Status changed from New to Closed
Hey.
I hope it's ok to close here since it affects an ELTS core version, only.