Timeline SQL error using filters with Notes filters.
Posted: Sun Oct 27, 2013 12:35 am
I did not see this searching the forums. I have 12.04 Ubuntu with Zoneminder 1.25.0-1 installed from the Ubuntu software center. I have 5 zones in one camera I want to filter. To get around the error I modified timeline_functions.php as follows:
In the two switch statements (line 113) I added an entry for Notes.
case 'Notes':
$sqlValue = "E.Notes";
break;
(line 229)
case 'Notes':
$value = "'$value'";
break;
It works for me now. I retired in 1992 so I am not up to speed with modern coding. I need to check all the combinations of filter operators to be sure it works correctly.
The error follows:It was truncated in the log -- the unknown column was Notes.
SQL-ERR 'Unknown column 'Motion' in 'where clause'', statement was 'select min(E.StartTime) as MinTime, max(E.EndTime) as MaxTime from Events as E inner join Monitors as M on (E.MonitorId = M.Id) where not isnull(E.StartTime) and not isnull(E.EndTime)
In the two switch statements (line 113) I added an entry for Notes.
case 'Notes':
$sqlValue = "E.Notes";
break;
(line 229)
case 'Notes':
$value = "'$value'";
break;
It works for me now. I retired in 1992 so I am not up to speed with modern coding. I need to check all the combinations of filter operators to be sure it works correctly.
The error follows:It was truncated in the log -- the unknown column was Notes.
SQL-ERR 'Unknown column 'Motion' in 'where clause'', statement was 'select min(E.StartTime) as MinTime, max(E.EndTime) as MaxTime from Events as E inner join Monitors as M on (E.MonitorId = M.Id) where not isnull(E.StartTime) and not isnull(E.EndTime)