
01-09-2009, 08:28 AM
|
|
|
Join Date: Mar 2008
Location: france
Posts: 516
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
tested on 3.8.0 gold:
hi, when I recount and what the last registered member appear i've got this text:
Quote:
Database error in vBulletin 3.8.0:
Invalid SQL:
SELECT
u.userid,
points_user_visitormessages+points_user_socialgrou p+points_user_friends+points_user_reputation
AS get_count
FROM xperience_stats as s
LEFT JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND u.userid NOT IN(294,1242) AND NOT (1=2 OR u.usergroupid = '' OR FIND_IN_SET(, u.membergroupids))
ORDER BY get_count DESC, points_xperience DESC
LIMIT 0,1;
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 ' u.membergroupids))
ORDER BY get_count DESC, points_xpe' at line 7
Error Number : 1064
Request Date : Friday, January 9th 2009 @ 11:20:29 AM
Error Date : Friday, January 9th 2009 @ 11:20:47 AM
Script : http://www.****/misc.php?do=xperienc...at=1757&pp=250
Referrer : http://www.****/misc.php?do=xperienc...at=1506&pp=250
IP Address : ****
Username : ****
Classname : vb_database
MySQL Version : 5.0.51a-log
|
sorry for my english
|