Page 1 of 1
zoneminder not deleting all events
Posted: Fri Oct 27, 2023 1:32 pm
by neuronetv
I'm running zm 1.36.5 on a raspberry pi 3.
one of my cameras shows over 4000 events but I can't delete them. so in a console I went to /var/cache/zoneminder/events and deleted all the images for that camera but the zm gui is still showing >4000 events and they won't delete from the gui. I know I must have messed up somewhere but how do I straighten this out? I'd prefer not to delete and recreate the camera if possible, thanks for any advice
Re: zoneminder not deleting all events
Posted: Fri Oct 27, 2023 4:30 pm
by Magic919
Try running zmaudit.
Re: zoneminder not deleting all events
Posted: Fri Oct 27, 2023 4:38 pm
by neuronetv
thankyou I ran /usr/bin/zmaudit.pl and it processed many open events and ended them with 'closing' but in the gui it still says there are >4000 events for the same camera
Re: zoneminder not deleting all events
Posted: Fri Oct 27, 2023 7:24 pm
by Magic919
It would usually log something.
Re: zoneminder not deleting all events
Posted: Sat Dec 23, 2023 4:25 am
by burger
What worked for me, for 1 camera was to go to
https://wiki.zoneminder.com/MySQL#Backup_config_only
do a config backup only. Restore following the instructions afterwards. Then when the events are actually gone do two things:
1) run zmaudit
2) start recording on the camera
It should reset the event stats on the website. The only problem, is that this worked with only one camera and I have 40 cameras. So there must be a better solution in bulk. But it did work for any camera that I restarted recording on. You can verify the events are gone by selecting * from Events_Day; but for some reason they still show on the GUI until the camera starts recording again. I'm not sure why. I don't think it's a cache issue on the client side / browser.
Re: zoneminder not deleting all events
Posted: Sun Dec 24, 2023 3:23 pm
by iconnor
There is a table called Event_Summaries which is where the console get it's values from.
Re: zoneminder not deleting all events
Posted: Sun Dec 24, 2023 7:48 pm
by burger