anki can't download any deck

Bug #800145 reported by Guybrush88
28
This bug affects 5 people
Affects Status Importance Assigned to Milestone
anki (Ubuntu)
Fix Released
Undecided
Unassigned

Bug Description

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,)

Guybrush88 (guybrush)
description: updated
Revision history for this message
Guybrush88 (guybrush) wrote :

another user who uses anki got the same error

Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in anki (Ubuntu):
status: New → Confirmed
Revision history for this message
hackel (hackel) wrote :

Confirmed on Anki 1.0.1-1. Fixed by upgrading to latest version (1.2.8-1) from ankisrs.net. This version is included in Oneric, but have not upgraded yet, so I cannot test if the problem persists there.

Revision history for this message
François Marier (fmarier) wrote :

Fixed in Ubuntu 12.04.

Changed in anki (Ubuntu):
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.