I tried the fix too and got the DB error.
Code:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
FROM vb_user
LEFT JOIN vb_invitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = 'test@test.com'
OR invitation.email = 'test@test.com';
MySQL Error : Unknown column 'user.userid' in 'field list'
I think it is triggered by this code in the XML file:
Code:
$invitationcheck = $db->query_read("SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
FROM " . TABLE_PREFIX . "user
LEFT JOIN " . TABLE_PREFIX . "invitation
ON user.userid = invitation.acceptedby OR user.userid = invitation.email
WHERE user.email = '" . $db->escape_string($vbulletin->GPC['email']) . "'
OR invitation.email = '" . $db->escape_string($vbulletin->GPC['email']) . "'
");
The reason why the token fix may be working with some people and not others is that the plugin hits another bug in the code later on.
I suspect the new bug is related to installing vBulletin with a prefix on your DB tables (TABLE_PREFIX).
Any other ideas? I'm only a casual programmer.