zoneminder not deleting all events

[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]

Try running zmaudit.

[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]

It would usually log something.

[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.

[iconnor]

There is a table called Event_Summaries which is where the console get it's values from.

[burger]

That explains it. https://wiki.zoneminder.com/MySQL#Backup_config_only updated.