SqlInputError with filtered deck when sorting by ascending/descending retrievability and relative overdueness

For any filtered deck (whether upon creation of a new one or when modifying an existing one), it is impossible to select the three options “Ascending retrievability,” “Descending retrievability,” and “Relative overdueness” for “Limit to x cards selected by …”

(All other options work without any problem.)

Whenever I try it, in the example with x = 30, I receive the following error upon clicking “Rebuild”:

DbError { info: “SqlInputError { error: Error { code: Unknown, extended_code: 1
}, msg: “near “,\”: syntax error”, sql: “insert into search_cids select c.id
from cards c, notes n where c.nid=n.id and ((n.tags regexp ?) and not c.queue
= -1 and not c.queue in (-2,-3) and not c.odid != 0) order by , fnvhash(c.id,
c.mod) limit 30”, offset: 176 }”, kind: Other }

After dismissing the error, the setting window is still open. The only way to continue is to choose an option other than the three affected ones.

Even after following all advice from the FAQ, the problem persists.

Anki 26.08.1 (39e4b0b4)
Python 3.13.13 Qt 6.11.0 PyQt 6.11.0
Platform: Windows-11-10.0.26100-SP0

Thank you very much for any help!

I cannot reproduce on linux.

Does this include you running “Check Database”?

Yes, it includes a run of “Check Database”.

I am running Anki on a Surface Pro 11 with an ARM processor, which sometimes does not seem to be as stable as the Intel version. I have installed the newest ARM version of Anki. I have not used Anki in a long time, and I have never used filtered decks before. Also, I did not try to downgrade, so I cannot report so far whether it works in previous versions or not.

Thank you. Logged here:

@Anon_0000 it’s only reproducible with FSRS disabled.

I see. With SM-2 I can reproduce this, too. Thank you for telling me!