filter throwing mySql syntax error
Posted: Fri Jul 26, 2024 1:42 pm
I have set up a filter to send me email alerts whenever a movement is detected. The movements are captured flawlessly, but the filter throws errors. Any idea how to fix this? See:
Code: Select all
Can't execute filter 'SELECT E.*, unix_timestamp(E.StartDateTime) as Time
FROM Events as E
WHERE ( E.MaxScore >= 1 and E.AlarmFrames = ) AND ( E.Emailed = 0 )
ORDER BY E.Id ASC LIMIT 0,100',
ignoring: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near
') AND ( E.Emailed = 0 ) ORDER BY E.Id ASC LIMIT 0,100'
at line 4