[Digma]

After having installed the mod yesterday following Miz' instruction, I was still having problems when trying to obtain information on the teams (showteams.php and userteam.php). Dunno if anyone else experienced the same with the latest version (2.0.2.)

I checked the MySQL code in these two files again after checking the error below:

For example:

Invalid SQL: 
	SELECT teams.*, teams.name AS username,
	 
	COUNT(user.userid) AS totalmembers,
	sum(user.posts) AS posts,
	sum(user.reputation) AS reputation 
		FROM td_teams AS teams
 	LEFT JOIN td_user  ON(teams.teamid = user.teamid)
	WHERE teams.teamid =2
	GROUP BY teams.teamid
		

mysql error: Unknown table 'user' in field list

And replaced:

 	LEFT JOIN td_user  ON(teams.teamid = user.teamid)

By:

 	LEFT JOIN td_user AS user ON(teams.teamid = user.teamid)

NOTE: Check for the TABLE_PREFIX instead of td_user of course as "td" is obviously my prefix. Sorry for not having the complete code, as I am at work and can't download zip files here.

And it seemed to work. But now I am still getting the same error when calling for the profile and the strange thing of this is that I can't seem to be able to find the code in the file (showteams.php) where "AS user" is missing or any of the other files for that matter.

Anyone know how to tackle this problem? (note: I have cleared my cache)