Page 1 of 1

SQL-Error "unknown column" when clicking [video] in an event

Posted: Wed Nov 30, 2011 9:56 am
by meon
Hello Zoneminder-Community!

I was just happy to have installed everything correctly from repo with an Ubuntu 10.04 Server,
and added a simple apexis Camera to the Wiki.

But when i tried to export an event to Video, the following errors occured at /var/log/apache2/error.log:

Code: Select all

[error] [client xx.xx.xx.xx] SQL-ERROR(9CE722): select E.*,M.Name as MonitorName,M.Width,M.Height,M.DefaultRate,M.DefaultScale from Events as E inner join Monitors as M on E.MonitorId = M.Id where E.Id = undefined, referer: xx.xx.xx.xx/zm/?view=event&eid=16&filter[terms][0][attr]=MonitorId&filter[terms][0][op]=%3D&filter[terms][0][val]=3&sort_field=StartTime&sort_asc=1&page=1
and

Code: Select all

[error] [client 192.168.0.12] SQL-ERROR(9CE722): Unknown column 'undefined' in 'where clause', referer: xx.xx.xx.xx/zm/?view=event&eid=16&filter[terms][0][attr]=MonitorId&filter[terms][0][op]=%3D&filter[terms][0][val]=3&sort_field=StartTime&sort_asc=1&page=1
In Case of being unexperienced with zoneminder please help me by giving a little help where or what for i have to start research. Sorry had to remove http from text...

Best regards!
mEon

Re: SQL-Error "unknown column" when clicking [video] in an e

Posted: Wed Nov 30, 2011 9:56 pm
by PacoLM
First of all, try to delete and re-create the same monitor.

Re: SQL-Error "unknown column" when clicking [video] in an e

Posted: Mon Sep 28, 2015 2:36 pm
by meon
Thanks, that worked....