when click un one event of my monitor, i get this error:
Code: Select all
[Fri Nov 12 12:53:24 2010] [error] [client 192.168.1.100] SQL-ERROR(CD9B74):
select Events.Id as Id, MonitorId, Name, Cause, StartTime,
date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, EndTime, Width, Height, Length, Frames, AlarmFrames, TotScore, AvgScore, MaxScore,
Archived, Videoed, Uploaded, Emailed, Messaged, Executed, Notes, min(Frames.FrameId) as MinFrameId, max(Frames.FrameId) as MaxFrameId,
min(Frames.Delta) as MinFrameDelta, max(Frames.Delta) as MaxFrameDelta
from Events
left join Frames on Events.Id = Frames.EventId
where Events.Id = undefined
group by Frames.EventId
limit 1, referer:
http://192.168.1.2:8080/index.php?view=event&eid=1&trms=1&attr1=MonitorId&op1=%3d&val1=7&page=1
[Fri Nov 12 12:53:24 2010] [error] [client 192.168.1.100] SQL-ERROR(CD9B74): Unknown column 'undefined' in 'where clause',
referer: http://192.168.1.2:8080/index.php?view=event&eid=1&trms=1&attr1=MonitorId&op1=%3d&val1=7&page=1

Please help me
thx