filter throwing mySql syntax error

[aag]

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

[iconnor]

Set a value for alarmframes?

[aag]

thanks, you are right and it's solved! It's a great software btw, I am totally impressed (even if I'm still struggling with all the features).