[TMM-TT]

Originally Posted by Alfa1

I am using 'vb9_ as table' prefix. Here is the error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS entries FROM vb9_ user_troll;

MySQL Error : Table 'servername.vb9_' doesn't exist

Ahh, a miss by me.

Look for this code

PHP Code:


if (file_exists("./global.php")) {
        $sql_count = "SELECT COUNT(*) AS entries FROM " . TABLE_PREFIX . " user_troll"; 


Replace with:

PHP Code:

if (file_exists("./global.php")) {
        $sql_count = "SELECT COUNT(*) AS entries FROM " . TABLE_PREFIX . "user_troll"; 


... then it should work.


Or get a modified sorce from here