Previous Thread
Next Thread
Print Thread
Hop To
7.7.4 move group all, fails with a error
#263879 05/24/2020 3:07 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,144
Likes: 21
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
Re: 7.7.4 move group all, fails with a error
Ruben #263880 05/24/2020 3:10 PM
Joined: Apr 2004
Posts: 1,697
Likes: 49
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,697
Likes: 49
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 // 7.7.4 released!
isaac @ id242.com // my forum @ CelicaHobby.com
Re: 7.7.4 move group all, fails with a error
Ruben #263881 05/24/2020 3:12 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Ruben Online Yawn OP
OP Online Yawn
Joined: Dec 2003
Posts: 6,144
Likes: 21
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

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
[NOTABUG] Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Error on Inert into POSTS
by jjjjj - 06/07/2020 8:09 PM
Who's Online Now
3 members (Ruben, Gizmo, 1 invisible), 84 guests, and 43 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4