Filter log

Forum for questions and support relating to the 1.27.x releases only.
Locked
chicoze
Posts: 5
Joined: Sat Sep 20, 2014 11:03 am

Filter log

Post by chicoze »

Running ZM on VirtualBox Ubuntu 14.04.1
In the log window, the filter log does not work (shows no result). Clicking on reset button shows the error:
SQL-ERR dbFetchAll no result, statement was 'select distinct Pid from Logs where not isnull(Pid) and Component = ? order by Pid asc'

Is there something i am missing?
chicoze
Posts: 5
Joined: Sat Sep 20, 2014 11:03 am

Re: Filter log

Post by chicoze »

Well, i think i found the solution.
on line 102 of file /usr/share/zoneminder/ajax/log.php
is missing $fieldValues
it is foreach( dbFetchAll( $sql, $field ) as $value )
should be foreach( dbFetchAll( $sql, $field, $fieldValues ) as $value )
Now it works!
Thanks.
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: Filter log

Post by knight-of-ni »

Exactly what version of zoneminder are you using?
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
chicoze
Posts: 5
Joined: Sat Sep 20, 2014 11:03 am

Re: Filter log

Post by chicoze »

Running ZM version v1.27.99.0 on Ubuntu Server 14.04.1 LTS 64-bit (VirtualBox)
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: Filter log

Post by knight-of-ni »

I believe this has been fixed:
https://github.com/ZoneMinder/ZoneMinder/issues/504

Once iconnor rolls out a new 1.27.99 deb you should be able to test.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
chicoze
Posts: 5
Joined: Sat Sep 20, 2014 11:03 am

Re: Filter log

Post by chicoze »

Thank you knnniggett. :D
Locked