zoneminder not deleting all events

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
neuronetv
Posts: 86
Joined: Mon Dec 17, 2012 10:01 pm

zoneminder not deleting all events

Post 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
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: zoneminder not deleting all events

Post by Magic919 »

Try running zmaudit.
-
neuronetv
Posts: 86
Joined: Mon Dec 17, 2012 10:01 pm

Re: zoneminder not deleting all events

Post 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
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: zoneminder not deleting all events

Post by Magic919 »

It would usually log something.
-
User avatar
burger
Posts: 433
Joined: Mon May 11, 2020 4:32 pm

Re: zoneminder not deleting all events

Post 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.
fastest way to test streams:
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl

If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide
User avatar
iconnor
Posts: 3156
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: zoneminder not deleting all events

Post by iconnor »

There is a table called Event_Summaries which is where the console get it's values from.
User avatar
burger
Posts: 433
Joined: Mon May 11, 2020 4:32 pm

Re: zoneminder not deleting all events

Post by burger »

fastest way to test streams:
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl

If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide
Post Reply