Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
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

Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
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

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
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.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
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


Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
no mods/hacks..

sorry to ask, but I might as well smile

how does the support ticket work?

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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/2009 7:21 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Definitely a bug when Last Online is selected as one of the clauses. Will work on getting this fixed for 7.5.1.

Joined: Aug 2006
Posts: 46
J
journeyman
journeyman
J Offline
Joined: Aug 2006
Posts: 46
thanks ruben and rick smile


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 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)