'Events/Show Timeline' - Working properly for anyone?
Posted: Sat Mar 07, 2020 10:17 pm
'Show Timeline' works partially here. Sometimes it just gives a white screen with this logs:
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: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
Does 'Show Timeline' work properly/reliable for anyone on 1.34.5?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