Edgewall Software

Ticket #5445 (closed defect: duplicate)

Opened 16 months ago

Last modified 10 months ago

SQL logic error or missing database when adding milestone with existing name

Reported by: zregvart@… Owned by: jonas
Priority: low Milestone:
Component: general Version: 0.10.3
Severity: minor Keywords: SQL logic error milestone existing name
Cc:

Description

If you try to create a milestone that has the same name as an existing (in my case closed milestone), SQL logic error arises:

Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 359, in process_request
    self._do_save(req, db, milestone)
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/roadmap.py", line 430, in _do_save
    milestone.insert()
  File "/usr/local/lib/python2.4/site-packages/trac/ticket/model.py", line 616, in insert
    (self.name, self.due, self.completed, self.description))
  File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/local/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: SQL logic error or missing database

my trac is versioned 0.10.3, hosted on FreeBSD, Python 2.4.3

Attachments

Change History

Changed 16 months ago by anonymous

Duplicate of #3652?

Changed 10 months ago by cboos

  • milestone 0.10.5 deleted

Yes, a duplicate of #3652. Need also to consider that kind of exception for #6348.

Changed 10 months ago by cboos

  • status changed from new to closed
  • resolution set to duplicate

(forgot to close this one)

Add/Change #5445 (SQL logic error or missing database when adding milestone with existing name)

Author



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