Bug #95812
open
Record Statistics runs into an error when reaching it's limits
0%
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
Files
Updated by Andreas Kalkhoff about 3 years ago
Edit: Forgot one important bit of info:
Total length of the query: 65440 characters.
Updated by Sybille Peters almost 3 years ago
- Tags set to large-site, placeholderlimit, db, prepared statement
Updated by Sybille Peters almost 3 years ago
- Related to Bug #92493: linkvalidator: scheduler task + list of broken links dies if too many pages ("Prepared statement contains too many placeholders") added
Updated by Sybille Peters almost 3 years ago
- Related to Task #93305: Long lists of parameters in QueryBuilder handled differently ("too many placeholders") added