Page 1 of 1

Filter problem?

Posted: Thu Jul 13, 2006 5:01 pm
by dyuen
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

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']
According to the message, I believe that

Code: Select all

E.Cause regexp Motion
should be

Code: Select all

E.Cause regexp 'Motion'
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?

Posted: Fri Jul 14, 2006 11:02 am
by zoneminder
This is a genuine bug which I have fixed for the next version but which is still present in 1.22.2.

I have put a patch up on the Wiki which hopefully fixes this.