UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports Fixed Bugs [FIXED for 7.0.1] Mass Group Permission Change - Possible Bug

I am trying to remove a group of members from a permissions group, however, in the process of doing this I am receiving the folowing error message:

SELECT A_Searchterms,ADMIN_SEARCH_REMOVED_RESULTS FROM ubbt_ADMIN_SEARCHES WHERE USER_ID = 3 AND ADMIN_SEARCH_TYPE='member'

Unknown column 'A_Searchterms' in 'field list'

Should I drop this field or column?

I can change the group permission one member at a time, but not a group of members at a time.

Yep, definitely a bug. Line 115 of admin/dochangeusergroups.php has this:

SELECT A_Searchterms,ADMIN_SEARCH_REMOVED_RESULTS

That, needs to be:

SELECT ADMIN_SEARCH_TERMS,ADMIN_SEARCH_REMOVED_RESULTS

Thank you.

Now I am receiving this type of message:

SELECT t1.USER_ID,t2.GROUP_ID FROM ubbt_USERS, ubbt_USER_GROUPS as t2 WHERE t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t4.GROUP_ID IN (34)GROUP BY USER_ID ORDER BY USER_ID ASC

Unknown table 't1' in field list

Should I remove this unknown table? If so, can you give me the command to do so?

This is really when I am trying to do a mass member group permission change under Member Management regarding all of the above.

I may not have explained myself carefully enough.

I think you understood me though.

Hmm, as I look at this a little closer this whole section is a bit off. Some of the queries need to be changed around quite a bit. Not sure if I'll be able to post the entire fix here but I'll get it fixed for 7.0.1

This must have missed being tested in the beta and release candidate stages?

I could do it one member at a time, which will take time as there are almost 200 members involved.

I think I will create another one and leave that one showing "no access."