create filter for email notification - SQL ERROR

Forum for questions and support relating to the 1.32.x releases only.
Post Reply
modd1
Posts: 2
Joined: Tue Feb 19, 2019 7:40 pm

create filter for email notification - SQL ERROR

Post by modd1 »

Hi together,

i need some help, after my homeserver vg group was crashed, i have to install it new from scratch, because i had forgot to take a backup from my configurations...

So I have installed Ubuntu Server 18.04, with zoneminder 1.32.3, i have used the following guides.

Install - https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way
dedicated drive - https://wiki.zoneminder.com/Using_a_ded ... Hard_Drive
email conf - https://wiki.zoneminder.com/How_to_get_ ... Zoneminder


My old own was an installation with zoneminder 1.29.x and upgrade to the latest one and runs without such problems, but the freshly new installation get me in some trouble.


My problem, i am at step to create an email filter under menu filters. (see attachments - zm_mail_filter), then when i click on list matches or execute,
then i will get an empty overview without events and in the log file i see SQL errors (see attachments - zm_sql_error).

Kind Regards
Attachments
zm_sql_error.png
zm_sql_error.png (198.43 KiB) Viewed 1071 times
zm_empty_result.png
zm_empty_result.png (15.62 KiB) Viewed 1071 times
zm_mail_filter.png
zm_mail_filter.png (34.54 KiB) Viewed 1071 times
User avatar
iconnor
Posts: 2900
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: create filter for email notification - SQL ERROR

Post by iconnor »

IS is not what you want. It is really only used for testing for NULL. You want Equals.
modd1
Posts: 2
Joined: Tue Feb 19, 2019 7:40 pm

Re: create filter for email notification - SQL ERROR

Post by modd1 »

Hi iconnor,

that's it. it works. thanks.
Post Reply