Modify

Opened 4 years ago

Closed 2 years ago

#8349 closed defect (fixed)

dependencies break the import

Reported by: ashraga1@… Owned by: farialima
Priority: high Component: TicketImportPlugin
Severity: major Keywords:
Cc: Trac Release: 0.12

Description

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 4 years ago by farialima

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 4 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 3 years ago by snorre

  • Trac Release changed from 0.11 to 0.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/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!!!

comment:4 Changed 3 years ago by anonymous

+1 for that

comment:5 Changed 2 years ago by farialima

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

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

Add Comment

Modify Ticket

Action
as closed The owner will remain farialima.
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.