UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports Fixed Bugs [FIXED for 7.1b5] Error when Changing Members to a different group!

select USER_ID,GROUP_ID from ubbt_USER_GROUPS where USER_ID IN ('17920') AND GROUP_ID in ('5','6','7') AND (GROUP_ID <> '3' )

it displayed this at the top of my page, it changed the group like I wanted.

but I am not sure why it told my this.

It's a select statement, so I think it's trying to re-display the group list.

I reported this bug on the beta forum - hopefully it will be fixed in the next beta

I find it kinda funny that some of the bugs where aforementioned :x

Quick fix on this one...the usual debug code left in.

Line 111 of admin/dochangeusergroups.php has this:

echo $query;

Just remove that line.

I am having a similar error. If I select all selected members on this page everything works great. But if I select All Members in search I get the following.

"Control panel message
SELECT t1.USER_ID,t4.GROUP_ID FROM ubbt_USERS as t1, ubbt_USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and t2.USER_TOTAL_POSTS > '100' GROUP BY USER_ID ORDER BY USER_ID ASC

Unknown table 't2' in where clause"

Hmm, will need to check on that one and see what I have wrong there.

Hmm, I can't duplicate this error on my test site. I'm assuming from the query you're search for any user with over 100 posts?

Correct. I am trying to create a new group so that I can more easily control who is able to able to use attachments. I was able to do it changing 25 members at a time, but it always returned that error when I tried to do the entire list.

That would actually be a good feature request: "Only allow attachments for: All, Registered, Full Members, Mods/Admins only."