Problem Events.Id = undefined

Forum for questions and support relating to the 1.24.x releases only.
Locked
Mika
Posts: 19
Joined: Fri Nov 05, 2010 6:57 pm

Problem Events.Id = undefined

Post by Mika »

Hi,

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
I think, the problem is in www/zm/ajax/status.php, but i don't fix it :(

Please help me
thx
Locked