Email Alerts Emailing Constantly

pigpen · Post by **pigpen** » Tue May 25, 2010 12:13 am

Ok, so I have followed much of the advice from various sources. When creating a filter rule (running in background, no submitting or executing), zoneminder will constantly send email alerts. Anyway to work around this? I have tried this on 1.22.x and 1.23.x systems.

I have a very urgent need for this.

Thanks!

Mark

kingofkya · Post by **kingofkya** » Tue May 25, 2010 2:32 am

What do you means work around it i don't see what your trying to do stop email or get the emails to send.

pigpen · Post by **pigpen** » Tue May 25, 2010 2:57 am

Well, it should be sending alerts for new events only, however it will start sending alerts for every alert in the database prior to defining and enabling the filter.
I will get 100+ messages per min. I want 1 email per current event...not for events that happened a year ago....

kingofkya · Post by **kingofkya** » Tue May 25, 2010 4:40 am

yeah i had this problem i think i had to set a flag on all events in db.

Edit:
Run this on mysql db:

Code: Select all

UPDATE `zm`.`Events` SET `Emailed` = '1' WHERE `Emailed` = 0

pigpen · Post by **pigpen** » Tue May 25, 2010 5:11 am

Perfect! Thanks!! Now I can sleep better knowing I can call the Sheriff on time!