Edgewall Software

Ticket #6983 (closed defect: duplicate)

Opened 9 months ago

Last modified 9 months ago

Missing unique constraint check in "add new milestone"

Reported by: larshelge@… Owned by: jonas
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords:
Cc:

Description (last modified by cboos) (diff)

"Add new milestone" in admin part lacks unique constraint checking and gives internal error when trying to add two milestones with the same name.

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/TracWebAdmin-0.1.2dev_r4240-py2.3.egg/webadmin/web_ui.py", line 109, in process_request
    path_info)
  File "/usr/lib/python2.3/site-packages/TracWebAdmin-0.1.2dev_r4240-py2.3.egg/webadmin/ticket.py", line 164, in process_admin_request
    mil.insert()
  File "/usr/lib/python2.3/site-packages/trac/ticket/model.py", line 616, in insert
    (self.name, self.due, self.completed, self.description))
  File "/usr/lib/python2.3/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
IntegrityError: column name is not unique

Attachments

Change History

Changed 9 months ago by cboos

  • status changed from new to closed
  • resolution set to duplicate
  • description modified (diff)

Right, but please next time check for duplicates before creating a new ticket.

See #6808.

Add/Change #6983 (Missing unique constraint check in "add new milestone")

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from jonas. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.