SQL Syntax error in PurgeWhneFull filter

[KTownKnerd]

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

[iconnor]

Don't put the percent symbol in the value.

[KTownKnerd]

Thank you. That worked.

[iconnor]

Latest version will not allow non-number inputs anymore.