Edgewall Software
Modify

Ticket #6983 (closed defect: duplicate)

Opened 4 years ago

Last modified 4 years 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:
Release Notes:
API Changes:

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

comment:1 Changed 4 years ago by cboos

  • Description modified (diff)
  • Resolution set to duplicate
  • Status changed from new to closed

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

See #6808.

View

Add a comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
The resolution will be deleted. Next status will be 'reopened'
to The owner will be changed from jonas. Next status will be 'closed'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.