
02-27-2012, 07:56 PM
|
|
|
Join Date: Feb 2004
Location: Erlangen, Germany
Posts: 2,747
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by comunidadmh
Hello
Someone knows why I throw this error when I want to see the statistics?
Code:
Database error in vBulletin 4.1.10:
Invalid SQL:
SELECT
u.userid, u.username, s.points_user AS cnt_count
FROM xperience_stats AS s
INNER JOIN user AS u ON u.userid = s.userid
WHERE s.points_user <> 0
ORDER BY s.points_user DESC, s.points_xperience DESC
LIMIT;
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 7
Error Number : 1064
Request Date : Monday, February 27th 2012 @ 11:45:38 AM
Error Date : Monday, February 27th 2012 @ 11:45:38 AM
Script : http://www.comunidadmh.com/xperience.php?go=stats
Referrer : http://www.comunidadmh.com/xperience.php?go=awards
IP Address : 201.213.162.143
Username : Gaucha
Classname : vB_Database
MySQL Version : 5.1.52
|
It seems the setting for the Top x has been set to a null value. Please check this in Settings, Experience: Stats, Top x and set a value higher than 0.
Quote:
Originally Posted by owning_y0u
any solution for this?
|
Unfortunately not.
|