Fix for the DB error after email click for activation:
Find in the plugin "Welcome thread upon registration -> register_activate_start"
Code:
$useridnumber = $db->query_first("
SELECT userid
FROM useractivation
WHERE activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'
");
Replace with
Code:
$useridnumber = $db->query_first("
SELECT userid
FROM " . TABLE_PREFIX . "useractivation
WHERE activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'
");
No more database errors.