Unknown column 'E.StartWeekday'

[mrvoiceua]

Hi.

I create new filter.
I run the test and get the error.

Unknown column 'E.StartWeekday' in 'where clause'

Вy eating it should have been
weekday( E.StartTime ) >= 0

zoneminder.x86_64 1.32.3-1.el7 @rpmfusion-free-updates



On timeline_functions.php at first glance all right.

Code: Select all

 case 'StartWeekday':
         $sqlValue = "weekday( E.StartTime )";
 break;

 case 'StartWeekday':
         $value = "weekday( '".strftime(STRF_FMT_DATETIME_DB, strtotime($value))."' )";
 break;

[iconnor]

The issue is on line 180 of Filter.pm (/usr/share/perl5/ZoneMinder/Filter.pm) It should be StartWeekDay instead of Weekday.

[MrFlopp]

Still a problem in current version for Ubuntu.

Had a quick look at the code, seems EndWeekday is correct in filters - you can use that until bug is fixed.