Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
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 |
| Sprint | 5.11.0 Sprint 6 [ 206 ] | 5.11.0 Sprint 6, 5.11.0 Sprint 7 [ 206, 207 ] |
| Rank | Ranked higher |
| Assignee | Abdy Franco [ abdy ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 1 hour, 8 minutes [ 4080 ] | |
| Worklog Id | 17486 [ 17486 ] |
| Status | Open [ 1 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
