Hi
After I installed vBExperience I tried to Update Experience points but I get this error
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
COUNT(p.postid) as mycount
FROM post as p
INNER JOIN thread AS t ON (p.threadid = t.threadid)
WHERE p.visible=1 AND p.dateline>1259943720 AND t.forumid NOT IN(13،16،20)
GROUP BY p.userid
ORDER BY mycount DESC
LIMIT 0,10;
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 '،16،20)
GROUP BY p.userid
ORDER BY mycount DESC
LIMIT 0,10' at line 5
Error Number : 1064
Request Date : Friday, December 25th 2009 @ 04:22:42 PM
Error Date : Friday, December 25th 2009 @ 04:22:42 PM
Script : http://ibrigate.com/vb/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer : http://ibrigate.com/vb/admincp/xperience_admin.php?do=recount
IP Address : **********
Username : ********
Classname : vB_Database
MySQL Version : 5.1.40-log
Any solution?