I'm getting an error migrating a v3.7.2 site to D6 using the rc1 code stemming from the following code:

  // Gender
  $sql = 'INSERT IGNORE INTO %s (fid, uid, value) ';
  $sql .= 'SELECT fid, userid+%d, field5 ';
  $sql .= 'FROM {userfield}, %s ';
  $sql .= 'WHERE name="user_gender" AND (field5="Male" OR field5="Female");';

If this is a customizable field it should only be executed if applicable.

Comments

damienmckenna’s picture

damienmckenna
Location TN, USA
commented

Oh, btw, besides this one error it seems to work just great! :-)

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Closed (duplicate)

This is a duplicate of: #337390: Unknown column 'fieldx'

I'd love to only execute it if applicable, but there's no standard SQL way of checking whether a column exists. That's because a database schema is not supposed to change dynamically, the database design of vBulletin is really messed up when it comes to these fields! :)

I will work out another way (check vBulletin's settings or something), but it's not a huge priority. The import works fine, even with this annoyance! Glad to hear your import went well. Oh, and feel free to comment out those lines, if the error irritates you.