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?
Filter log
Re: Filter log
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.
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.
- knight-of-ni
- Posts: 2404
- Joined: Thu Oct 18, 2007 1:55 pm
- Location: Shiloh, IL
Re: Filter log
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/
All of these can be found at https://zoneminder.blogspot.com/
Re: Filter log
Running ZM version v1.27.99.0 on Ubuntu Server 14.04.1 LTS 64-bit (VirtualBox)
- knight-of-ni
- Posts: 2404
- Joined: Thu Oct 18, 2007 1:55 pm
- Location: Shiloh, IL
Re: Filter log
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.
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/
All of these can be found at https://zoneminder.blogspot.com/