ZoneMinder Forums

When clicking on live image in montage mode, the live image comes up, but there are no recent events.

2020-05-10 18:50:58 web_php 3129 ERR Sort field Id not in SQL Fields /usr/share/zoneminder/www/ajax/status.php 291
2020-05-10 18:50:58 web_php 3129 ERR SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC limit 20' at line 1', statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartTime`, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY DESC limit 20' params:1 /usr/share/zoneminder/www/includes/database.php 152
2020-05-10 18:50:58 web_php 3129 ERR SQL-ERR dbFetchAll no result, statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartTime`, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY DESC limit 20'params: 1 /usr/share/zoneminder/www/includes/database.php 185

It works as expected in the latest release 1.34, but current 1.35 breaks it. I think the one a week ago also breaks it.
When I installed 1.35, it said the db was updated successfully.

That's on ubuntu 18.04, in case it matters.

fixed in latest master

Isaac -
The the error report is gone, but there is no list of recent events, either...just the column names.
I initially had the looping refresh mentioned elsewhere, and a new install fixed that.
Installed the easy way script for ubuntu 18.04, except changed the ppa to master, so no update.
From the morning 5-11 snapshot.

The fix is going to be harder than I thought.

Bummer. Sorry.

You fixed it.

Hello!
I'm running Debian Stretch 9 con a 64bit system
I've just installed zoneminder latest version 1.35.3~20200509.27-stretch (amd64) and seems that this problem is still here.
I can reproduce the exact issue by forcing an alarm on a monitor.
This is the complete listing:
Just for test I've added a simple monitor (monitor mode) of type "File" that points to a jpg on the local system.

I've noticed that the same issue as @dougmccrary (clicking on live image in montage mode)

1.35.3 is old. Update.

According to the zmrepo, on Debian Stretch this seems to be the last version for amd64 .. it there a newer version that's not listed there??
This is the repo I'm using.
https://zmrepo.zoneminder.com/debian/master/stretch/

Apparently compile was failing on stretch. Fixed. repo now has 1.35.5.

Ok thanks. Now seems fixed.