Current version( 2.3.2-1) is incompatible with newest sqlite3

Bug #54772 reported by lucasvo
6
Affects Status Importance Assigned to Milestone
python-pysqlite2 (Ubuntu)
Fix Released
Medium
Matthias Klose
Edgy
Won't Fix
Medium
Unassigned

Bug Description

I had problems running a script:
lucasvo@supernova:~/Desktop/vincisolutions/webmail/tags$ python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 11, in ?
    execute_manager(settings)
  File "/usr/lib/python2.4/site-packages/django/core/management.py", line 1319, in execute_manager
    execute_from_command_line(action_mapping, argv)
  File "/usr/lib/python2.4/site-packages/django/core/management.py", line 1243, in execute_from_command_line
    action_mapping[action]()
  File "/usr/lib/python2.4/site-packages/django/core/management.py", line 450, in syncdb
    table_list = _get_table_list()
  File "/usr/lib/python2.4/site-packages/django/core/management.py", line 68, in _get_table_list
    return get_introspection_module().get_table_list(cursor)
  File "/usr/lib/python2.4/site-packages/django/db/backends/sqlite3/introspection.py", line 7, in get_table_list
    cursor.execute("""
  File "/usr/lib/python2.4/site-packages/django/db/backends/util.py", line 12, in execute
    return self.cursor.execute(sql, params)
  File "/usr/lib/python2.4/site-packages/django/db/backends/sqlite3/base.py", line 77, in execute
    return Database.Cursor.execute(self, query, params)
pysqlite2.dbapi2.Warning: You can only execute one statement at a time.

Revision history for this message
Jan Alonzo (jmalonzo) wrote :

Hi! This also happens to me. This happens in the package distributed by ubuntu. I rebuilt the package and this problem went away.

cheers.

Revision history for this message
Chris Gebhardt (dev-openserve) wrote :

This is an API breakage bug in pysqlite2 previous to 2.0.7 and is well known.

See these posts:
http://initd.org/tracker/pysqlite/wiki/2.0.7_Changelog
http://lists.initd.org/pipermail/pysqlite/2006-May/000560.html

Suggested Fix:
Upgrade to 2.0.7 or backport the changes to the Ubuntu 2.0.5 version. I recommend simply upgrading to 2.0.7, as there are no changes from 2.0.5, only bugfixes. This should be safe for Edgy/updates (no API or functionality changes).

See also the 2.0.6 changelog for proof that nothing else has changed:
http://initd.org/tracker/pysqlite/wiki/2.0.6_Changelog

Revision history for this message
Matthias Klose (doko) wrote :

fixed in feisty, opened an edgy task. could you prepare a package for edgy-updates?

Changed in python-pysqlite2:
importance: Undecided → Medium
status: Unconfirmed → Confirmed
importance: Undecided → Medium
status: Unconfirmed → Confirmed
assignee: nobody → doko
status: Confirmed → Fix Released
Revision history for this message
Leann Ogasawara (leannogasawara) wrote :

The 18 month support period for Edgy Eft 6.10 has reached it's end of life. As a result, we are closing the Edgy nomination. Thanks.

Changed in python-pysqlite2:
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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