Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Ruben), 42 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/24/10
Posts: 8
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#219087 - 11/11/08 04:44 PM [FIXED] [7.4.1] Error in showprofile.inc.php
Micky Offline
newbie
Registered: 08/02/06
Posts: 39
Loc: Bern, Switzerland
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
Top
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."
#219090 - 11/11/08 05:16 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Micky]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Good catch! Thanks for the report and fix.
Top
#220694 - 12/31/08 02:52 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Rick]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Bump.
Rick don't forget this one for bug fix release
_________________________
Blue Man Group
Top
#220696 - 12/31/08 03:16 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Ruben]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
This one was fixed and is already in 7.4.1 wink
Top
#220697 - 12/31/08 03:21 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Rick]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
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


Edited by Ruben Rocha (12/31/08 03:26 PM)
_________________________
Blue Man Group
Top
#220698 - 12/31/08 03:26 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Ruben]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The bug was there, or the fix was there?
Top
#220699 - 12/31/08 03:28 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Rick]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
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
Top
#220700 - 12/31/08 03:29 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Ruben]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hrmm, ok. Well I have it fixed for 7.4.2 then laugh
Top
#220703 - 12/31/08 03:55 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Rick]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Its good to Talk lol
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#220705 - 12/31/08 04:13 PM Re: [7.4.1] Error in showprofile.inc.php [Re: Mark S]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
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
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image