Ghost event on Console view

[pygr]

I've deleted all events using the web UI and then ran zmaudit.pl. On the Console view of the web UI, the numbers of Total, Day, Week, and Month events show as 0. The number of Hour events shows as 1! There are no files in the event storage partition, which is separate from the partition for the root file system.

Immediately after new events occur, the number of Hour events shows as 1 more than the number of Total, Day, Week, and Month events.

How do I get rid of this ghost Hour event?

I wonder if the cause of this behavior is that ZoneMinder was upgraded to 1.37.41, then reverted to 1.37.40, which included a delete of the 1.37.41 database and a restore of a previously backed up 1.37.40 database https://wiki.zoneminder.com/MySQL#Backup. (ZoneMinder version 1.37.41 didn't work for me.viewtopic.php?t=32651)

[dougmccrary]

You could go directly to the db, or save the Monitors table, nuke the db and restore Monitors.

[pygr]

OK. What table and column of the db is shown as the "Hour" event count in the web Console view?

Edit --
The fix:

Code: Select all

mysql> use zm;
mysql> UPDATE Event_Summaries SET HourEvents = 0 WHERE MonitorId = 1;
mysql> SELECT * FROM Event_Summaries;

The last line displays the table so you can verify the edit of the db.

Thank you for the suggestion Doug, the issue seems to be fixed now.

[dougmccrary]

Good job.