Filters

[gsaindon]

Hi,
Here is the output when running the filters from the command line

root@zmtest1:/home/gsaindon# zmfilter.pl --filter=5
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_PAPER = "fr_CA.UTF-8",
LC_ADDRESS = "fr_CA.UTF-8",
LC_MONETARY = "fr_CA.UTF-8",
LC_NUMERIC = "fr_CA.UTF-8",
LC_TELEPHONE = "fr_CA.UTF-8",
LC_IDENTIFICATION = "fr_CA.UTF-8",
LC_MEASUREMENT = "fr_CA.UTF-8",
LC_TIME = "fr_CA.UTF-8",
LC_NAME = "fr_CA.UTF-8",
LANG = "en_US.UTF-8"
are supported and installed on your system.

01/11/2020 10:29:47.857346 zmfilter[9818].WAR [main:267] [No filter found for SELECT * FROM `Filters` WHERE `Name` = ? AND( `AutoArchive` = 1
or `AutoVideo` = 1
or `AutoUpload` = 1
or `AutoEmail` = 1
or `AutoMessage` = 1
or `AutoExecute` = 1
or `AutoDelete` = 1
or `UpdateDiskSpace` = 1
or `AutoMove` = 1
or `AutoCopy` = 1
) ORDER BY `Name` with values(5)]

This problem seems to have started with 1.33.16, 1.33.14 was running fine.

Any idea?

[iconnor]

There wasn't really anything done to filters between 1.33.14 and 1.33.16.

The error is similar to one that we had going from 1.33.13 to 1.33.14. Maybe try re-running the 1.33.14 update script as follows:
mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.33.14.sql

[gsaindon]

I ran it, here is the output:

Column AutoCopy already exists in Filters
Column AutoCopy already exists in Filters
Column AutoCopyTo already exists in Filters
Column AutoCopyTo already exists in Filters
Column Query_json already exists in Filters
Column Query_json already exists in Filters
Column SecondaryStorageId already exists in Events
Column SecondaryStorageId already exists in Events


Is there something else I can try?

Thanks,

[iconnor]

Wait a minute... it is loading the filter by Name, but using a value of 5 which is likely the Id.

Yeah, when loading filter by Id, use --filter_id=5

[gsaindon]

You are right! It works,

Thanks,