Hi
I have a user setup that use to test features regular users have. I went to the control panel and put in the user name and saved. When I tried to load the vBexperience page from the nav, I get a database error. I also get an error if I try to do a recount. I will show the following error message devoid of the domain name which is replaced with asterix***:
-----------------------
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
COUNT(p.postid) as count_posts
FROM post as p
INNER JOIN thread AS t ON (p.threadid = t.threadid)
WHERE p.visible=1 AND p.dateline>1221790500 AND p.userid NOT IN(testMonkey)
GROUP BY p.userid
ORDER BY count_posts DESC
LIMIT 0,10;
MySQL Error : Unknown column 'testMonkey' in 'where clause'
Error Number : 1054
Request Date : Thursday, October 9th 2008 @ 10:15:23 PM
Error Date : Thursday, October 9th 2008 @ 10:15:24 PM
Script :
http://www.********.com/forums/admin...nce_recount_xp
Referrer :
http://www.********.com/forums/admincp/index.php?do=nav
IP Address : **.***.**.**
Username : ****
Classname : vB_Database
MySQL Version : 5.0.51a-community