edubuntu-bugs team mailing list archive

[Guybrush88 <800145@xxxxxxxxxxxxxxxxxx>]

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