I just installed this modification. It all seemed to be working, but now I am getting tons of errors, all like this:
Quote:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(1, 5,);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6
Error Number : 1064
Request Date : Sunday, February 5th 2012 @ 02:55:33 PM
Error Date : Sunday, February 5th 2012 @ 02:55:33 PM
Script : ....../forums/xperience.php?go=ranking&page=200sortfield=xl&sort order=desc&ausername=
Referrer :
IP Address : 12.12.12.12
Username : username
Classname : vB_Database
MySQL Version : 5.1.56
|
Can anyone help?
Can I modify the xperience.php to stop this error? I'm not sure which is exactly line 6.