Modify

#11124 closed defect (invalid)

Missing dependencies, can't convert legacy dependencies

Reported by: asdorsey Owned by: anbo
Priority: normal Component: ProjectPlanPlugin
Severity: normal Keywords:
Cc: Trac Release:

Description

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.

Attachments (0)

Change History (1)

comment:1 Changed 20 months ago by asdorsey

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

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

Add Comment

Modify Ticket

Action
as closed The owner will remain anbo.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.