UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Fixed Bugs [FIXED for 7.2] Can't change the groups after member selection

I'm running the new 7.1.1 version and once a month I 'upgrade' members that have more then 4 posts. I just did a migration and today I try to do it.

I selected all members who had posts (>4) and were registered before May 01.
It brought about 22 members.
Then I select the 'Change Groups' options and removed from one group and add to another group.
Got this SQL error:

"SELECT t1.USER_ID,t4.GROUP_ID FROM ub_USERS as t1, ub_USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and USER_REGISTERED_ON < '1177992000' and USER_IS_BANNED = '0' and t2.USER_TOTAL_POSTS > '0' and t2.USER_TOTAL_POSTS > '4' and t4.GROUP_ID IN (5) GROUP BY USER_ID ORDER BY USER_ID ASC

Unknown table 't2' in where clause"

Any idea how to fix it?
Thank you

It happens if I choose to do the change with 'All Members in Search '.
If I choose Selected Members (on this page) and select the members there is no error.

You can fix this by editing the dochangeusergroups.php script. Line 126 currently has this:

$aquery = "SELECT t1.USER_ID,t4.GROUP_ID FROM {$config['TABLE_PREFIX']}USERS as t1, {$config['TABLE_PREFIX']}USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID $removed $aquery";

Change that, to this:

$aquery = "SELECT t1.USER_ID,t4.GROUP_ID FROM {$config['TABLE_PREFIX']}USERS as t1, {$config['TABLE_PREFIX']}USER_GROUPS as t4, {$config['TABLE_PREFIX']}USER_PROFILE as t2 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and t1.USER_ID = t2.USER_ID $removed $aquery";

Hi Rick,
Should I assume that on the next release it will be fix?
Or do I have to keep it to do again after future updates?
Thank you for the correction. It's applied and worked.

Yep, this will be fixed for the next release