Modify

Opened 8 years ago

Closed 5 years ago

#6513 closed defect (wontfix)

Error while deleting edited ticket comments

Reported by: Christian Boos Owned by: Noah Kantrowitz
Priority: normal Component: TicketDeletePlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

Doing Delete Change on a ticket change where the comment has been edited gives:

2010-01-31 09:58:17,845 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 495, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 227, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line 115, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/ticketdelete/web_ui.py", line 89, in render_admin_panel
    self._delete_change(t.id, ts, field)
  File "build/bdist.linux-x86_64/egg/ticketdelete/web_ui.py", line 206, in _delete_change
    self._delete_change(id, ts, field)
  File "build/bdist.linux-x86_64/egg/ticketdelete/web_ui.py", line 202, in _delete_change
    cursor.execute("UPDATE ticket SET %s=%%s WHERE id=%%s" % field, (oldval, id))
  File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: column "_comment0" of relation "ticket" does not exist
LINE 1: UPDATE ticket SET _comment0=E'Replying to [ticket:8902 anony...

I'll try to take care of the patch at some later point, for now creating the ticket to keep track of the backtrace.

Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by Christian Boos

Also, doing a Delete field on _comment0 (which was the only field left after the failed deletion above) gives a ValueError: too many values to unpack error, with the following backtrace:

Traceback (most recent call last):
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 495, in _dispatch_request
    dispatcher.dispatch(req)
  File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 227, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line 115, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/ticketdelete/web_ui.py", line 86, in render_admin_panel
    for field, ts in deletions:

comment:2 Changed 5 years ago by Ryan J Ollos

Summary: error while deleting edited ticket commentsError while deleting edited ticket comments

comment:3 Changed 5 years ago by Ryan J Ollos

Resolution: wontfix
Status: newclosed

Closing tickets for deprecated plugin.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Noah Kantrowitz.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.