AnKing-VIP / advanced-browser

Anki add-on with card browser enhancements.
GNU General Public License v3.0
58 stars 13 forks source link

Error when opening browser #139

Closed Sol0din closed 2 years ago

Sol0din commented 2 years ago

Hello, Since I have updated to anki 2.1.49 (linux) this addon provokes the following error when I try to open the browser :

DbError { info: "SqliteFailure(Error { code: Unknown, extended_code: 1 }, Some(\"near \\"select\\": syntax error\"))", kind: Other }

I tried to reinstall the addon but it doesn't fix it, only disabling the addon fixes the problem Thank you for looking into this

ijgnd commented 2 years ago

Your problem seems to be similar to the following know bug, https://github.com/ankipalace/advanced-browser/issues/112#issuecomment-859633842:

In the browser clicking on the "Overdue Interval" tab will trigger the following pop up error and make the cards disappear in the browser.

DBError { info: "SqliteFailure(Error { code: Unknown, extended_code: 1 }, Some("near \"select\": syntax error"))", kind: Other }

Other subsequent browsing related action will then keep trigger the error and cards won't show up. However as soon as you click on another sorting option the cards appear again and the error stops popping up.

 

If your problem is not similar please let us know. When you test this make sure to disable all other add-ons and restart anki to rule out interferences from another add-on, see https://faqs.ankiweb.net/when-problems-occur.html

Sol0din commented 2 years ago

Yes it worked, thanks for the solution !