BugZilla 3.0 Ticket Import

2 views

Skip to first unread message

Andy Hunn

unread,

Oct 5, 2007, 4:50:07 PM10/5/07

to trac-...@googlegroups.com

I was wondering if anyone has stumbled across a method to successfully import trouble tickets from BugZilla 3.0 into Trac? Running the stock script 0.10.4 bugzilla2trac.py resulted in error messages of:

sudo ./bugzilla2trac.py --db bugzilla --tracenv /trac/import

Using Bugzilla v2180 schema.

Bugzilla MySQL('bugzilla':'':'':''): connecting...

Trac SQLite('/trac/import'): connecting...

Cleaning all tickets...

All tickets cleaned...

0. Filtering products...

Using products D&B Integrity Exploratory Warehouse Harvester Relationship Manager MIMB Adapter Unisys Integrity

1. Import severities...

inserting severity 'blocker' - '1'

inserting severity 'critical' - '2'

inserting severity 'major' - '3'

inserting severity 'normal' - '4'

inserting severity 'minor' - '5'

inserting severity 'trivial' - '6'

2. Import components...

inserting component 'INT', owner 'gsh...@sypherlink.com'

inserting component 'EW', owner 'gsh...@sypherlink.com'

inserting component 'MIMB Adapter', owner 'gsh...@sypherlink.com'

inserting component 'HRM', owner 'gsh...@sypherlink.com'

inserting component 'HRM-Analyzer', owner 'gsh...@sypherlink.com'

3. Import priorities...

inserting priority 'highest' - '1'

inserting priority 'high' - '2'

inserting priority 'normal' - '3'

inserting priority 'low' - '4'

inserting priority 'lowest' - '5'

4. Import versions...

inserting version '1.21.04'

inserting version 'HRM4.02d'

inserting version '1.09'

inserting version '2.0'

inserting version '1.02'

inserting version 'Development'

inserting version 'Beta'

5. Import milestones...

6. Retrieving bugs...

7. Import bugs and bug activity...

Traceback (most recent call last):

File "./bugzilla2trac.py", line 883, in <module>

main()

File "./bugzilla2trac.py", line 880, in main

convert(BZ_DB, BZ_HOST, BZ_USER, BZ_PASSWORD, TRAC_ENV, TRAC_CLEAN)

File "./bugzilla2trac.py", line 673, in convert

field_name = trac.getFieldName(mysql_cur, activity['fieldid']).lower()

File "./bugzilla2trac.py", line 431, in getFieldName

(fieldid))

File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 164, in execute

self.errorhandler(self, exc, value)

File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler

raise errorclass, errorvalue

_mysql_exceptions.OperationalError: (1054, "Unknown column 'fieldid' in 'where clause'")

And patching the script in 0.10.4 with the patch in ticket 5585 (http://trac.edgewall.org/ticket/5585) results in this error on patch:

sudo patch bugzilla2trac.py bugzilla_3.0_compatibility.patch

Password:

(Stripping trailing CRs from patch.)

patching file bugzilla2trac.py

Hunk #2 FAILED at 816.

1 out of 2 hunks FAILED -- saving rejects to file bugzilla2trac.py.rej

And this error upon another try converting after the failed patch: