Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#10013 closed defect (invalid)

trac-upgrade showing error

Reported by: anonymous Owned by:
Priority: highest Component: SELECT A HACK
Severity: blocker Keywords:
Cc: itota, hasienda 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 2 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 2 years ago by rjollos

  • Cc itota hasienda added
  • Resolution set to invalid
  • Status changed from new to closed

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 2 years ago by hasienda

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.

Add Comment

Modify Ticket

as closed .
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.