Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#24472 - [anki] python2-sqlalchemy 0.7.0-1 update breaks anki 1.2.8-1

Attached to Project: Community Packages
Opened by Kevin Sopp (baraclese) - Friday, 27 May 2011, 19:14 GMT
Last edited by Jelle van der Waa (jelly) - Sunday, 29 May 2011, 10:04 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Jelle van der Waa (jelly)
Architecture All
Severity Medium
Priority High
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 5
Private No

Details

Description:
The update of python2-sqlalchemy breaks anki. I confirmed this by downgrading python2-sqlalchemy to 0.6.7-1.

Additional info:
* package versions
anki 1.2.8-1
python2-sqlalchemy 0.7.0-1

* cmdline Backtrace
[~]$ anki
Traceback (most recent call last):
File "/usr/bin/anki", line 27, in <module>
ankiqt.run()
File "/usr/lib/python2.7/site-packages/ankiqt/__init__.py", line 78, in run
import config
File "/usr/lib/python2.7/site-packages/ankiqt/config.py", line 10, in <module>
from anki.utils import genID
File "/usr/lib/python2.7/site-packages/anki/__init__.py", line 58, in <module>
from anki.deck import DeckStorage
File "/usr/lib/python2.7/site-packages/anki/deck.py", line 14, in <module>
from anki.db import *
File "/usr/lib/python2.7/site-packages/anki/db.py", line 33, in <module>
from sqlalchemy.exceptions import DBAPIError, OperationalError
ImportError: No module named exceptions
This task depends upon

Closed by  Jelle van der Waa (jelly)
Sunday, 29 May 2011, 10:04 GMT
Reason for closing:  Fixed
Additional comments about closing:  fixed in 1.2.8-2
Comment by Dominik (cpcgm) - Saturday, 28 May 2011, 10:03 GMT
Can someone change the priority to high? I have 250 cards coming up every day. If this bug isn't fixed for four days I have to study over 1 000 words...
Comment by Maximilian König (max.koe) - Saturday, 28 May 2011, 10:07 GMT
You can solve this issue (at least temporarily) by downgrading back to python2-sqlalchemy 0.6.7-1
Comment by Karol Błażewicz (karol) - Saturday, 28 May 2011, 10:11 GMT
Old packages, this way http://arm.konnichi.com/search/
Comment by Jelle van der Waa (jelly) - Saturday, 28 May 2011, 10:59 GMT
http://code.google.com/p/anki/issues/detail?id=2563&q=sqlalchemy&colspec=ID%20Status%20Priority%20Area%20Stars%20Summary upstream bug report


Could you try this package, it should fix the db issue
http://pkgbuild.com/~jelle/anki-1.2.8-2-any.pkg.tar.xz
Comment by Kevin Sopp (baraclese) - Saturday, 28 May 2011, 17:33 GMT
anki-1.2.8-2 allows anki to start up again. But I get an error when trying to add cards, so I downgraded again for now. I don't want to risk corrupting the db. I ran the database check after downgrading and it found no problems. The error message was:

An error occurred. It may have been caused by a harmless bug,
or your deck may have a problem.
To confirm it's not a problem with your deck, please restart
Anki and run Tools > Advanced > Check Database.
If that doesn't fix the problem, please copy the following
into a bug report:

Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 373, in
lambda w=w: self.onFocusLost(w))
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 485, in onFocusLost
modified = self.saveFields()
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 465, in saveFields
self.deck.setUndoStart(n, merge=True)
File "/usr/lib/python2.7/site-packages/anki/deck.py", line 3484, in setUndoStart
start = self._latestUndoRow()
File "/usr/lib/python2.7/site-packages/anki/deck.py", line 3503, in _latestUndoRow
return self.s.scalar("select max(rowid) from undoLog") or 0
File "/usr/lib/python2.7/site-packages/anki/db.py", line 98, in scalar
return self.execute(text(sql), args).scalar()
File "/usr/lib/python2.7/site-packages/anki/db.py", line 90, in execute
x = self._session.execute(*a, **ka)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 759, in execute
clause, params or {})
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1294, in execute
params)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1427, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1535, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1528, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 325, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) no such table: undoLog u'select max(rowid) from undoLog' ()
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 373, in
lambda w=w: self.onFocusLost(w))
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 485, in onFocusLost
modified = self.saveFields()
File "/usr/lib/python2.7/site-packages/ankiqt/ui/facteditor.py", line 465, in saveFields
self.deck.setUndoStart(n, merge=True)
File "/usr/lib/python2.7/site-packages/anki/deck.py", line 3484, in setUndoStart
start = self._latestUndoRow()
File "/usr/lib/python2.7/site-packages/anki/deck.py", line 3503, in _latestUndoRow
return self.s.scalar("select max(rowid) from undoLog") or 0
File "/usr/lib/python2.7/site-packages/anki/db.py", line 98, in scalar
return self.execute(text(sql), args).scalar()
File "/usr/lib/python2.7/site-packages/anki/db.py", line 90, in execute
x = self._session.execute(*a, **ka)
File "/usr/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 759, in execute
clause, params or {})
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1294, in execute
params)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1427, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1535, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1528, in _execute_context
context)
File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 325, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) no such table: undoLog u'select max(rowid) from undoLog' ()
Comment by Jelle van der Waa (jelly) - Saturday, 28 May 2011, 22:09 GMT
Same here, that's a seperate issue please report that upstream.

Loading...