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 12:37 PM.
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
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
2 members (Gizmo, Stovebolt), 813 guests, and 157 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)