Issue Bug Closed

#81555Do not use prepared statements for reference index queries

Sascha Egerer 06/12/17, 17:23 updated 10/02/18, 10:59

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]:

Reviews 2