Missing dependencies, can't convert legacy dependencies

[Adam Dorsey - NOAA Affiliate]

I had the mastertickets compatibility mode option enabled, but dependencies were disappearing from tickets. Whenever I would re-add them, they continued to disappear.

I attempted to work around this issue by setting enable_mastertickets_compatibility_mode to "disabled". Dependencies re-appear, but have no mouseover text.

I then attempted to convert the old dependencies to the new mastertickets compatibility mode. However, whenever I attempt to use the enable_mastertickets_compatibility_mode "convert dependencies" option, I get the following error:

2013-05-28 16:06:02,751 Trac[ppenv] DEBUG: convertDependenciesToMastertickets: SELECT: SELECT ticket as oldsource,value as olddest FROM ticket_custom LEFT JOIN mastertickets ON ticket=source WHERE name = 'dependencies' AND source IS NULL
2013-05-28 16:06:02,796 Trac[ppenv] WARNING: convertDependenciesToMastertickets: try to convert 50 ticket dependencies from ticket_custom to mastertickets.
2013-05-28 16:06:02,797 Trac[ppenv] DEBUG: convertDependenciesToMastertickets: convert (256,56)
2013-05-28 16:06:02,797 Trac[chrome] DEBUG: Prepare chrome data for request
2013-05-28 16:06:02,800 Trac[svn_fs] DEBUG: Subversion bindings imported
2013-05-28 16:06:02,804 Trac[ppenv] DEBUG: PPConvertTicketDependenciesOption: disabled 
2013-05-28 16:06:02,804 Trac[ppticketdatetweak] DEBUG: add_date_field_definition_at_url_pattern: , path_info: /admin/ProjectPlanConfig/General
2013-05-28 16:06:02,819 Trac[main] ERROR: Internal Server Error: 
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py", line 497, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/admin/web_ui.py", line 125, in process_request
    path_info)
  File "build/bdist.linux-x86_64/egg/projectplan/projectplan.py", line 66, in render_admin_panel
    macroenv.convertDependenciesToMastertickets()
  File "build/bdist.linux-x86_64/egg/projectplan/ppenv.py", line 1174, in convertDependenciesToMastertickets
    cursor.execute("INSERT INTO mastertickets (source,dest) VALUES (%s,%s)" , (source,dest) )
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
IntegrityError: columns source, dest are not unique

I just need one mode that works for both adding/viewing dependencies and the dependency mouseover view. We don't use mastertickets, so compatibility there is not a major issue.

[Adam Dorsey - NOAA Affiliate]

Actually this was my own dumb fault; old versions of the plugins were preventing the newer versions from being loaded. Fixed, ticket is invalid.