Filter problem?
Posted: Thu Jul 13, 2006 5:01 pm
Hi
I am using Zoneminder ver. 1.22.2.
I have made a filter that will show all the events that is caused by Motion and sent notification message to an email account, which is configured properly(tested); however, I found the following message in zmfilter.log
should be
I tried to put single quote in the filter window by typing \'Motion\', the single quote does save in database, but when ZM sends email, ZM takes the quote off before generating the query above ... 
Does anyone encounter this situation? Or did I do anything wrong?
I am using Zoneminder ver. 1.22.2.
I have made a filter that will show all the events that is caused by Motion and sent notification message to an email account, which is configured properly(tested); however, I found the following message in zmfilter.log
According to the message, I believe that
07/13/06 08:50:41.214813 zmfilter[27163].ERR [Can't execute filter 'select E.Id,
E.MonitorId,M.Name as MonitorName,M.DefaultRate,M.DefaultScale,E.Name,E.Cause,E.
Notes,E.StartTime,unix_timestamp(E.StartTime) as Time,E.Length,E.Frames,E.AlarmF
rames,E.TotScore,E.AvgScore,E.MaxScore,E.Archived,E.Videoed,E.Uploaded,E.Emailed
,E.Messaged,E.Executed from Events as E inner join Monitors as M on M.Id = E.Mon
itorId where not isnull(E.EndTime) and ( E.Cause regexp Motion ) and ( E.Emailed
= 0 ) order by E.StartTime asc', ignoring: Unknown column 'Motion' in 'where cl
ause']
Code: Select all
E.Cause regexp Motion
Code: Select all
E.Cause regexp 'Motion'

Does anyone encounter this situation? Or did I do anything wrong?