Page 1 of 1

Event totals are not being updated

Posted: Tue Jan 07, 2020 1:08 pm
by jrd
I'm running 1.32.2

I have a similar issue to the one described in viewtopic.php?t=28746

My event totals per time bucket on the console screen are not being updated. The events are there; if I click on the out-of-date numbers I see them all, it looks like it's just the rollup numbers in the DB which aren't being updated.

I don't think it's the same root cause as cited in that thread, because I'm running the older software, which depends on php timezone. I did double-check my timezone settings in my php.ini.

Any other ideas? What's the mechanism which keeps those summary numbers up to date?

Re: Event totals are not being updated

Posted: Tue Jan 07, 2020 3:58 pm
by iconnor
You for some reason do not have the triggers installed. You can install them using the following:

mysql -u zmuser -p zm < /usr/share/zoneminder/db/triggers.sql

Re: Event totals are not being updated

Posted: Thu Jan 09, 2020 2:22 am
by jrd
Yeah, you're right. I wonder how that happened?

Thanks for the hint. I tried it and things seem back to normal. Thanks!