Page 1 of 1

No events size

Posted: Thu Mar 16, 2023 12:05 pm
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

Re: No events size

Posted: Thu Mar 23, 2023 11:59 pm
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

Re: No events size

Posted: Wed Mar 29, 2023 6:45 pm
by mconfortino
Sorry. Couldn't answer earlier. Run the script, no errors, restarted mysql and zm, no changes.

Re: No events size

Posted: Wed Mar 29, 2023 10:58 pm
by iconnor
I'm stumped. Check logs.

Re: No events size

Posted: Thu Mar 30, 2023 11:14 pm
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.

Re: No events size (almos solved)

Posted: Fri Mar 31, 2023 10:18 am
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.

Re: No events size

Posted: Fri Mar 31, 2023 1:29 pm
by Magic919
Have you checked the triggers are there in the DB?

Re: No events size

Posted: Tue Apr 04, 2023 2:39 pm
by mconfortino
Good morning. I did, and also compared with another site, and they are the same.