Modify

Opened 5 years ago

Closed 4 years ago

#11124 closed defect (invalid)

Missing dependencies, can't convert legacy dependencies

Reported by: Adam Dorsey - NOAA Affiliate Owned by: Andreas
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 4 years ago by Adam Dorsey - NOAA Affiliate

Resolution: invalid
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Andreas.
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.