Public bug reported: Binary package hint: anki
each time i want to download a deck i can't because anki says that it is corrupted or invalid, but it says so even when i download decks that i downloaded correctly a few months ago. i use the latest ubuntu with everything up-to-date. Traceback (most recent call last): File "/usr/share/anki/ankiqt/ui/main.py", line 716, in loadDeck self.deck = DeckStorage.Deck(deckPath) File "/usr/share/anki/anki/deck.py", line 2814, in Deck deck.rebuildQueue() File "/usr/share/anki/anki/deck.py", line 685, in rebuildQueue self.checkDue() File "/usr/share/anki/anki/deck.py", line 665, in checkDue stmt % 0, now=time.time()+self.delay0).rowcount File "/usr/share/anki/anki/db.py", line 114, in statement return self.execute(text(sql), kwargs) File "/usr/share/anki/anki/db.py", line 90, in execute x = self._session.execute(*a, **ka) File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 701, in execute clause, params or {}) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1194, in execute params) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1274, in _execute_clauseelement return self.__execute_context(context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1305, in __execute_context context.parameters[0], context=context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1404, in _cursor_execute context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1397, in _cursor_execute context) File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute cursor.execute(statement, parameters) OperationalError: (OperationalError) no such index: ix_cards_priorityDue u'update cards indexed by ix_cards_priorityDue set isDue = 1 where type = 0 and isDue = 0 and priority in (1,2,3,4) and combinedDue <= ?' (1306988339.657242,) ** Affects: anki (Ubuntu) Importance: Undecided Status: New ** Description changed: Binary package hint: anki each time i want to download a deck i can't because anki says that it is corrupted or invalid, but it says so even when i download decks that i - downloaded correctly a few months ago + downloaded correctly a few months ago. i use the latest ubuntu with + everything up-to-date. Traceback (most recent call last): - File "/usr/share/anki/ankiqt/ui/main.py", line 716, in loadDeck - self.deck = DeckStorage.Deck(deckPath) - File "/usr/share/anki/anki/deck.py", line 2814, in Deck - deck.rebuildQueue() - File "/usr/share/anki/anki/deck.py", line 685, in rebuildQueue - self.checkDue() - File "/usr/share/anki/anki/deck.py", line 665, in checkDue - stmt % 0, now=time.time()+self.delay0).rowcount - File "/usr/share/anki/anki/db.py", line 114, in statement - return self.execute(text(sql), kwargs) - File "/usr/share/anki/anki/db.py", line 90, in execute - x = self._session.execute(*a, **ka) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 701, in execute - clause, params or {}) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1194, in execute - params) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1274, in _execute_clauseelement - return self.__execute_context(context) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1305, in __execute_context - context.parameters[0], context=context) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1404, in _cursor_execute - context) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1397, in _cursor_execute - context) - File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute - cursor.execute(statement, parameters) + File "/usr/share/anki/ankiqt/ui/main.py", line 716, in loadDeck + self.deck = DeckStorage.Deck(deckPath) + File "/usr/share/anki/anki/deck.py", line 2814, in Deck + deck.rebuildQueue() + File "/usr/share/anki/anki/deck.py", line 685, in rebuildQueue + self.checkDue() + File "/usr/share/anki/anki/deck.py", line 665, in checkDue + stmt % 0, now=time.time()+self.delay0).rowcount + File "/usr/share/anki/anki/db.py", line 114, in statement + return self.execute(text(sql), kwargs) + File "/usr/share/anki/anki/db.py", line 90, in execute + x = self._session.execute(*a, **ka) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 701, in execute + clause, params or {}) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1194, in execute + params) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1274, in _execute_clauseelement + return self.__execute_context(context) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1305, in __execute_context + context.parameters[0], context=context) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1404, in _cursor_execute + context) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1397, in _cursor_execute + context) + File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 299, in do_execute + cursor.execute(statement, parameters) OperationalError: (OperationalError) no such index: ix_cards_priorityDue u'update cards indexed by ix_cards_priorityDue set isDue = 1 where type = 0 and isDue = 0 and priority in (1,2,3,4) and combinedDue <= ?' (1306988339.657242,) -- You received this bug notification because you are a member of Edubuntu Bugsquad, which is subscribed to anki in Ubuntu. https://bugs.launchpad.net/bugs/800145 Title: anki can't download any deck To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/anki/+bug/800145/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~edubuntu-bugs Post to : edubuntu-bugs@lists.launchpad.net Unsubscribe : https://launchpad.net/~edubuntu-bugs More help : https://help.launchpad.net/ListHelp