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.
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.
I am getting a similar error. I have FSRS enabled.
DbError { info: “SqlInputError { error: Error { code: Unknown, extended_code: 1 }, msg: \“ambiguous column name: data\”, sql: \“insert into search_cids select c.id from cards c, notes n where c.nid=n.id and ((((c.queue in (2,3) and c.due <= 2153) or (c.queue in (1,4) and c.due <= 1787808072)) and (c.did in (select id from decks where name regexp ?1) or (c.odid != 0 and c.odid in (select id from decks where name regexp ?1))) and (n.mid,c.ord) in (select ntid,ord from templates where name = ?)) and not c.queue = -1 and not c.queue in (-2,-3) and not c.odid != 0) order by extract_fsrs_relative_retrievability(data, case when odue !=0 then odue else due end, ivl, 2153, 1787893200, 1787808072) asc, fnvhash(c.id, c.mod) limit 999\”, offset: 485 }”, kind: Other }
Reproducible only when I include a card type in my filtered deck search and select by “Relative overdueness”.
i.e. is:due deck:deckname card:read triggers the error. is:due deck:deckname does not. Omitting the card:read search term allows me to use any “select by” method without error.
Linux Mint 22.3, kernel 6.8.0-55-generic
Anki Version 26.08.1 (39e4b0b4)
Python 3.13.13 Qt 6.11.1 Chromium 140