Modify

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

Description

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\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'''''''''

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

Action
as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from (none). Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.