[Phalynx]

Originally Posted by sweetpotato

Bellow is the error:

Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
		COUNT(response) AS countevents
		FROM eventattendance
		INNER JOIN event ON event.eventid = eventattendance.eventid
		WHERE response='Yes' AND userid=1
		AND event.dateline > 315532800;

MySQL Error   : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Wednesday, March 14th 2012 @ 04:27:30 AM
Error Date    : Wednesday, March 14th 2012 @ 04:27:31 AM
Script        : /xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /xperience_admin.php?do=recount
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.92-log

Fixed in the final version.

Originally Posted by 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

This has been already addressed, please download the Beta again:
https://vborg.vbsupport.ru/attachmen...3&d=1331113788