No events size

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
mconfortino
Posts: 26
Joined: Sun Oct 24, 2021 8:21 pm
Location: Rawson, Patagonia

No events size

Post by mconfortino »

Hi. Fresh installation of ZM 1.36.33 on Ubuntu server 22.04. The agregate size of events in the console view shows as null.
Image
Any ideas?
If I click on the blue zero at the bottom it takes to the events list, complete wit size and thumbnails.
Thank you
User avatar
iconnor
Posts: 2880
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No events size

Post by iconnor »

Likely the db was created without the automated triggers, so the summary tables aren't being populated.

mysql -u zmuser -p zm < /usr/share/zoneminder/db/triggers.sql
mconfortino
Posts: 26
Joined: Sun Oct 24, 2021 8:21 pm
Location: Rawson, Patagonia

Re: No events size

Post by mconfortino »

Sorry. Couldn't answer earlier. Run the script, no errors, restarted mysql and zm, no changes.
User avatar
iconnor
Posts: 2880
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: No events size

Post by iconnor »

I'm stumped. Check logs.
mconfortino
Posts: 26
Joined: Sun Oct 24, 2021 8:21 pm
Location: Rawson, Patagonia

Re: No events size

Post by mconfortino »

So do I. Nothing in the logs, or at least nothing I can understand. Besides, now I can´t add, delete or clone monitors. Buttons are greyed, and on mouseover a message says 'AddMonitorDisabled' when logged as admin. I created a new user with all privileges, and the message is 'Your user is not allowed to add monitors' . Very strange. It is 1.36.25 running over Ubuntu server 20.04. Iĺl keep investigating. Thank you very much.
mconfortino
Posts: 26
Joined: Sun Oct 24, 2021 8:21 pm
Location: Rawson, Patagonia

Re: No events size (almos solved)

Post by mconfortino »

Good morning. Checked database. Some monitors had no entries in the Event_Summaries table. I added them manually, just the monitor id and zeros in the rest of the fields, and now I have 0 instead of null in the console view.
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: No events size

Post by Magic919 »

Have you checked the triggers are there in the DB?
-
mconfortino
Posts: 26
Joined: Sun Oct 24, 2021 8:21 pm
Location: Rawson, Patagonia

Re: No events size

Post by mconfortino »

Good morning. I did, and also compared with another site, and they are the same.
Post Reply