dependencies break the import

[ashraga1@…]

Hi, I manage a project on trac and using the import tool for creating all tasks, when I try to use the blockedby filed the import break, only after I import the project file with that filed empty the import is working but I can't import dependencies, when I try to export a ticket that has dependencies and to import the same way like it is in the file I exported it's still breaks the import, how can I fix this problem?

[François Granade]

It seems that you are using another plugin for ticket dependencies. It's very possible the the TicketImportPlugin doesn't work well with other plugins. Which plugin are you using ? MasterTicketsPlugin ? I can try to fix it but would need more info... Thanks !

[anonymous]

It's true- we are using MasterTicketsPlugin 3.0.1 with Trac 0.12. What should we do in order to fix this problem?

[snorre]

We have the same problem using Trac 0.12, MasterTicketsPlugin 3.0.1 and TicketImportPlugin 0.8.

For every import process only one dependency (blockedby, blocking) is added to a ticket and afterwards the import breaks with the message:

Trac detected an internal error:

IntegrityError: columns ticket, time, field are not unique

Python Traceback Most recent call last: File "build/bdist.win32/egg/trac/web/main.py", line 511, in _dispatch_request

dispatcher.dispatch(req)

File "build/bdist.win32/egg/trac/web/main.py", line 237, in dispatch

resp = chosen_handler.process_request(req)

File "build/bdist.win32/egg/talm_importer/importer.py", line 85, in process_request

encoding=req.sessionimporter.encoding?)

File "build/bdist.win32/egg/talm_importer/importer.py", line 129, in _do_import

return self._process(filereader, get_reporter_id(req), ImportProcessor(self.env, req, uploadedfilename, tickettime))

File "build/bdist.win32/egg/talm_importer/importer.py", line 364, in _process

processor.end_process_row()

File "build/bdist.win32/egg/talm_importer/processors.py", line 118, in end_process_row

self.ticket.save_changes(get_reporter_id(self.req), message, when=tickettime, db=self.db) # TODO handle cnum, cnum = ticket.valuescnum? + 1)

File "build/bdist.win32/egg/trac/ticket/model.py", line 289, in save_changes

@self.env.with_transaction(db)

File "build/bdist.win32/egg/trac/db/api.py", line 66, in transaction_wrapper

fn(db)

File "build/bdist.win32/egg/trac/ticket/model.py", line 350, in do_save

""", (self.id, when_ts, author, comment_num, comment))

File "build/bdist.win32/egg/trac/db/util.py", line 65, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "build/bdist.win32/egg/trac/db/sqlite_backend.py", line 78, in execute

result = PyFormatCursor.execute(self, *args)

File "build/bdist.win32/egg/trac/db/sqlite_backend.py", line 56, in execute

args or [])

File "build/bdist.win32/egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error

return function(self, *args, kwargs)

System Information: User Agent: Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1 Trac 0.12.2 Babel 0.9.5 Genshi 0.6 mod_python 3.3.1 pysqlite 2.5.5 Python 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)] RPC 1.1.2 setuptools 0.6c11 SQLite 3.6.11 Subversion 1.6.6 (r40053) jQuery 1.4.2

Enabled Plugins: estimationtools 0.4.5 c:\server\data\trac\sdp\sdp\plugins\estimationtools-0.4.5-py2.5.egg extendedversiontracplugin 0.0 c:\server\data\trac\sdp\sdp\plugins\extendedversiontracplugin-0.0-py2.5.egg ticketimport 0.8 c:\server\data\trac\sdp\sdp\plugins\ticketimport-0.8-py2.5.egg timingandestimationplugin 1.1.2 c:\server\data\trac\sdp\sdp\plugins\timingandestimationplugin-1.1.2-py2.5.egg trac-jsgantt 0.4 c:\server\data\trac\sdp\sdp\plugins\trac_jsgantt-0.4-py2.5.egg tracburndown 1.9.2 c:\server\data\trac\sdp\sdp\plugins\tracburndown-1.9.2-py2.5.egg tracmastertickets 3.0.2 c:\server\data\trac\sdp\sdp\plugins\tracmastertickets-3.0.2-py2.5.egg tracsubticketsplugin 0.1.0 c:\server\data\trac\sdp\sdp\plugins\tracsubticketsplugin-0.1.0-py2.5.egg tracxmlrpc 1.1.2 c:\server\data\trac\sdp\sdp\plugins\tracxmlrpc-1.1.2-py2.5.egg

It would be awfully nice to have a solution for that. Thanks a lot!!!

[anonymous]

+1 for that

[François Granade]

I believe that the fix for #7812 in [11745] is addressing this issue also. Please reopen if that's not the case.