MyBB Community Forums

Please help. showteam.php error after upgrade 6.1
following message appears when accessing showteam.php

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'm.id' in 'on clause'
Query:
    SELECT m.*, f.name FROM mybb_moderators m LEFT JOIN mybb_users u ON (u.uid=m.id) LEFT JOIN mybb_forums f ON (f.fid=m.fid) WHERE f.active = 1 AND m.isgroup = 0 ORDER BY u.username 

Please contact the MyBB Group for support.

That column doesn't exist in 1.6, try reuploading showteam.php.

(2010-08-25, 11:29 AM)AJS Wrote: [ -> ]That column doesn't exist in 1.6, try reuploading showteam.php.

problem solved. but not completed by way of re-uploading showteam.php.
it can only be solved by changing the column follows

// Fetch specific forum moderator details
if($usergroups[6]['gid'])
{
	$query = $db->query("
		SELECT m.*, f.name
		FROM ".TABLE_PREFIX."moderators m
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.id=m.uid)
		LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=m.fid)
		WHERE f.active = 1 AND m.isgroup = 0
		ORDER BY u.username
	");
	while($moderator = $db->fetch_array($query))
	{
		$moderators[$moderator['id']][] = $moderator;
	} 
}

replaced with the following code

// Fetch specific forum moderator details
if($usergroups[6]['gid'])
{
	$query = $db->query("
		SELECT m.*, f.name
		FROM ".TABLE_PREFIX."moderators m
		LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=m.uid)
		LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=m.fid)
		WHERE f.active = 1 AND m.isgroup = 0
		ORDER BY u.username
	");
	while($moderator = $db->fetch_array($query))
	{
		$moderators[$moderator['id']][] = $moderator;
	} 
}

See the difference :

Quote: LEFT JOIN ".TABLE_PREFIX."users u ON (u.id=m.uid)
with

LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=m.uid)

I do not know why just because of lack of 1-2 letters can be problematic. but, apparently with little problem I just finished editing