trac-upgrade showing error

[anonymous]

i have inserted a column in a table and since then its not able to upgrade the trac envoirnment. though i have deleted the column and after installing child ticket plugin it does not upgrade. pls look into this as it is very imp.

[anonymous]

i am putting the error.

Traceback (most recent call last):
  File "C:\Python26\lib\site-packages\trac\admin\console.py", line 107, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "C:\Python26\lib\cmd.py", line 218, in onecmd
    return self.default(line)
  File "C:\Python26\lib\site-packages\trac\admin\console.py", line 275, in default
    return cmd_mgr.execute_command(*args)
  File "C:\Python26\lib\site-packages\trac\admin\api.py", line 123, in execute_command
    return f(*fargs)
  File "C:\Python26\lib\site-packages\trac\env.py", line 786, in _do_upgrade
    self.env.upgrade(backup=no_backup is None)
  File "C:\Python26\lib\site-packages\trac\env.py", line 526, in upgrade
    with_transaction(self)(participant.upgrade_environment)
  File "C:\Python26\lib\site-packages\trac\db\api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "c:\projects\trac\informatics\plugins\tracsubticketsplugin-0.1.0-py2.6.egg\tracsubtickets\api.py", line 87, in upgrade_environment
    cursor.execute("SELECT * FROM %s", (table.name, ))
  File "C:\Python26\lib\site-packages\trac\db\util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "C:\Python26\lib\site-packages\trac\db\sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "C:\Python26\lib\site-packages\trac\db\sqlite_backend.py", line 56, in execute
    args or [])
  File "C:\Python26\lib\site-packages\trac\db\sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
'''''OperationalError: near "?": syntax error'''''''''

[Ryan J Ollos]

SubticketsPlugin is hosted on GitHub. Take a look at the project page for more details. You'll need to report this over there.

[Steffen Hoffmann]

In addition to Ryan's comment I'd rename the subtickets table and look, if this makes upgrade successful.

Of course you did a Trac db backup before messing around with the db, didn't you? So you can compare to a known good state at any time. Not such a big issue to me. If you find something, that SubticketsPlugin should really better cope with, a report to the author would still be appreciated for sure.