I haven't run this, but based on the error message, I would suggest that the problem is that Paul's vBulletin 4 importer is trying to join multiple tables with 'USING', which tends only to work in limited circumstances. Generally, when joining multiple tables, one should join those tables with 'ON'.
Try editing the vBulletin4.php script to replace this:
With this:
Shout back if this does not resolve the problem.
Try editing the vBulletin4.php script to replace this:
PHP:
protected function _getSelectUserSql($where)
{
return '
SELECT user.*, userfield.*, usertextfield.*,
IF(admin.userid IS NULL, 0, 1) AS is_admin,
admin.adminpermissions AS admin_permissions,
IF(userban.userid IS NULL, 0, 1) AS is_banned,
userban.bandate AS ban_date,
userban.liftdate AS ban_end_date,
userban.reason AS ban_reason,
userban.adminid AS ban_user_id,
IF(usergroup.adminpermissions & 1, 1, 0) AS is_super_moderator,
IF(customavatar.userid, 1, 0) AS has_custom_avatar
FROM ' . $this->_prefix . 'user AS user
LEFT JOIN ' . $this->_prefix . 'userfield AS userfield USING (userid)
LEFT JOIN ' . $this->_prefix . 'usertextfield AS usertextfield USING (userid)
LEFT JOIN ' . $this->_prefix . 'administrator AS admin USING (userid)
LEFT JOIN ' . $this->_prefix . 'userban AS userban USING (userid)
LEFT JOIN ' . $this->_prefix . 'usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
LEFT JOIN ' . $this->_prefix . 'customavatar AS customavatar USING (userid)
WHERE ' . $where . '
ORDER BY user.userid
';
}
PHP:
protected function _getSelectUserSql($where)
{
return '
SELECT user.*, userfield.*, usertextfield.*,
IF(admin.userid IS NULL, 0, 1) AS is_admin,
admin.adminpermissions AS admin_permissions,
IF(userban.userid IS NULL, 0, 1) AS is_banned,
userban.bandate AS ban_date,
userban.liftdate AS ban_end_date,
userban.reason AS ban_reason,
userban.adminid AS ban_user_id,
IF(usergroup.adminpermissions & 1, 1, 0) AS is_super_moderator,
IF(customavatar.userid, 1, 0) AS has_custom_avatar
FROM ' . $this->_prefix . 'user AS user
LEFT JOIN ' . $this->_prefix . 'userfield AS userfield ON (userfield.userid = user.userid)
LEFT JOIN ' . $this->_prefix . 'usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN ' . $this->_prefix . 'administrator AS admin ON (admin.userid = user.userid)
LEFT JOIN ' . $this->_prefix . 'userban AS userban ON (userban.userid = user.userid)
LEFT JOIN ' . $this->_prefix . 'usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
LEFT JOIN ' . $this->_prefix . 'customavatar AS customavatar ON (customavatar.userid = user.userid)
WHERE ' . $where . '
ORDER BY user.userid
';
}