Once set, cannot be unset from GUI.
First noticed in 1.37x but true in 1.36 also.
Filter bug "Unarchive all matches"
-
- Posts: 1210
- Joined: Sat Aug 31, 2019 7:35 am
- Location: San Diego
Re: Filter bug "Unarchive all matches"
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.
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.
Re: Filter bug "Unarchive all matches"
Fix is now in master as well as proposed ppa. Will be included in 1.36.34.