Multiple filters with same name.
Posted: Sat Feb 28, 2004 3:05 pm
Hi Philip,
I have to remember "TAB not ENTER after the subject line." :)
Using v1.18.1 I found what I think may be a bug in editing filters. After selecting a saved filter and making changes in some values, I click save. The next window where I may check auto-delete or email, etc. asks if I want to save as an existing saved filter or enter a new name. If I select an existing filter I seem to be getting multiple filters with the same name. I discovered this while trying to correct non-working values in the date/time field. Entering new values, I would then save and run zmfilter.pl. Instead of fixing the errors I kept getting more errors.
From zmfilter.log:
Scanning for events since id -1
Error, unable to parse date string '-2'Error parsing date/time '-2', skipping filter 'non'
Error, unable to parse date string ''Error parsing date/time '', skipping filter 'non'
Error, unable to parse date string '-2 'Error parsing date/time '-2 ', skipping filter 'non'
Error, unable to parse date string '-2'Error parsing date/time '-2', skipping filter 'non'
Error, unable to parse date string ''Error parsing date/time '', skipping filter 'non'
Error, unable to parse date string '-2 'Error parsing date/time '-2 ', skipping filter 'non'
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2004-02-25 21:41:00' )' ) order by E.Id' at line 1 at /usr/local/bin/zmfilter.pl line 407.
Can't execute: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2004-02-25 21:41:00' )' ) order by E.Id' at line 1 at /usr/local/bin/zmfilter.pl line 407
I checked the filters table in the database and found 6 entries all named 'non'. After removing them with mysql I was able to create another filter with correct values and get things working properly. For now if I need to change a filter I am deleting it and starting over. That seems to work as expected.
Any posts sharing example filters that work both when submitted through the web interface and when saved would be welcomed by me and perhaps some others.
Best regards,
Ross