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.

Last edited by Rick; 05/31/2007 12:38 PM.