Upgrading trac from 0.9 to 0.10 results in OperationalError

[Andrew Dolgov <cthulhoo@…>]

After running trac-admin upgrade I got this error when trying to create ticket:

Traceback (most recent call last):
  File "/var/lib/python-support/python2.3/trac/web/main.py", line 356, in dispatch_request
    dispatcher.dispatch(req)
  File "/var/lib/python-support/python2.3/trac/web/main.py", line 224, in dispatch
    resp = chosen_handler.process_request(req)
  File "/var/lib/python-support/python2.3/trac/ticket/web_ui.py", line 129, in process_request
    ticket = Ticket(self.env, db=db)
  File "/var/lib/python-support/python2.3/trac/ticket/model.py", line 37, in __init__
    self.fields = TicketSystem(self.env).get_ticket_fields()
  File "/var/lib/python-support/python2.3/trac/ticket/api.py", line 123, in get_ticket_fields
    options = [val.name for val in cls.select(self.env, db=db)]
  File "/var/lib/python-support/python2.3/trac/ticket/model.py", line 419, in select
    (cls.type,))
  File "/var/lib/python-support/python2.3/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/var/lib/python-support/python2.3/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/pyPgSQL/PgSQL.py", line 3091, in execute
    self.res = self.conn.conn.query('FETCH 1 FROM "%s"' % self.name)
OperationalError: ERROR:  invalid input syntax for integer: "6.0"

Trac 0.10 is from Debian unstable. My Trac database is stored in PostgreSQL, trying to browse roadmap produces similar error.

[Andrew Dolgov <cthulhoo@…>]

Solved using this query on Trac database:

ttrss_trac=> update enum set value = 6 where value = '6.0';
UPDATE 1

[anonymous]

(for changing resolution type)

[Christian Boos]

(we used fixed for something that requires a change to the code base)