'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: 105
Joined: Wed Jun 12, 2019 5:15 pm

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

Post by Bluemax » Sat Mar 07, 2020 10:17 pm

'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: 1431
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

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

Post by iconnor » Sun Mar 08, 2020 2:22 pm

It does work for me, but I will investigate your issues.

User avatar
iconnor
Posts: 1431
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

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

Post by iconnor » Sun Mar 08, 2020 2:51 pm

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: 105
Joined: Wed Jun 12, 2019 5:15 pm

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

Post by Bluemax » Sun Mar 08, 2020 8:00 pm

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

Who is online

Users browsing this forum: No registered users and 2 guests