Actions
Bug #102375
closedData too long for column 'cookie' when inserting into index_stat_search
Start date:
2023-11-15
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:
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
Actions