'Events/Show Timeline' - Working properly for anyone?

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
User avatar
Bluemax
Posts: 121
Joined: Wed Jun 12, 2019 5:15 pm

'Events/Show Timeline' - Working properly for anyone?

Post by Bluemax »

'Show Timeline' works partially here. Sometimes it just gives a white screen with this logs:
03/07/20 23:06:09.127295 web_php[17104].ERR [192.168.1.9] [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 MariaDB server version for the right syntax to use near 'E.MonitorId '1'' at line 1', statement was 'SELECT min(E.StartTime) AS MinTime, max(E.EndTime) AS MaxTime FROM Events AS E INNER JOIN Monitors AS M ON (E.MonitorId = M.Id) WHERE NOT isnull(E.StartTime) AND NOT isnull(E.EndTime) AND E.MonitorId E.MonitorId '1' ' params:] at includes/database.php line 152

03/07/20 23:06:09.127785 web_php[17104].ERR [192.168.1.9] [SQL-ERR dbFetchOne no result, statement was 'SELECT min(E.StartTime) AS MinTime, max(E.EndTime) AS MaxTime FROM Events AS E INNER JOIN Monitors AS M ON (E.MonitorId = M.Id) WHERE NOT isnull(E.StartTime) AND NOT isnull(E.EndTime) AND E.MonitorId E.MonitorId '1' '] at includes/database.php line 161

03/07/20 23:06:09.128354 web_php[17104].ERR [192.168.1.9] [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 MariaDB server version for the right syntax to use near 'E.MonitorId '1' AND EndTime >= '1970-01-01 01:00:00' AND StartTime <= '2020-03-' at line 1', statement was 'SELECT E.* FROM Events AS E INNER JOIN Monitors AS M ON (E.MonitorId = M.Id) WHERE NOT isnull(StartTime) AND E.MonitorId E.MonitorId '1' AND EndTime >= '1970-01-01 01:00:00' AND StartTime <= '2020-03-07 23:06:09'' params:] at includes/database.php line 152
Reopening ZM and doing it again usually leads to a working interface. All functions seems to work but 'zoom-out' It leads to a partially corrupt interface without any data. Needs, again, re-opening ZM.
03/07/20 23:05:56.405565 web_php[14206].ERR [192.168.1.9] [Unknown aspect ratio 0] at skins/classic/css/base/views/timeline.css.php line 35
Does 'Show Timeline' work properly/reliable for anyone on 1.34.5?
User avatar
iconnor
Posts: 2900
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 'Events/Show Timeline' - Working properly for anyone?

Post by iconnor »

It does work for me, but I will investigate your issues.
User avatar
iconnor
Posts: 2900
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: 'Events/Show Timeline' - Working properly for anyone?

Post by iconnor »

Can you post the url in the url bar? It contains the filter rules used to generate the sql. For some reason we are missing the = but we default to =... so there must be something else in there.
User avatar
Bluemax
Posts: 121
Joined: Wed Jun 12, 2019 5:15 pm

Re: 'Events/Show Timeline' - Working properly for anyone?

Post by Bluemax »

I've flushed all events in the meantime, created some forced alarms and all timeline page hits are working. I cannot reproduce the bug atm. There is still a chance that it occurs only at a much more crowded event list. I will keep the list growing.

Ccurrent (working) url:

Code: Select all

http://192.168.2.1/zm/?view=timeline&filter[Query][terms][0][attr]=MonitorId&filter[Query][terms][0][op]==&filter[Query][terms][0][val]=1
ZoneMinder v1.34.5.
Post Reply