Error when trying to delete ticket type

[mikelcu]

Running on debian, python version is 2.4.4. Database backend is Postgresql 8.2. Trac version is SVN r6317.

I get the following when trying to delete a ticket type through the web interface:

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/api.py", line 341, in send_error
    'text/html')
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/chrome.py", line 608, in render_template
    if not req.session or not int(req.session.get('accesskeys', 0)):
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/api.py", line 170, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/main.py", line 255, in _get_session
    return Session(self.env, req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/session.py", line 53, in __init__
    self.get_session(req.authname, authenticated=True)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/web/session.py", line 74, in get_session
    (sid, int(authenticated)))
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

And the following when trying the same thing with trac-admin:

Traceback (most recent call last):
  File "/usr/bin/trac-admin", line 7, in ?
    sys.exit(
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 1198, in run
    admin.run()
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 119, in run
    self.cmdloop()
  File "/usr/lib/python2.4/cmd.py", line 142, in cmdloop
    stop = self.onecmd(line)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 102, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.4/cmd.py", line 219, in onecmd
    return func(arg)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 828, in do_ticket_type
    self._do_enum('ticket_type', line)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 909, in _do_enum
    self._do_enum_remove(type, name)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/admin/console.py", line 944, in _do_enum_remove
    enum.delete()
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/ticket/model.py", line 375, in delete
    "type=%s and value>%s", (self.type, self._old_value))
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6317-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
psycopg2.ProgrammingError: operator does not exist: text - integer
HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.

[osimons]

Duplicate of #6490 - both concering common code for ticket enums.