|
|
Joined: Jun 2002
Posts: 7
Lurker
|
|
Lurker
Joined: Jun 2002
Posts: 7 |
I just upgraded from 6.1 to 6.2.3 , everything is happy except the addons (i.e. ubbttopthreads and ubbtposters). Both worked before upgrading. Now, topthreads shows this error: SQL ERROR: Database error only visible to forum administrators<br /><br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mysql.inc.php on line 130<br /> And topposters shows the correct username, and post numnber, yet when clicked on it says that user is no longer in the database even though it is. I am pretty sure this is probably an error on my part... Note to self: Do not try to upgrade anything while drinking:)
|
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
hehe  Double-check that you uploaded the new addons files 
|
|
|
|
|
Joined: Jun 2002
Posts: 7
Lurker
|
|
Lurker
Joined: Jun 2002
Posts: 7 |
Well, not drinking tonight  , after uploading the addons again... the topposters works fine (I.E. clicking on users brings up their profile), but still get the same error on topthreads... 
|
|
|
|
|
Joined: Jun 2002
Posts: 7
Lurker
|
|
Lurker
Joined: Jun 2002
Posts: 7 |
Still having the same problem... I am either overlooking something simple or I pooched it from the beginning... As I said eariler, ubbtposters works GREAT. But, ubbttopthreads throws that error. It worked fine before upgrading.. After looking at both the addons, I see that ubbttopthreads has this t1 and t2 stuff in the query: $query = "<br /> SELECT t1.B_Number,t1.B_Posted,t1.B_Last_Post,t2.B_Username,t1.B_Subject,t1.B_Body,t1.B_Main,t1.B_Replies,t1.B_Counter,t1.B_Boa$<br /> FROM {$config['tbprefix']}Posts AS t1,<br /> {$config['tbprefix']}Users AS t2<br /> WHERE t1.B_Number = t1.B_Main <br /> AND t1.B_Last_Post > '$date'<br /> AND t1.B_PosterId = t2.U_Number<br /> ORDER BY $sort DESC<br /> LIMIT $totalthreads<br /> ";<br /> $sth = $dbh -> do_query($query) And the ubbtposters does not use any of the t1 and t2 prefixes. May that be my problem? I am at a total loss here.
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Doesn't look like this has been updated. The B_Username field no longer exists in 6.2 and higher. 
|
|
|
|
|
Joined: Jun 2002
Posts: 7
Lurker
|
|
Lurker
Joined: Jun 2002
Posts: 7 |
That did it Josh, thanks
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 87
Joined: December 2001
|
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
| |
Most Online5,166
Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
