[Digital Jedi]

Originally Posted by ozmazdaclub

getting a database error:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT userid
FROM useractivation
WHERE activationid = 'd62941f74c66347c70fd99dd255c4849000fe92d';

MySQL Error : Table 'ozmazdac_forum.useractivation' doesn't exist
Error Number : 1146
Request Date : Monday, February 1st 2010 @ 05:41:38 PM
Error Date : Monday, February 1st 2010 @ 05:41:38 PM
Script : http://www.ozmazdaclub.com/forums/re...hp?do=activate
Referrer : http://www.ozmazdaclub.com/forums/register.php?a=ver
IP Address : 58.165.1.223
Username : wildrose85
Classname : vB_Database
MySQL Version :

I got this same error today. I'm no expert at SQL, but I know enough to know that it appears one of the plugins is trying to SELECT the id from a table name, without accounting for your table's prefix first. I was able to fix it this way.

Like I said, I'm no expert, so use at your own risk. But it makes sense to me. Maybe someone more versed in MySQL can verify.

In Plugins & Products >> Plugin Manager >> Product : Welcome Thread, edit the plugin that uses the register_activate_start hook. Add the code in red:

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

Be careful with the syntax. The syntax is important. Don't just assume that quote mark or period or what have you is unimportant. It needs to be there.