[savraot]

When I try to use "Ranking", I get the following MySQL Error.
vb 4.1.11 / vBExperience 4.1.1 Beta.

Datenbankfehler in vBulletin 4.1.11:

Invalid SQL:
SELECT 
		u.userid,
		u.usergroupid,
		u.membergroupids,
		u.username,
		u.xperience_level,
		u.xperience,
		u.xperience_ppd,
		u.xperience_awardt,
		u.reputation,
		SUM(s.points_user) AS points_user,
		SUM(s.points_thread) AS points_thread,
		SUM(s.points_post) AS points_post,
		SUM(s.points_misc) AS points_misc
		FROM vb4xperience_stats AS s
		INNER JOIN vb4user AS u ON u.userid=s.userid
		WHERE 1=1 
		GROUP BY S.userid
		ORDER BY u.xperience desc
		LIMIT 0,30;

MySQL-Fehler  : Unknown column 'S.userid' in 'group statement'
Fehler-Nr.    : 1054
Fehler-Zeit   : Monday, 19.03.2012 @ 09:05:56
Datum         : Monday, 19.03.2012 @ 09:05:57
Skript        : http://www.xxx/xperience.php?go=ranking
Referrer      : http://www.xxx/xperience.php?go=groups
IP-Adresse    : xxx
Benutzername  : xxx
Klassenname   : vB_Database
MySQL-Version : 5.1.43-nmm4-log