[metalguy639]

Originally Posted by Cloudrunner

Fix for the DB error after email click for activation:

Find in the plugin "Welcome thread upon registration -> register_activate_start"

$useridnumber = $db->query_first("
    SELECT userid
    FROM useractivation
    WHERE activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'
    
");

Replace with

$useridnumber = $db->query_first("
    SELECT userid
    FROM " . TABLE_PREFIX . "useractivation
    WHERE activationid = '" . $vbulletin->db->escape_string($vbulletin->GPC['i']) . "'
    
");

No more database errors.

Thanks