[ahobilam]

I am getting this database error message in VB 4.2 patch level 2 (latest)
What I have to do further to avoid this error?

Database error in vBulletin 4.2.0:

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 brahmins_xperience_stats AS s
		INNER JOIN brahmins_user AS u ON u.userid=s.userid
		WHERE 1=1 
		GROUP BY S.userid
		ORDER BY u.xperience desc
		LIMIT 0,30;

MySQL Error   : Unknown column 'S.userid' in 'group statement'
Error Number  : 1054
Request Date  : Sunday, August 19th 2012 @ 02:26:27 PM
Error Date    : Sunday, August 19th 2012 @ 02:26:27 PM
Script        : http://www.brahminsnet.com/forums/xperience.php?go=ranking
Referrer      : http://www.brahminsnet.com/forums/xperience.php?go=stats
IP Address    : 122.164.161.129
Username      : bmbcAdmin
Classname     : vB_Database
MySQL Version : 5.1.63-0ubuntu0.11.10.1