Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Found a bug in the Change group function. If you go to member management in the advanced section, build your list of the users to change to a group. In the drop down at the bottom select change groups and select All Members in Search. Now hit submit and select the group you want to change them to. Hit submit and this is the error that come up
Quote
SELECT t1.USER_ID,t2.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 USER_IS_BANNED = '1' GROUP BY USER_ID ORDER BY USER_ID ASC

Unknown table 't2' in field list
If you select the Selected Members (on this page)
instead of the All Members in Selected members option it works fine. This was tested in IE6 & IE7 using 7.0.1

Last edited by Rick; 11/16/2006 11:37 AM.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
To fix this one. Edit line 126 of admin/dochangeusergroups.php. You'll see where it says

t2.GROUP_ID

Change that, to:

t4.GROUP_ID


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mirrored databases
by Baldeagle - 12/05/2025 3:27 PM
Cant get past check files during upgrade
by sniperbbb - 11/27/2025 1:55 AM
UBB.threads 8.0.1 Patch Released: Fixes
by isaac - 11/26/2025 1:39 PM
8.0.1 Patch Changelog Discussion
by isaac - 11/26/2025 12:34 PM
Who's Online Now
0 members (), 3,240 guests, and 216 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
test
test
by Gizmo, August 20
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20251126)