Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 5.10.0
-
Fix Version/s: 5.11.0-b2
-
Component/s: None
-
Labels:None
Description
On MariaDB 10.6, and possibly other newer versions of MariaDB, the following error is written to logs when the automation task "Clean Up Logs" runs.
0 old Email logs have been deleted. Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN `messengers` ON `messengers`.`id`=`log_messenger`.`messenger_id` W...' at line 1 #0
The potential fix is to update app/models/logs.php around line 1417 to change:
$this->Record->delete();
to:
$this->Record->delete(['log_messenger.*']);
Waiting on confirmation that this does resolve the issue.
Activity
Paul Phillips
created issue -
Paul Phillips
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Rank | Ranked higher |
| Sprint | 5.11.0 Sprint 6 [ 206 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |