Edgewall Software

Opened 16 years ago

Closed 16 years ago

#6983 closed defect (duplicate)

Missing unique constraint check in "add new milestone"

Reported by: larshelge@… Owned by: Jonas Borgström
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Christian Boos)

"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
  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
  File "/usr/lib/python2.3/site-packages/TracWebAdmin-0.1.2dev_r4240-py2.3.egg/webadmin/ticket.py", line 164, in process_admin_request
  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 (0)

Change History (1)

comment:1 by Christian Boos, 16 years ago

Description: modified (diff)
Resolution: duplicate
Status: newclosed

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

See #6808.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.