Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
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,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
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: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Dec 2003
Posts: 6,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
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,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
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 12:19 PM.

current developer of UBB.threads php forum software
current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
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
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 7:50 AM
Very weird error this morning.
by Baldeagle - 10/23/2024 4:35 PM
Help error and stop forum spam
by ehill - 10/23/2024 11:13 AM
Very slow web server response times
by Baldeagle - 10/18/2024 3:22 PM
Who's Online Now
1 members (Ruben), 185 guests, and 42 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.1
(Snapshot build 20240918)