SQL error on Video Export

[DervMan]

Hi all,

v1.24.2 installed via apt-get on Ubuntu 10.04 LTS

I'm trying to create a Video from the event page, I've never tried it before so don't know if it's ever worked.

when clicking the 'video' button I get

Code: Select all

An error has occurred and this operation cannot continue.
For full details check your web logs for the code '10F96A'

The error code actually changes each time.

I'm seeing nothing when using 'tail -f /tmp/zm*'

But I do see this in the apache error.log

Code: Select all

[Wed Jun 14 19:44:18 2011] [error] [client x.x.x.x] SQL-ERROR(10F96A): 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: http://xxxx.homelinux.net/zm/index.php?view=event&eid=32004&filter[terms][0][attr]=Archived&filter[terms][0][op]=%3D&filter[terms][0][val]=0&filter[terms][1][cnj]=and&filter[terms][1][attr]=DateTime&filter[terms][1][op]=%3E%3D&filter[terms][1][val]=-1+day&filter[terms][2][cnj]=and&filter[terms][2][attr]=MonitorId&filter[terms][2][op]=%3D&filter[terms][2][val]=9&sort_field=StartTime&sort_asc=0&page=1


[Wed Jun 14 19:44:18 2011] [error] [client x.x.x.x] SQL-ERROR(10F96A): Unknown column 'undefined' in 'where clause', referer: http://xxxx.homelinux.net/zm/index.php?view=event&eid=32004&filter[terms][0][attr]=Archived&filter[terms][0][op]=%3D&filter[terms][0][val]=0&filter[terms][1][cnj]=and&filter[terms][1][attr]=DateTime&filter[terms][1][op]=%3E%3D&filter[terms][1][val]=-1+day&filter[terms][2][cnj]=and&filter[terms][2][attr]=MonitorId&filter[terms][2][op]=%3D&filter[terms][2][val]=9&sort_field=StartTime&sort_asc=0&page=1

I've made the modification to 'export_functions.php' as shown in another post.

Any ideas?

[mariozlo]

I have the same problem and obviously no one knows solution