trac-admin, Upgrade failed: You can only execute one statement at a time.

[bah@…]

I just installed trac devel revision 2013, and attempted to upgrade one of my projects created under trac 0.8.1. Got the Upgrade failed: message from trac-admin listed above.

This could be related to my install, in whose confidence I'm not 100%. My environment is:

• clearsilver 0.9.14
• Python 2.4.1
• swig 1.3.24
• Subversion 1.2.1
• Sqlite 3.2.1
• PySqlite 1.1.6

• Bill

[Christopher Lenz]

This is a problem with PySQLite 2, actually. The upgrade mechanism would need to be fixed to split up the SQL into multiple statements executed individually.

A workaround until we have a fix for this is to uninstall PySQLite 2.x (and make sure that PySQLite 1.1.6 is installed).

[bah@…]

I was able to get trac rev 2013 to upgrade my database thanks to the response by cmlenz. Short answer: I had both PySQLite 1.1.6 and 2 installed. Deleted PySQLite2, reinstalled trac rev 2013, and can now do the trac-admin upgrade.

On my first take, I had installed PySQLite2, followed by trac rev 2013. When that didn't work and I finally read the note that said not to use PySQLite2, I installed PySQLite 1.1.6 without uninstalling PySQLite2.

So both versions of PySQLite were installed when I reinstalled trac (using python setup.py clean, build, then install). I'm a Python noob, so I'm still finding my way around the whole Python module infrastructure thing.

Deleting the PySQLite2 module and reinstalling trac seems to have done the trick. Thanks very much for the helpful reply.

Bill

[Christopher Lenz]

Jonas fixed this in [2026].