id summary reporter owner description type status priority component severity resolution keywords cc release 11124 Missing dependencies, can't convert legacy dependencies Adam Dorsey - NOAA Affiliate Andreas "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." defect closed normal ProjectPlanPlugin normal invalid