Filter bug "Unarchive all matches"
Posted: Sat Apr 29, 2023 11:08 pm
Once set, cannot be unset from GUI.
First noticed in 1.37x but true in 1.36 also.
First noticed in 1.37x but true in 1.36 also.
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.