OperationalError: columns type, name are not unique

[___]

How to Reproduce

While doing a POST operation on /admin/ticket/priority/blocker, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'5d0e4c7a44da2dbaa09299de',
 'cat_id': u'ticket',
 'name': u'critical',
 'panel_id': u'priority',
 'path_info': u'blocker',
 'save': u'Save'}

System Information

Trac	0.11b1
Python	2.4.3 (#1, Feb 27 2007, 13:49:20) [GCC 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8)]
setuptools	0.6c7
SQLite	3.2.1
pysqlite	2.0.5
Genshi	0.4.4
Subversion	1.3.0 (r17949)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/web/main.py", line 398, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/web/main.py", line 195, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/admin/web_ui.py", line 108, in process_request
    path_info)
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/ticket/admin.py", line 42, in render_admin_panel
    return self._render_admin_panel(req, cat, page, version)
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/ticket/admin.py", line 297, in _render_admin_panel
    enum.update()
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/ticket/model.py", line 430, in update
    (self.name, self.value, self.type, self._old_name))
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-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.11b1-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11b1-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: columns type, name are not unique

[Christian Boos]

See #6808.