Page 1 of 1
zmfilter problem
Posted: Sun May 04, 2025 8:24 am
by funix
Hello,
I have this message for a filter that is not working.
Code: Select all
"04/05/2025 10:17:22 UTC+2",zmfilter_2,2367361,WAR,"No filter found for SELECT * FROM `Filters` WHERE `Id` = ? AND( `AutoArchive` = 1 or `AutoUnarchive` = 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(2)",zmfilter.pl,245
any idea ?
Re: zmfilter problem
Posted: Sun May 04, 2025 10:33 pm
by burger
I'm not familiar with this particular error. You could look at the database.
Refer to
https://wiki.zoneminder.com/Filters#Troubleshooting there are some things you can try there.
Maybe post a screenshot of the filter that you are having trouble with.
Re: zmfilter problem
Posted: Thu May 08, 2025 6:20 am
by funix
my filter
'list matches" works
Re: zmfilter problem
Posted: Thu May 08, 2025 8:15 pm
by burger
Contains is the proper syntax for the notes field for this SQL. Is that the french translation? Or do you have it set to equal? Equal may not work. I can't tell what the translation is without looking it up... Github is requiring me to sign in to search the code, so that's a fail.
EDIT: Ah I found it. I'm not sure this is the cause of the error but you are using 'ne correspond pas' which refers to the french translation
https://github.com/ZoneMinder/ZoneMinde ... /fr_fr.php of 'OpNotMatches' => 'ne correspond pas' In my notes field search filter I use something different. I use: 'OpLike' => 'contains',
https://github.com/ZoneMinder/zoneminde ... /en_gb.php which in french is... Well, that looks like an error. OpLike is not there in the french translation. Bug maybe? Yes, looking at this, it appears the french translation has an error.
There are at least three other things I can think of trying.
1) Click the option on the filters page for 'debug'. What does that output?
2) Check the database by logging into mysql and looking at the filters table. There are instructions here:
https://wiki.zoneminder.com/MySQL but I'll paraphrase here:
Code: Select all
sudo mysql -u root zm
select * from Filters\G
You may need to scroll to see the entry if you have many filters.
3) Enable debug logging on the filter as described in
https://wiki.zoneminder.com/Filters#Log ... r_in_Debug What does that output?
Re: zmfilter problem
Posted: Sun May 11, 2025 2:34 pm
by funix
Thank you for taking care of my case
I changed my interface to English, I actually have the choice between "does not contain" and "does not match", but for both "list matches" works very well and I still have the same error in the logs with no possibility to execute the filter
Code: Select all
No filter found for SELECT * FROM `Filters` WHERE `Id` = ? AND( `AutoArchive` = 1 or `AutoUnarchive` = 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(2)
and phpmyadmin gives me
with the command mariadb
Code: Select all
MariaDB [zm]> select * from Filters\G
*************************** 1. row ***************************
Id: 1
Name: PurgeWhenFull
UserId: 1
ExecuteInterval: 60
Query_json: {"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="},{"cnj":"and","obr":"0","attr":"EndDateTime","op":"IS NOT","val":"NULL","cbr":"0"}],"limit":100,"sort_asc":1}
AutoArchive: 0
AutoUnarchive: 0
AutoVideo: 0
AutoUpload: 0
AutoEmail: 0
EmailTo:
EmailSubject:
EmailBody:
EmailServer: NULL
EmailFormat: Individual
AutoMessage: 0
AutoExecute: 0
AutoExecuteCmd:
AutoDelete: 1
AutoMove: 0
AutoMoveTo: 0
AutoCopy: 0
AutoCopyTo: 0
UpdateDiskSpace: 0
Background: 1
Concurrent: 0
LockRows: 0
*************************** 2. row ***************************
Id: 2
Name: Suppresion-event-sans-detection
UserId: 1
ExecuteInterval: 60
Query_json: {"terms":[{"attr":"Notes","op":"NOT LIKE","val":"person"},{"cnj":"and","attr":"EndDateTime","op":"<=","val":"-30 minute"}],"sort_field":"Id","sort_asc":"1","skip_locked":"0","limit":"0"}
AutoArchive: 0
AutoUnarchive: 0
AutoVideo: 0
AutoUpload: 0
AutoEmail: 0
EmailTo:
EmailSubject:
EmailBody:
EmailServer: NULL
EmailFormat: Individual
AutoMessage: 0
AutoExecute: 0
AutoExecuteCmd:
AutoDelete: 0
AutoMove: 0
AutoMoveTo: 0
AutoCopy: 0
AutoCopyTo: 0
UpdateDiskSpace: 0
Background: 1
Concurrent: 0
LockRows: 0
*************************** 3. row ***************************
Id: 3
Name: Envoi-mail-detection
UserId: 1
ExecuteInterval: 60
Query_json: {"terms":[{"attr":"Notes","op":"=~","val":"person"},{"cnj":"and","attr":"EndDateTime","op":"<=","val":"-1 minute"}],"sort_field":"StartDateTime","sort_asc":"1","skip_locked":"0","limit":"0"}
AutoArchive: 0
AutoUnarchive: 0
AutoVideo: 0
AutoUpload: 0
AutoEmail: 0
EmailTo: monmail
EmailSubject: Détection
EmailBody: Détection
EmailServer: NULL
EmailFormat: Individual
AutoMessage: 1
AutoExecute: 0
AutoExecuteCmd: mail -s "Detection person" olivier
AutoDelete: 0
AutoMove: 0
AutoMoveTo: 0
AutoCopy: 0
AutoCopyTo: 0
UpdateDiskSpace: 0
Background: 0
Concurrent: 0
LockRows: 0
3 rows in set (0,001 sec)
Re: zmfilter problem
Posted: Sun May 11, 2025 7:13 pm
by burger
You didn't specify an action.
You might expect a warning/error in ZM that if no action is selected it doesn't allow the filter to be saved... But that is not there, unfortunately.
I have seen the filters page glitch where I had to save the filter a second time to get the action or option to be registered. Maybe that happened. Always double check your filters.
Re: zmfilter problem
Posted: Sun May 25, 2025 5:37 pm
by funix
I'm an idiot it was so obvious! thank you