Zones on Console UI always says 0

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

[jubishop]

My logs are good except it does occasionally say "Monitor 4 has incorrect zone_count 0 != 1" (insert any Monitor number)

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

[adam.robertson]

I am having this same issue. Were you able to resolve it?

I am running 1.37 on Debian Bookworm

[dougmccrary]

I may be mis-remembering, but I think when I saw this, going into the zone and saving it again corrected the count.

[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