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
Error Number : 1146
Date : Saturday, June 24th 2006 @ 03:35:10 PM
Script :
http://www.mysite.com/forum/iptracker.php
Referrer :
IP Address : myIP
Username : Alfa1
Classname : vB_Database
I have replaced some data relating to my servername, sitename and IP.
Note that there is a space between 'AS entries FROM vb9_' and 'user_troll'