Filter bug "Unarchive all matches"

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
dougmccrary
Posts: 1172
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Filter bug "Unarchive all matches"

Post by dougmccrary »

Once set, cannot be unset from GUI.
First noticed in 1.37x but true in 1.36 also.
timw
Posts: 3
Joined: Thu Oct 12, 2023 8:19 am

Re: Filter bug "Unarchive all matches"

Post by timw »

I get the same issue in 1.36.33 (Ubuntu).

I fixed it (hopefully permanently) with a mysql command: `UPDATE Filters SET AutoUnarchive=0 WHERE Id=1;` (replace `1` with your filter ID).

I think this was also screwing up the filter query, because I was seeing a query like this in my debug logs.. `WHERE( [...] AND E.Archived = 0 ) AND ( E.Archived = 1 )`.

The `[...]` is the rest of my filter query, followed by "Archived Status - equal to - Unarchived only. It seems that having AutoUnarchive ticked will append the Archived=1 clause (because you can't unarchive something that isn't archived), but of course this create a query that can never yield results.

My filter works now! I wonder how many other topics on here about failed purges etc.. are due to this checkbox. The "Debug" button doesn't catch the error, but debug logging does.
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Filter bug "Unarchive all matches"

Post by iconnor »

Fix is now in master as well as proposed ppa. Will be included in 1.36.34.
Post Reply