View Issue Details

IDProjectCategoryView StatusLast Update
0004010Composrcore_database_driverspublic2019-12-15 16:24
ReporterChris GrahamAssigned ToChris Graham 
Status resolvedResolutionfixed 
Product Version10.0.28 
Fixed in Version10.0.29 
Summary0004010: SQL error running searches on some sites
DescriptionSites running:
 - MySQL v8 or newer
 - With block caching enabled

May get SQL errors running some searches. Whether an error is seen is likely a complicated interaction between different cache settings/status.

This is caused by an error in our code that rewrites queries to be MySQL-8-compatible. The search system causes comments to be appended queries, so slow running queries can be tracked and killed. however the query rewrite code doesn't handle this correctly.
TagsNo tags attached.
Attach Tags
Time estimation (hours)
Sponsorship open



2019-12-15 16:24

administrator   ~0006237

Fixed in git commit 8c07d0817 ( - link will become active once code pushed to GitLab)

A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (

hotfix-4010, 2019-12-15 4pm.tar (21,504 bytes)

Issue History

Date Modified Username Field Change