Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Ruben), 62 guests, and 227 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,918
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
Morgan 13
isaac 11
Ruben 7
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
[FIXED for 7.5.1] 7.5 Change Groups Problems #224068
03/13/09 03:05 PM
03/13/09 03: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 03:10 PM
03/13/09 03: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 05:20 PM
03/13/09 05:20 PM
Joined: Dec 2003
Posts: 5,889
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,889
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 06:15 PM
03/13/09 06: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 06:23 PM
03/13/09 06:23 PM
Joined: Dec 2003
Posts: 5,889
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,889
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 06:26 PM
03/13/09 06: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 06:52 PM
03/13/09 06:52 PM
Joined: Dec 2003
Posts: 5,889
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,889
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 07:12 PM
03/13/09 07: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 07:18 PM
03/13/09 07:18 PM
Joined: Dec 2003
Posts: 5,889
Lutz,FL
Ruben Online yawn

Ruben  Online Yawn


Joined: Dec 2003
Posts: 5,889
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 07: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 10:32 AM
03/16/09 10: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 12:29 PM
03/17/09 12:29 PM
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
https http
by sundance. 05/22/18 05:46 PM
Want to Delete All Old Private Messages
by BellaOnline. 05/19/18 02:00 AM
How to remove Shout Chat
by Outdoorking. 05/17/18 08:37 AM
I am trying to put a banner ad on email template.
by sundance. 05/14/18 01:59 PM
Pruning Members Best Practices
by Shawn Grim. 05/10/18 05:36 PM
Forum Statistics
Forums36
Topics35,114
Posts191,263
Members12,075
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180524)