IntegrityError: column name is not unique

[maccari]

How to Reproduce

While doing a POST operation on /milestone, Trac issued an internal error.

System is debian stable, received the error while adding a milestone.

Request parameters:

{'__FORM_TOKEN': u'ceed87fc83b1a921cef9690d',
 'action': u'edit',
 'description': u'SES e SSD',
 'duedate': u'03/09/10',
 'id': u'',
 'name': u'Week 10 - Documenti finali'}

User Agent was: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.7) Gecko/20100106 Ubuntu/9.10 (karmic) Firefox/3.5.7

System Information

Trac	0.11.1
Python	2.5.2 (r252:60911, Jan 4 2009, 22:17:10) [GCC 4.3.2]
setuptools	0.6c8
SQLite	3.5.9
pysqlite	2.4.1
Genshi	0.5.1
mod_python	3.3.1
Pygments	0.10
Subversion	1.5.1 (r32289)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.5/site-packages/trac/ticket/roadmap.py", line 565, in process_request
    return self._do_save(req, db, milestone)
  File "/usr/lib/python2.5/site-packages/trac/ticket/roadmap.py", line 655, in _do_save
    milestone.insert()
  File "/usr/lib/python2.5/site-packages/trac/ticket/model.py", line 674, in insert
    self.description))
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.5/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
IntegrityError: column name is not unique

[anonymous]

I think it's just a bad error output when having two milestones with the same title.

[Christian Boos]

Right, it's very easy to trigger this error, and a such the problem has been reported numerous times. The fix needs #6348.