edubuntu-bugs team mailing list archive

[Patrick Sabin <869422@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Whenever I try to download a shared deck I get an exception:

File is corrupt or not an Anki database. Click help for more info.

Debug info:
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 <= ?' (1317928713.984924,)

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: anki 1.0.1-1
ProcVersionSignature: Ubuntu 2.6.38-11.50-generic 2.6.38.8
Uname: Linux 2.6.38-11-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Thu Oct  6 21:05:45 2011
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=en
 LANG=de_AT.UTF-8
 LC_MESSAGES=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: anki
UpgradeStatus: Upgraded to natty on 2011-04-28 (161 days ago)

** Affects: anki (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug natty running-unity

-- 
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/869422

Title:
  Cannot download a shared deck. Get Exception.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/anki/+bug/869422/+subscriptions