SQL syntax error when running archive filtering

[dlakatos847]

Describe Your Environment

• ZoneMinder v1.36.12
• Installed from rpm
• Debian GNU/Linux 11 (bullseye)

Describe the bug
I'd like to delete all unarchived events. The unarchived events are not deleted.

To Reproduce
Steps to reproduce the behavior:

1. Go to Filters
2. Select "Archive status" "equal to" "Unarchived only"
3. Tick Delete all matches
4. Click Execute

Expected behavior
All unarchived events deleted.

Debug Logs

Feb 05 22:02:20 zoneminder zmfilter_11[2587]: ERR [Can't execute filter 'SELECT E.*, unix_timestamp(E.StartDateTime) as Time
                                                       FROM Events as E WHERE (  E.Archived =
                                               ) ORDER BY E.StartDateTime ASC LIMIT 0,100', ignoring: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY E.StartDateTime ASC LIMIT 0,100' at line 3]

E.Archived value is not inserted properly.

[welcome]

Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!

[lthrhx]

Interesting.

Could you upload a screenshot of the filters page and its settings to get that error?