Bug #97532
closed
Indexed_search - Error: Commands out of sync; you can't run this command now - if more than 999 words counted
100%
Description
On latest TYPO3 LTS Version 11.5.9 (also testet in 11.5.3) running indexed_search throws error "Commands out of sync; you can't run this command now" on a page where word count excites 999. In Backend "Indexing" "Words & content" it shows 0 at words. And after clearing caches the error is shown in frontentd (Debug --> on). After refreshing the page it shows up without errors. The page cant be found in frontend search.
PHP Version is 7.4. Database is MariaDB Version 10.5.15.
Files
Updated by Georg Ringer over 2 years ago
- Status changed from New to Needs Feedback
this is more likely an issue of maria db, see https://mariadb.com/kb/en/server-system-variables/#in_predicate_conversion_threshold
please set in_predicate_conversion_threshold = 4294967295 in your my.cnf and it should be fine after restart.
Updated by Thorsten Geißler over 2 years ago
- % Done changed from 0 to 100
This solved the problem. Thx Georg
Updated by Georg Ringer over 2 years ago
- Status changed from Needs Feedback to Closed
closing issue as solved