Opened 6 years ago

Closed 5 years ago

#8349 closed defect (fixed)

dependencies break the import

Reported by: ashraga1@… Owned by: François Granade
Priority: high Component: TicketImportPlugin
Severity: major Keywords:
Cc: Trac Release: 0.12


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?

Attachments (0)

Change History (5)

comment:1 Changed 6 years ago by 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 !

comment:2 Changed 6 years ago by 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?

comment:3 Changed 6 years ago by snorre

Trac Release: 0.110.12

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/", line 511, in _dispatch_request


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

resp = chosen_handler.process_request(req)

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


File "build/bdist.win32/egg/talm_importer/", 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/", line 364, in _process


File "build/bdist.win32/egg/talm_importer/", 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/", line 289, in save_changes


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


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

""", (, when_ts, author, comment_num, comment))

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

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

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

result = PyFormatCursor.execute(self, *args)

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

args or [])

File "build/bdist.win32/egg/trac/db/", 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!!!

comment:4 Changed 6 years ago by anonymous

+1 for that

comment:5 Changed 5 years ago by François Granade

Resolution: fixed
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain François Granade.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Note: See TracTickets for help on using tickets.