Error on copy/move ticket

[anonymous]

Hi,

I have just installed this plugin and get the following errors:

Move ticket Error:

Traceback (most recent call last):
  File "/usr/local/python24/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/python24/lib/python2.4/site-packages/trac/web/main.py", line 238, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/python24/lib/python2.4/site-packages/TracWebAdmin-0.1.2dev_r4240-py2.4.egg/webadmin/web_ui.py", line 109, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/datamover/ticket.py", line 69, in process_admin_request
  File "build/bdist.linux-x86_64/egg/datamover/util.py", line 38, in copy_ticket
  File "/usr/local/python24/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/python24/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
OperationalError: database is locked

Copy Ticket Error:

Traceback (most recent call last):
  File "/usr/local/python24/lib/python2.4/site-packages/trac/web/main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/python24/lib/python2.4/site-packages/trac/web/main.py", line 238, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/local/python24/lib/python2.4/site-packages/TracWebAdmin-0.1.2dev_r4240-py2.4.egg/webadmin/web_ui.py", line 109, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/datamover/ticket.py", line 69, in process_admin_request
  File "build/bdist.linux-x86_64/egg/datamover/util.py", line 55, in copy_ticket
  File "/usr/local/python24/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/python24/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
    self.rs = self.con.db.execute(SQL % parms)
DatabaseError: table ticket_custom has no column named author

I would be grateful if you had any suggestions how to fix this issue.

Cheers

John

[anonymous]

I found the problem. In util.py the method copy_ticket is defined. First there is a loop that copies ticket_changes data. After that there is a loop copying ticket_custom data, but this loop reuses the variable name ticket_change_data part of the time, thus losing the actual data and thinking that there is an 'author' column in ticket_custom.

[anonymous]

see ticket #907

[Ryan J Ollos]

This plugin is deprecated. Please use the TracMigratePlugin.