186218 - importxml.pl does a query against products using old schema

Status: RESOLVED FIXED

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

Description

[Jonathan Schatz]

User-Agent:       Mozilla/5.0 Galeon/1.2.7 (X11; Linux i686; U;) Gecko/20021203
Build Identifier: Mozilla/5.0 Galeon/1.2.7 (X11; Linux i686; U;) Gecko/20021203

line 469 of importxml.pl reads:

      SendSQL("SELECT defaultmilestone FROM products " .
              "WHERE product = " . SqlQuote($product[0]));

except the products table has changed, and there's no longer a product column.
this should be:

      SendSQL("SELECT defaultmilestone FROM products " .
              "WHERE name = " . SqlQuote($product[0]));



Reproducible: Always

Steps to Reproduce:

Comment 1

[Jonathan Schatz]

Attachment: patch

Comment 2

[Dave Miller [:justdave]]

confirming... reassigning to patch author

Comment 3

[Dave Miller [:justdave]]

Comment on attachment 109800 [details] [diff] [review]
patch

if you could...  next time use diff -u so we get some context.	This looks good
though.

Comment 4

[Dave Miller [:justdave]]

Checking in importxml.pl;
/cvsroot/mozilla/webtools/bugzilla/importxml.pl,v  <--  importxml.pl
new revision: 1.29; previous revision: 1.28
done