rollback function not working with sqlite

[anonymous]

what I did:

root@mail:~# easy_install ​http://trac-hacks.org/svn/voteplugin/0.11

<added line "tracvote.* = enabled" to config

root@mail:~# trac-admin <DIR> upgrade Traceback (most recent call last):

File "/usr/bin/trac-admin", line 8, in <module>

load_entry_point('Trac==0.11.4', 'console_scripts', 'trac-admin')()

File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/console.py", line 1317, in run

return admin.onecmd(command)

File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/console.py", line 133, in onecmd

rv = cmd.Cmd.onecmd(self, line) or 0

File "/usr/lib/python2.5/cmd.py", line 219, in onecmd

return func(arg)

File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/admin/console.py", line 1149, in do_upgrade

if not self.env.needs_upgrade():

File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/env.py", line 430, in needs_upgrade

if participant.environment_needs_upgrade(db):

File "build/bdist.linux-i686/egg/tracvote/init.py", line 142, in environment_needs_upgrade File "/usr/lib/python2.5/site-packages/Trac-0.11.4-py2.5.egg/trac/db/util.py", line 36, in getattr

return getattr(self.cursor, name)

AttributeError: 'PyFormatCursor' object has no attribute 'rollback'

root@mail:~# sqlite3 -version 3.4.2

Trac 0.11.4

Python 2.5.2 (r252:60911, Jul 31 2008, 17:28:52) [GCC 4.2.3 (Ubuntu 4.2.3-2ubuntu7)] on linux2

[fabien]

Hello,

I get the same error...

[fabien]

Ok... I guess it should be db.rollback() and not cursor.rollback()

With that modification, it looks ok...

[Thijs Triemstra]

Yep, that fixes it:

tracvote/__init__.py

@@ -139 +139 @@
             cursor.fetchone()
             return False
         except:
-            cursor.rollback()
+            db.rollback()
             return True
 
     def upgrade_environment(self, db):

[anonymous]

This change seems to be missing form the latest commit (6352). This was needed to install with the latest 0.11 release of Trac.

Axton

[Ryan J Ollos]

Reassigning ticket to new maintainer.

[Ryan J Ollos]

Latest 0.11 version has cursor.connection.rollback(). Looks like this issue has been resolved. If you encounter the issue again, please reopen.