[hrk]

clicking social group messages(moderated and deleted ) output this error :

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

			SELECT SQL_CALC_FOUND_ROWS
				groupmessage.*, user.*, groupmessage.ipaddress AS messageipaddress, socialgroup.name
				
				,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
				
			
			FROM moderation AS moderation
			INNER JOIN groupmessage AS groupmessage ON (moderation.primaryid = groupmessage.gmid AND type = 'groupmessage')
		
			LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
			LEFt JOIN socialgroup AS socialgroup ON (groupmessage.groupid = socialgroup.groupid)
			LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
			
			
			WHERE 1=1
				AND moderation.dateline >= 1204893707
				
			ORDER BY groupmessage.dateline DESC
			LIMIT 0, 10;

MySQL Error   : Column 'type' in on clause is ambiguous
Error Number  : 1052

Classname     : vb_database
MySQL Version : 4.1.22-standard

UNINstalled for now.