Montage Review BUG

Forum for questions and support relating to the 1.30.x releases only.
Locked
Wil
Posts: 7
Joined: Wed Oct 26, 2016 10:13 am

Montage Review BUG

Post by Wil »

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...
SteveGilvarry
Posts: 494
Joined: Sun Jun 29, 2014 1:12 pm
Location: Melbourne, AU

Re: Montage Review BUG

Post by SteveGilvarry »

Wil,
Thanks for taking the time to detail this issue, I can confirm it is a bug and have created an issue to hold the details of the cause. https://github.com/ZoneMinder/ZoneMinder/issues/1812
Steve
Production Zoneminder 1.37.x (Living dangerously)
Random Selection of Cameras (Dahua and Hikvision)
Locked