Doesn't actually look like vbulletin issue, but this is a bit above my paygrade
If this isn't enough info for you to do initial troubleshooting let me know and I will provide more info
user warning: Unknown column 'field5' in 'field list' query: INSERT IGNORE INTO `relent_drupal`.profile_values (fid, uid, value) SELECT fid, userid+1000000, field5 FROM userfield, `relent_drupal`.profile_fields WHERE name="user_gender" AND (field5="Male" OR field5="Female"); in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 743.
user warning: Unknown column 'filesize' in 'field list' query: INSERT IGNORE INTO `relent_drupal`.files (fid, uid, filename, filepath, filemime, filesize, status, timestamp) SELECT attachmentid+1000000, a.userid+1000000, CONCAT((attachmentid+1000000), '_', filename), CONCAT('sites/default/files/', (attachmentid+1000000), '_', filename), TRIM(LEFT(MID(mimetype, LOCATE('Content-type:', mimetype)+LENGTH('Content-type:'), LENGTH(mimetype)), LOCATE('"',MID(mimetype, LOCATE('Content-type:', mimetype)+LENGTH('Content-type:'), LENGTH(mimetype)))-1)), filesize, 1, a.dateline FROM attachment a INNER JOIN attachmenttype ON a.extension=attachmenttype.extension; in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1145.
user warning: Unknown column 'a.visible' in 'field list' query: INSERT IGNORE INTO `relent_drupal`.upload (fid, vid, description, list, nid, weight) SELECT attachmentid+1000000, threadid+1000000, filename, a.visible, attachmentid+1000000, 0 FROM attachment a INNER JOIN thread ON a.postid=thread.firstpostid in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1156.
user warning: Unknown column 'attachment.visible' in 'field list' query: INSERT IGNORE INTO `relent_drupal`.comment_upload (fid, nid, cid, description, list) SELECT attachmentid+1000000, threadid+1000000, post.postid+1000000, filename, attachment.visible FROM attachment INNER JOIN post ON attachment.postid=post.postid in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1171.
user warning: Unknown column 'filedata' in 'field list' query: SELECT attachmentid+1000000 AS uniqueid, filename, filedata, 0 AS avatar FROM attachment UNION SELECT IF(userid=0,0,userid+1000000) AS uniqueid, filename, filedata, 1 AS avatar FROM customavatar; in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1180.
user warning: Duplicate entry '293-13' for key 1 query: UPDATE profile_values pv, uid_linker ul SET uid = drupal_uid WHERE pv.uid = ul.vb_uid in /home/relent/public_html/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1383.
Comments
Comment #1
Custos commentedI apologize for being such a nub, looks like most of the info moved fine, trying to look into the ways it handled user migration, especially given DrupalVB
Comment #2
Custos commentedOkay, it looks like info moved successfully. I think an option to not move any users not already in Drupal's DB would be really useful for those who have already integrated.
I did notice every user has what is almost a 'blank role' assigned to them, this could have been my fault I think vbulletin to drupal was run twice. I will research a SQL query to fix the issue
Comment #3
liam mcdermott commentedThanks for reporting this and sorry I never did reply, I did read it at the time though (I always read bugs, don't always get time to reply, however).
I've done a vBulletin 4 import or two since this time and have managed to iron out most of the bugs, so I'll call this one fixed for now. There have been quite a few fixes to the way it handles users already in Drupal, for example.
And if anyone else comes across this, experiencing this bug, or one like it, please create a new issue for it. Thanks.