storageareas 1.31.9 - montage review group "all" executes an empty WHERE clause.

connortechnology / ZoneMinder

ZoneMinder is a free, open source Closed-circuit television software application developed for Linux which supports IP, USB and Analog cameras.

http://www.zoneminder.com/

GNU General Public License v2.0

9 stars 9 forks source link

Closed MalakymR closed 6 years ago

MalakymR commented 6 years ago

This page works fine when a group is selected, except "ALL" where the SQL statement is including WHERE when its not required.

web_php[3274]: FAT [SQL-ERR dbFetchAll no result, statement was 'SELECT * FROM Monitors WHERE ORDER BY Sequence ASC']

connortechnology commented 6 years ago

Can you please test latest code.

MalakymR commented 6 years ago

This is fixed - I had installed a fresh copy yesterday and there was no problem, so it was due to the day before that or an update quirk.