Montage Review BUG
Posted: Mon Mar 13, 2017 11:29 am
Using ZM 1.30.0 on Ubuntu 16.04.1 LTS
With firefox.
When you create a user, you can choose the monitors he sees.
If you allow him to see only four of your five monitors (by picking those up in the list when configuring the user account) you'll be facing a BUG.
If this user checks the Montage Review or if he wants to see the "All Events" tab, the window freeze and you'll see this error message in the log :
SQL-ERR 'SQLSTATE[42S22]: Column not found : 1054 Unknown column 'M.Id' in 'where clause", statement was 'select E.Id as eIk, E.MonitorId,
UNIX_TIMESTAMP(DATE_ADD(E.StartTime, Interval Delta Second)) as TimeStampSecs, max(F.Score) as Score from Events as E inner join Frames as
F on (E.EvenId = E.Id) where not isnull(StartTime) and F.Score>0 AND M.Id IN (5,6,7,1)group by E.Id, E.MonitorId, F.TimeStamp order by E.MonitorId,
F.TimeStamp asc'
And after that a lot of backtrace errors messages are comming...
With firefox.
When you create a user, you can choose the monitors he sees.
If you allow him to see only four of your five monitors (by picking those up in the list when configuring the user account) you'll be facing a BUG.
If this user checks the Montage Review or if he wants to see the "All Events" tab, the window freeze and you'll see this error message in the log :
SQL-ERR 'SQLSTATE[42S22]: Column not found : 1054 Unknown column 'M.Id' in 'where clause", statement was 'select E.Id as eIk, E.MonitorId,
UNIX_TIMESTAMP(DATE_ADD(E.StartTime, Interval Delta Second)) as TimeStampSecs, max(F.Score) as Score from Events as E inner join Frames as
F on (E.EvenId = E.Id) where not isnull(StartTime) and F.Score>0 AND M.Id IN (5,6,7,1)group by E.Id, E.MonitorId, F.TimeStamp order by E.MonitorId,
F.TimeStamp asc'
And after that a lot of backtrace errors messages are comming...