Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#10013 closed defect (invalid)

trac-upgrade showing error

Reported by: anonymous Owned by: anonymous
Priority: highest Component: SELECT A HACK
Severity: blocker Keywords:
Cc: Takashi Ito, Steffen Hoffmann Trac Release: 0.12


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.

Attachments (0)

Change History (3)

comment:1 Changed 6 years ago by anonymous

i am putting the error.

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

comment:2 Changed 6 years ago by Ryan J Ollos

Cc: Takashi Ito Steffen Hoffmann added; anonymous removed
Resolution: invalid
Status: newclosed

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

comment:3 Changed 6 years ago by 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.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain anonymous.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.