Error to see events when checked more than one event.

[beyonlo]

Hey all,

I install ZM 1.23.2, and works fine, but I have the problem to see events when I check more than one event and after click in "View" button.

New window open and show fine the first event, but when try start automatically the second event the window show this message: "An error has occurred and this operation cannot continue.
For full details check your web logs for the code '6E2D6D'"

So, after I check in apache2 log and have this error:

root@s1:/var/www/html/zm# tail -f /var/log/apache2/error.log
[Tue Apr 01 08:41:38 2008] [error] [client 192.168.0.6] SQL-ERROR(A700FE): select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.StartTime >= '2008-04-01 08:29:52' and ( E.Id in (211%2C210) ) order by E.StartTime asc limit 100, referer: http://192.168.0.5:8090/html/zm/index.p ... e=1&play=1
[Tue Apr 01 08:41:38 2008] [error] [client 192.168.0.6] SQL-ERROR(A700FE): Unknown column '2C210' in 'where clause', referer: http://192.168.0.5:8090/html/zm/index.p ... e=1&play=1
[Tue Apr 01 08:42:42 2008] [error] [client 192.168.0.6] SQL-ERROR(AE374B): select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.StartTime >= '2008-04-01 08:29:52' and ( E.Id in (211%2C210) ) order by E.StartTime asc limit 100, referer: http://192.168.0.5:8090/html/zm/index.p ... e=1&play=1
[Tue Apr 01 08:42:42 2008] [error] [client 192.168.0.6] SQL-ERROR(AE374B): Unknown column '2C210' in 'where clause', referer: http://192.168.0.5:8090/html/zm/index.p ... e=1&play=1

That is one SQL error only I think. But I Don't know what is wrong. If is any configuration or what ? Anyone have any idea ?

Thanks,

Beyonlo

[DocSavage]

I am getting this same error on a debian system with MySql 5.* - i think it is a quoting error. When I run that query by hand it gives the error. When I change it to:

select E.* from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.StartTime <= '2008-04-22 08:48:32' and ( E.Id in ('2%2C3%2C4') ) order by E.StartTime desc limit 100 it does return a row...

I am trying to dope out where that query is constructed but am having a bit of difficulty figuring out where it is!