657707 - importxml.pl crashes when importing keywords

Status: RESOLVED FIXED

(Bugzilla :: Bug Import/Export & Moving, defect)

Description

[jwiseheart]

User-Agent:       Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
Build Identifier: 4.0

I am importing bugs from a legacy home-grown application we have using a VB6 front end and a MySQL back end. I am performing the migration using importxml.pl. My XML export from the legacy system conforms to the Bugzilla DTD, and (thanks to the ability to add AND IMPORT TO custom fields, which is nice) have successfully imported ALL data from the old system into the new, with the sole exception of the Keywords field.

The error I get is the following: cvs:/srv/www/htdocs # ./importxml.pl -v bugsfile.xml
DBD::mysql::db do failed: Unknown column 'keywords' in 'field list' [for Statement "UPDATE bugs SET keywords = ? WHERE bug_id = ?"] at ./importxml.pl line 1147

My theory is this: Upon looking at the Bugzilla back end in MySQL, I'm guessing at one point in time, there was a 'Keywords' field in the 'bugs' table. For relational database purposes, it was probably decided to break the keywords out into a separate table, but importxml.pl was never updated to reflect this.

I'd try to fix it myself, but unfortunately Perl is not in my quiver of programming language arrows...

Thanks!

Reproducible: Always

Steps to Reproduce:
1. Do an import using importxml.pl
2. Make sure something is populated in the <keywords> element


Actual Results:  
cvs:/srv/www/htdocs # ./importxml.pl -v bugsfile.xml
DBD::mysql::db do failed: Unknown column 'keywords' in 'field list' [for Statement "UPDATE bugs SET keywords = ? WHERE bug_id = ?"] at ./importxml.pl line 1147

Expected Results:  
Imported keywords into the keywords table, related to the associated Bug ID. 

This is the only "technology" issue holding up our migration. Luckily, there are also training and political issues being resolved, so I have a little time to try to get a resolution to this issue.

Comment 1

[Max Kanat-Alexander]

  You're right about the cause of the problem! :-) I'm not sure who's maintaining importxml.pl these days, though.

Comment 2

[Frédéric Buclin]

(In reply to comment #1)
> I'm not sure who's maintaining importxml.pl these days, though.

It's me, mostly.

Comment 3

[Frédéric Buclin]

Attachment: patch, v1

Comment 4

[:glob ✱]

Comment on attachment 534312 [details] [diff] [review]
patch, v1

r=glob

Comment 5

[Frédéric Buclin]

Committing to: bzr+ssh://[e-mail]/bugzilla/trunk/
modified importxml.pl
Committed revision 7821.

Committing to: bzr+ssh://[e-mail]/bugzilla/4.0/
modified importxml.pl
Committed revision 7597.

Comment 6

[jwiseheart]

Thank you for responding to this. I will test it in our application this week, and let you know the result.