Page 1 of 1
Zones on Console UI always says 0
Posted: Mon May 13, 2024 8:15 pm
by jubishop
Everything is good except on the main Console UI, it says I have 0 zones for cameras when I actually have 1. I can't figure out what must be wrong in my DB or elsewhere... (note the last row on the right which is 0)
Re: Zones on Console UI always says 0
Posted: Mon May 13, 2024 8:16 pm
by jubishop
My logs are good except it does occasionally say "Monitor 4 has incorrect zone_count 0 != 1" (insert any Monitor number)
Re: Zones on Console UI always says 0
Posted: Mon May 13, 2024 10:24 pm
by jubishop
I can open up the mysql console and they definitely have zones. I can run select queries against the monitorIds and the zones show up. And they are working. I don't get why the UI doesn't show them...
Re: Zones on Console UI always says 0
Posted: Tue Mar 25, 2025 2:22 pm
by adam.robertson
I am having this same issue. Were you able to resolve it?
I am running 1.37 on Debian Bookworm
Re: Zones on Console UI always says 0
Posted: Tue Mar 25, 2025 8:19 pm
by dougmccrary
I may be mis-remembering, but I think when I saw this, going into the zone and saving it again corrected the count.
Re: Zones on Console UI always says 0
Posted: Wed Apr 02, 2025 9:56 pm
by adam.robertson
Running this sql query updates all the monitor counts:
Update Monitors set ZoneCount=(SELECT COUNT(*) FROM Zones WHERE MonitorId=Monitors.Id);
..ran across that somewhere and it works, so I just have it book-marked in phpmyadmin so I can run it any time I delete/add a zone and get those log errors