Unknown column 'fieldx'
Liam McDermott - November 21, 2008 - 15:50
| Project: | vBulletin to Drupal |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | minor |
| Assigned: | Unassigned |
| Status: | active |
Description
On a vBulletin forum that had the 'gender' profile field disabled the following error message appeared after the import:
Unknown column 'field5' in 'field list' query: INSERT IGNORE INTO drupal.profile_values (fid, uid, value) SELECT fid, userid+1000000, field5 FROM userfield, drupal.profile_fields WHERE name="user_gender" AND (field5="Male" OR field5="Female");Reason for problem: vBulletin's database design is pants. All profile fields are stored in 'field1', 'field2', 'field3', etc. then when a profile field is disabled, the column is not created. This makes it difficult to check whether a profile field can be imported, or not.
Action to take when seeing this error: none. It can safely be ignored, there is no effect on the rest of the import process.
This is still a bug in vbtodrupal as the module should check whether it's possible to import the field before trying. The database design used makes this difficult, however.