Edgewall Software
Modify

Ticket #5445 (closed defect: duplicate)

Opened 5 years ago

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

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

comment:1 Changed 5 years ago by anonymous

Duplicate of #3652?

comment:2 Changed 4 years ago by cboos

  • Milestone 0.10.5 deleted

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

comment:3 Changed 4 years ago by cboos

  • Resolution set to duplicate
  • Status changed from new to closed

(forgot to close this one)

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.