#95812Record Statistics runs into an error when reaching it's limits
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
Related issues 2
Files 1
History 59
-
Andreas Kalkhoff commented <span data-processor="relativetime" data-value="2021-10-28T12:26:00+00:00" > 10/28/21, 12:26 </span>
-
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>
-
Sybille Peters changed Related to #92493 <span data-processor="relativetime" data-value="2021-11-17T14:27:39+00:00" > 11/17/21, 14:27 </span>
-
Sybille Peters changed Related to #93305 <span data-processor="relativetime" data-value="2021-11-17T14:28:21+00:00" > 11/17/21, 14:28 </span>
-
Georg Ringer commented and changed TYPO3 Version
1014 <span data-processor="relativetime" data-value="2026-09-28T21:32:12+00:00" > 09/28/26, 21:32 </span>still valid in dev-main
-
Gerrit Code Review pushed patch set 2 for main to change 97537 status
NewUnder Review <span data-processor="relativetime" data-value="2026-11-11T12:44:07+00:00" > 11/11/26, 12:44 </span> -
Gerrit Code Review pushed patch set 3 for main to change 97537 <span data-processor="relativetime" data-value="2026-11-11T14:48:11+00:00" > 11/11/26, 14:48 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 97537 <span data-processor="relativetime" data-value="2026-11-11T15:58:21+00:00" > 11/11/26, 15:58 </span>
-
Gerrit Code Review pushed patch set 5 for main to change 97537 <span data-processor="relativetime" data-value="2026-11-15T08:27:53+00:00" > 11/15/26, 08:27 </span>
Edit: Forgot one important bit of info:
Total length of the query: 65440 characters.