Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (mmkk), 64 guests, and 247 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
TGCsanderson
TGCsanderson
Hackelton U.K.
Posts: 67
Joined: September 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
FREAK 11
M4TT 9
mmkk 5
Ruben 4
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5.1] 7.5 Change Groups Problems #224068
03/13/09 02:05 PM
03/13/09 02:05 PM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
Script:
Line#:
SQL Error: Unknown table 't3' in where clause
SQL Error #: 1109
Query: SELECT t1.USER_ID,t4.GROUP_ID FROM ubbt_USERS as t1, ubbt_USER_GROUPS as t4, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and t1.USER_ID = t2.USER_ID and t3.USER_LAST_VISIT_TIME < '1230786000' ORDER BY USER_ID ASC

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: 7.5 Change Groups Problems [Re: janitor] #224069
03/13/09 02:10 PM
03/13/09 02:10 PM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
Script:
Line#:
SQL Error: Unknown table 't3' in where clause
SQL Error #: 1109
Query: SELECT t1.USER_ID,t4.GROUP_ID FROM ubbt_USERS as t1, ubbt_USER_GROUPS as t4, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID <> '1' and t1.USER_ID = t4.USER_ID and t1.USER_ID = t2.USER_ID and t3.USER_LAST_VISIT_TIME < '1230786000' ORDER BY USER_ID ASC

Re: 7.5 Change Groups Problems [Re: janitor] #224080
03/13/09 04:20 PM
03/13/09 04:20 PM
Joined: Dec 2003
Posts: 5,823
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,823
Lutz,FL
I don't have a answer but I do have a question.
What process were you performing to get this error.
And what version are you on.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 Change Groups Problems [Re: Ruben] #224087
03/13/09 05:15 PM
03/13/09 05:15 PM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
I am using 7.5

I used member managment to find a group of users by last on date,
I selected all members in search,
I selected Change Groups,
I selected which group to remove and which to add,

then I recieved the error.

Re: 7.5 Change Groups Problems [Re: janitor] #224088
03/13/09 05:23 PM
03/13/09 05:23 PM
Joined: Dec 2003
Posts: 5,823
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,823
Lutz,FL
Okay, I am on the same version. But I tried this on a test board with only two members. It worked successfully with out errors.
How many members would you estimate you were moving?


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 Change Groups Problems [Re: Ruben] #224089
03/13/09 05:26 PM
03/13/09 05:26 PM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
I had 1 successful move, with 27,000 members

but now it continually displays the error,

I need to move 2,000 to 27,000 within 8 groups smile


Re: 7.5 Change Groups Problems [Re: janitor] #224090
03/13/09 05:52 PM
03/13/09 05:52 PM
Joined: Dec 2003
Posts: 5,823
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,823
Lutz,FL
Near as I can tell the script is dochangeusergroups.php.
Did you modify that with some Mod/Hack?
Other than that time to open a support ticket.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 Change Groups Problems [Re: Ruben] #224091
03/13/09 06:12 PM
03/13/09 06:12 PM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
no mods/hacks..

sorry to ask, but I might as well smile

how does the support ticket work?

Re: 7.5 Change Groups Problems [Re: janitor] #224092
03/13/09 06:18 PM
03/13/09 06:18 PM
Joined: Dec 2003
Posts: 5,823
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,823
Lutz,FL
Well just goto the support area. It is in the top left menu here.(support options)
Enter in your license stuff.
Rick will need at the very least login info to the site as admin.
If there is a real issue to deal with he may need ftp access.

Oh just select basic support for now Rick will let you know if it need to be bumped up.

Last edited by Ruben; 03/13/09 06:21 PM.

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 Change Groups Problems [Re: Ruben] #224189
03/16/09 09:32 AM
03/16/09 09:32 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Definitely a bug when Last Online is selected as one of the clauses. Will work on getting this fixed for 7.5.1.

Re: 7.5 Change Groups Problems [Re: Rick] #224252
03/17/09 11:29 AM
03/17/09 11:29 AM
Joined: Aug 2006
Posts: 75
J
janitor Offline OP
journeyman
janitor  Offline OP
journeyman
J
Joined: Aug 2006
Posts: 75
thanks ruben and rick smile


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,530
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)