Error while deleting edited ticket comments

[Christian Boos]

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.

[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:

[Ryan J Ollos]

Closing tickets for deprecated plugin.