Page 1 of 1

failing when trying to export or make video

Posted: Sun Apr 17, 2011 7:13 pm
by steffan
Hi guys,

first of all, sry for my bad english, im danish :) but im sure you will understand..
since my raid5 crashed some nights ago, my zoneminder server was lost, so im creating a new one since i like zoneminder so much :)

i set up an ubuntu 10.10 server edition, with zoneminder v 1.24.2, with a axis webcam.. wich is working great !...... but
i cant export to zip or tar, i just says "export filed", and nothing else happens, is this a known issue?
then i tried to go to the "Video" tab on an event, to generate an avi file of the event, but as soon a i click the "Video" link i get an error saying:

Code: Select all

An error has occurred and this operation cannot continue.
For full details check your web logs for the code '<random number/letter combination >'
Then i went to the apache2 log, and seached for the random number/letter combination and found this:

Code: Select all

[Sun Apr 17 20:48:23 2011] [error] [client <ip of computer accessing the webinterface of zoneminder>] SQL-ERROR(AD06A8): Unknown column 'undefined' in 'where clause', referer: hxxp://<ip of server>/index.php?view=event&eid=1&filter[terms][0][attr]=MonitorId&filter[terms][0][op]=%3D&filter[terms][0][val]=1&sort_field=StartTime&sort_asc=1&page=1
(http replaced with hxxp, and ip's removed due to spammy-new-user protection :) )

From what i can see, its seaching the sql database for "undefined" which does not exists, and therefore the error..
But my question here is then, where the hell does it get the "Undefined" from? clearly someone something is not defined???, but what is not defined?? anyone here who knows? any help would help a LOT!

(i will not be around to answer the rest of the day today, but i will check back as the first thing tomorrow!)

Thanks
-Steffan

Re: failing when trying to export or make video

Posted: Mon Apr 18, 2011 1:23 pm
by steffan
huh,
Wierd,
i just noticed. that if i press the events number on the front page, so i can view the list of all the events, and i mark one in the right side and press export, it works !.. but if i click an event to view it, and press export in there, is doesn't?! isnt that the same function? how comes it works at one location and not the other ? anyone who can help ?
(if you dont understand my cryptic description, feel free to ask for screenshots :) )

Re: failing when trying to export or make video

Posted: Mon Apr 18, 2011 2:00 pm
by steffan
Hmm.. another thing, i can archive events, but i cant unarchive them.. does the files get moved when they get archived? (then it might be a permission problem in my case i think)

Re: failing when trying to export or make video

Posted: Mon Apr 18, 2011 9:11 pm
by mastertheknife
steffan wrote:Hmm.. another thing, i can archive events, but i cant unarchive them.. does the files get moved when they get archived? (then it might be a permission problem in my case i think)
Hi, check this:
http://www.zoneminder.com/forums/viewto ... =9&t=15272

mastertheknife.

Re: failing when trying to export or make video

Posted: Tue Apr 19, 2011 6:46 am
by steffan
mastertheknife wrote:
Hi, check this:
http://www.zoneminder.com/forums/viewto ... =9&t=15272

mastertheknife.
Thanks man, will try it right away and report back if it works :)

EDIT:
That did the tricks :D thanks for posting me the link :)


Now i still have the other 2 problems, anyone have any idears there ?? thanks

Re: failing when trying to export or make video

Posted: Tue Apr 19, 2011 10:53 am
by steffan
Hi.. again, again..

i have been digging into the zoneminder files the last few hours, and as far as i can see, the problem is the same everywhere.. if i open an event (not events, but a single event) i have the menu bar at top, with "export, video, frames ......." those does not get the eid portet when i click them.. from the eventS (where you can see all the events) the buttons at the buttom works like they should, however not the case on the single event page..

Does anyone know in what file, or where the event page is supposed to put the eid in order to get it to the export / video / frames .... links ??
Would help a lot, since i think this will fix all my problems :D

( i think somewhere in event.php the eid is not getting "Fetched" from the url ?)

Well, i almost give up.. cant find anywhere that doesn't look normal.. any help would be great, an idear... anything :P

EDIT:

Found this post.. http://www.zoneminder.com/forums/viewto ... 793#p68793
And it seems like im not the only one with this problem.. i just fired up an old vista laptop i found to test with IE8, and it worked.... so, seems that its chrome that fu**ing this up.. so nevermind it, i can live with that... for now :)
I'll let this post where i answer myself alot stay, maybe someone else can use my info..