Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2006
Posts: 26
newbie
newbie
Joined: Aug 2006
Posts: 26
My Error Message

We encountered a problem. The reason reported was

Script: /xxxxxxxxxx/scripts/showprofile.inc.php
Line#: 138
SQL Error: Table 'xxxxxxxxxx.ubbt_ONLINE' doesn't exist
SQL Error #: 1146
Query: SELECT count( t1.USER_ID ) FROM ubbt_ONLINE AS t1, ubbt_USER_PROFILE AS t2 WHERE t1.USER_ID = t2.USER_ID AND t1.USER_ID = 3

Please click back to return to the previous page.

Find in /scripts/showprofile.inc.php

PHP Code
 $query = "
		SELECT count( t1.USER_ID )
		FROM ubbt_ONLINE AS t1, ubbt_USER_PROFILE AS t2
		WHERE t1.USER_ID = t2.USER_ID
		AND t1.USER_ID = ?
		$extraquery
	"; 

and replaces

PHP Code
 $query = "
		SELECT count( t1.USER_ID )
		FROM {$config['TABLE_PREFIX']}ONLINE AS t1, {$config['TABLE_PREFIX']}USER_PROFILE AS t2
		WHERE t1.USER_ID = t2.USER_ID
		AND t1.USER_ID = ?
		$extraquery
	"; 

Finishedly wink


Gruss Micky

Sorry for my bad English whistle

Golf Diesel Forum
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Good catch! Thanks for the report and fix.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Bump.
Rick don't forget this one for bug fix release


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
This one was fixed and is already in 7.4.1 wink

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Thats funny I just installed 7.4.1 on a new host for a test and it was there.
Zip file is dated 11/10/2008

Last edited by Ruben Rocha; 12/31/2008 4:26 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
The bug was there, or the fix was there?

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
the bug was there. I had to edit and add the fix because it was a test board and I named the tables all test_ for the prefix.


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
Hrmm, ok. Well I have it fixed for 7.4.2 then laugh

Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Its good to Talk lol


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Rick the fix is in 7.4.1 now.
You must have updated it the day after the release.
I just downloaded a fresh copy of 7.4.1 and the fix is in place.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

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
2 members (Havenofsobriety, rootman), 624 guests, and 106 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)