SQL Syntax error in PurgeWhneFull filter
Posted: Thu Nov 09, 2023 3:19 am
I'm receiving this error when it runs the PurgeWhenFull filter
Can't execute filter ' SELECT E.*, unix_timestamp(E.StartDateTime) AS Time, GROUP_CONCAT(T.Name SEPARATOR ", ") FROM Events AS E LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId LEFT JOIN Tags AS T ON T.Id = ET.TagId WHERE ( E.Archived = 0 and 2 >= 90% and E.EndDateTime >= '2023-10-24 22:10:33' ) GROUP BY E.Id ORDER BY E.Id ASC LIMIT 0,1000', ignoring: 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 'and E.EndDateTime >= '2023-10-24 22:10:33' ) GROUP BY E.Id ORDER BY E.Id ...' at line 16
OS: Debian 12.2
ZM: 1.37.47
MariaDB: 10.11.4
Can't execute filter ' SELECT E.*, unix_timestamp(E.StartDateTime) AS Time, GROUP_CONCAT(T.Name SEPARATOR ", ") FROM Events AS E LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId LEFT JOIN Tags AS T ON T.Id = ET.TagId WHERE ( E.Archived = 0 and 2 >= 90% and E.EndDateTime >= '2023-10-24 22:10:33' ) GROUP BY E.Id ORDER BY E.Id ASC LIMIT 0,1000', ignoring: 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 'and E.EndDateTime >= '2023-10-24 22:10:33' ) GROUP BY E.Id ORDER BY E.Id ...' at line 16
OS: Debian 12.2
ZM: 1.37.47
MariaDB: 10.11.4