Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
I have created a new default group to replace users group.(newuser)
Having a issue with changing member groups.
Using member search using users and a old date for last login if I select selected members it works fine.
But when I select all members in search I get a error.
At first I thought it was just to many users to migrate.
But it happens with just 2 pages left.
Here is the error
Code
Script:
Line:
SQL Error: Column 'USER_ID' in where clause is ambiguous
SQL Error: 1052

Query:SELECT t1.USER_ID,t4.GROUP_ID FROM ubbt_USERS as t1, ubbt_USER_GROUPS as t4, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID
AND t3.USER_LAST_VISIT_TIME < '1167609600'
AND t4.GROUP_ID IN (4)
AND USER_ID = t4.USER_ID
# extra
GROUP BY
USER_ID,
USER_LOGIN_NAME,
USER_MEMBERSHIP_LEVEL,
USER_DISPLAY_NAME,
t2.USER_REAL_EMAIL,
t2.USER_TOTAL_POSTS,
USER_REGISTRATION_IP,
USER_IS_BANNED,
USER_IS_UNDERAGE,
t2.USER_BIRTHDAY,
USER_REGISTERED_ON,
t3.USER_LAST_POST_TIME,
t3.USER_LAST_IP,
t3.USER_LAST_VISIT_TIME,
t3.USER_LAST_POST
ORDER BY
USER_ID ASC


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
This has been fixed for 7.7.5.

Caught it just after 7.7.4 release smile fixed and will be available in 7.7.5

thx


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Crap,
Why did I know you were going to say that.:)
40,000 members to go.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
There has been a lot of changes in the dochangeusergroups.php file from 7.7.4 to the currently unreleased 7.7.5

the following fix should get you back in business:

FIND around line 94
Code
$aquery = preg_replace("/t1\./", "", $aquery);

REPLACE WITH
Code
// $aquery = preg_replace("/t1\./", "", $aquery);

This line and the whole section has been unchanged in all prior versions for at least the past 10 years -- since at least 7.5.5 from 2010.

UBB.threads 7.7.5 will have useless code removed and known bugs fixed.


One of those a long time bugs which will be fixed with the release of 7.7.5 is:

[Linked Image]
member search with CHANGE GROUPS + ALL MEMBERS IN SEARCH

[Linked Image]
ADD TO: works as expected

[Linked Image]
REMOVE FROM: does not work

basically, ALL MEMBERS IN SEARCH + REMOVE FROM GROUP does not work for versions 7.7.4 and prior.

Last edited by isaac; 07/09/2020 1:19 PM.

Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
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
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (Geoff), 377 guests, and 191 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 20230217)