Actions
Bug #81555
closed
Bug #80875: Multiple problems with relation handler if too many records exist on a page
Do not use prepared statements for reference index queries
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2017-06-12
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
medium
Is Regression:
Sprint Focus:
Remote Sprint
Description
The queries to update the reference index could be very huge and contain a very long list of uids.
When using prepared statements this can end up in a fatal error as "only" 65.536 placeholders are supported in prepared statements.
Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'SELECT `uid`, `t3ver_oid`, `t3ver_state` FROM `tt_address` WHERE (`pid` = ?) AND (`t3ver_oid` IN (?, ?, ?, ?, ### HERE ARE AROUND 70.000 PLACEHOLDERS!### , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`t3ver_wsid` <> ?) ORDER BY `t3ver_state` DESC' with params [-1, 6877, ... ###HERE ARE AROUND 70.000 IDS!###, 0]:
Updated by 
Updated by 
Updated by 
Updated by 
Updated by 
Updated by
Actions