admin/dogroupmanage.php

find
PHP Code
	 // How many users are in this group and another group
		$query = "
			select USER_ID  as uid
			from {$config['TABLE_PREFIX']}USER_GROUPS
			where GROUP_ID = ? 
			and USER_ID = 
				(select distinct USER_ID 
				from {$config['TABLE_PREFIX']}USER_GROUPS
				where GROUP_ID <> ? 
				and USER_ID = uid)
		";
		$sth = $dbh->do_placeholder_query($query,array($k,$k),__LINE__,__FILE__);
		$in_other = $dbh->total_rows($sth);

replace with:

PHP Code
	 // SD:Mod fix the query to do what it is supposed to versus die ;)
		// How many users are in this group and another group
		$query = "
			select COUNT(USER_ID)
			from {$config['TABLE_PREFIX']}USER_GROUPS
			where GROUP_ID = ? 
			and USER_ID IN 
				(select distinct USER_ID 
				from {$config['TABLE_PREFIX']}USER_GROUPS
				where GROUP_ID <> ?)
		";
		$sth = $dbh->do_placeholder_query($query,array($k,$k),__LINE__,__FILE__);
		list($in_other) = $dbh->fetch_array($sth);

note: you can leave out "SD:Mod", but that is for my notes when i've changed stuff.. i've posted this fix elsewhere on this board, but it hasn't made it into 7.5.5 yet frown