Issue Bug Under Review

#95812Record Statistics runs into an error when reaching it's limits

Andreas Kalkhoff 10/28/21, 12:23 updated 11/15/26, 08:27

Description

Hi,

for a bit of a larger installation, during my quest to resolve some DB-related issues, I tried to fetch the “Records Statistics” using the module “DB Check”.
I suppose the maximum size for a SQL-Query has been reached. While the screenshot only displays a short extract, here some numbers:
Amount of placeholders (“?”): 9899 (/9898 commata)
Amount of filled parameters in that statement: 5101
The whole thing does end on a comma and it’s just cut off at that point.

Amount of active pages in the installation (excluding folders, dividers, etc.): 4982
Amount of pages still “existing” (excluding folders, dividers, etc.): 8663

The table blackened is an extension table, no core-related table.

Best Regards
Andreas

Reviews 1

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch

Commit message
[BUGFIX] Record Statistics runs into an error when reaching it's limits Resolves: #95812 Releases: main

Files 1

History 59

  1. Andreas Kalkhoff commented <span data-processor="relativetime" data-value="2021-10-28T12:26:00+00:00" > 10/28/21, 12:26 </span>

    Edit: Forgot one important bit of info:
    Total length of the query: 65440 characters.

  2. Sybille Peters changed Tags large-site, placeholderlimit, db, prepared statement <span data-processor="relativetime" data-value="2021-11-17T14:27:18+00:00" > 11/17/21, 14:27 </span>

  3. Georg Ringer commented and changed TYPO3 Version 10 14 <span data-processor="relativetime" data-value="2026-09-28T21:32:12+00:00" > 09/28/26, 21:32 </span>

    still valid in dev-main