ZoneMinder Forums

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?

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.

Exactly what version of zoneminder are you using?

Running ZM version v1.27.99.0 on Ubuntu Server 14.04.1 LTS 64-bit (VirtualBox)

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.

Thank you knnniggett.