#4010 - SQL error running searches on some sites
-
By Chris Graham
- Added
- 3 views
| Identifier | #4010 |
|---|---|
| Issue type | Trivial issue (does not break functionality) |
| Title | SQL error running searches on some sites |
| Status | Completed |
| Handling member | Chris Graham |
| Version | 10.0.28 |
| Addon | core_database_drivers |
| Description | Sites 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. |
| Steps to reproduce | |
| Funded? | No |
| Commits |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
There have been no comments yet