Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
I had version 5-5-1 installed on server A. I had to switch to server B. So I backed up the mysql database and uploaded it to server B. Then I copied the files of 5-5-1 over to server B. So far, so good. Everything worked. I even made a second backup of the mysql database just for good measure. Then I followed the document "Upgrade to a Newer Licensed Version." It resulted in multiple errors. The one thing that sort of looses me is the altertables in the UPGRADING.html page. It sort of seems like it supposed to work like magic. You just click on the hypertext link and suddenly that's supposed to actually do something besides just sit and look at you in your Browser? Is anything else supposed to happen? Anyway... after far too many hours I must sleep and pray some kind soul helps me out. As it stands... I redid everything as stated... and found out that the only files that are causing errors are:

ubbthreads.php
mysql.inc.php
ubbt.inc.php
main.inc

When I replace these with the old version 5.5.1 I get some semblance of order, no upgrade, and no mysql errors.

After I replace these I get the following errors...

SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fourfrie/public_html/ubbthreads/mysql.inc.php on line 131

Warning: Cannot modify header information - headers already sent by (output started at /home/fourfrie/public_html/ubbthreads/mysql.inc.php:217) in /home/fourfrie/public_html/ubbthreads/ubbt.inc.php on line 235

I can't open the UBB.threads Admin control panel because everything is errored out.

This is what my mysql.inc.php file looks like:

<?
/*
# UBB.threads, Version 6
# Official Release Date for UBB.threads Version6: 06/05/2002

# First version of UBB.threads created July 30, 1996 (by Rick Baker).
# This entire program is copyright Infopop Corporation, 2002.
# For more info on the UBB.threads and other Infopop
# Products/Services, visit: http://www.infopop.com

# Program Author: Rick Baker.

# You may not distribute this program in any manner, modified or otherwise,
# without the express, written written consent from Infopop Corporation.

# Note: if you modify ANY code within UBB.threads, we at Infopop Corporation
# cannot offer you support-- thus modify at your own peril <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />
# ---------------------------------------------------------------------------
*/

// #########################################################################
// Database class for mysql functions
// #########################################################################
class sql {

// #######################################################################
// Connect to the database
// #######################################################################
function connect() {

global $config;

if (!isset($this->dbh)) {
if (!$config['persistent']) {
$this->dbh = mysql_connect($config['dbserver'],$config['dbuser'],$config['dbpass']);
}
else {
$this->dbh = mysql_pconnect($config['dbserver'],$config['dbuser'],$config['dbpass']);
}

}
if (!$this->dbh) {
$this->not_right("Unable to connect to the database!");
}
mysql_select_db($config['dbname'],$this->dbh);

}

// #######################################################################
// Grab the error descriptor
// #######################################################################
function graberrordesc() {
$this->error=mysql_error();
return $this->error;
}

// #######################################################################
// Grab the error number
// #######################################################################
function graberrornum() {
$this->errornum=mysql_errno();
return $this->errornum;
}

// #######################################################################

And this is what my ubbt.inc.php file looks like...

actually, that files too **** long...

Please let me know if you have any suggestions... besides that I shouldn't have wasted my time or money on the upgrade.

Thank you very much for your time and effort!
Naomi

[This message was edited by JoshPet on August 14, 2003 at 04:57 PM.]

Anonymous
Unregistered
Anonymous
Unregistered
You said you're simply moving UBB.threads version 5.5.1 from one server to another?

That initial part of the mysql.inc.php file appears to be from UBB.threads version 6.x.

-----
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by Dave_L:
You said you're simply moving UBB.threads version 5.5.1 from one server to another?

That initial part of the mysql.inc.php file appears to be from UBB.threads version 6.x.
</font><hr /></blockquote><font size="" face="">No, I'm doing more than just moving the UBB.threads version 5.5.1 from one server to the other. That was just the first step. I was told that I needed to do that first and to get it up and running... and then, I neeed to upgrade from version 5.5.1 to the latest version 6x downloaded out of the members area yesterday. So the errors above are what you see after I install version 6x on top of version 5.5.1. Is there any other way I can get this newer version up... but still utilize all the old information from the old board? Does anyone know how to correct the above errors?

Thanks!
Naomi

Anonymous
Unregistered
Anonymous
Unregistered
Have you run the altertables?

Since you are moving and upgrading at the same time.... I'd make sure 5.5.1 is functional before you try to upgrade... otherwise we don't know if it's a configuration error or an upgrade error.

ThreadsDev.com Admin | xDev Admin | JoshuaPettit.com Beta Test Site
Visit ThreadsDev for UBB.Threads Modifications, Addons, Templates and Stylesheets.
My UBB.Threads abilities are for hire for upgrades, installs and custom modifications.

Anonymous
Unregistered
Anonymous
Unregistered
Thanks for responding. I'm just sitting here waiting for your responses. I did make sure 5.5.1 was functional. It works just fine... It's definitely an upgrade error... now what?

Naomi

Anonymous
Unregistered
Anonymous
Unregistered
</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by JoshPet:
Have you run the altertables?
</font><hr /></blockquote><font size="" face="">Forgot to answer this question. Actually the first time I tried the upgrade I ran the first altertable 5-5-6 but then I saw no pooint in continuing because I couldn't go into the admin area and run the online config editor. I just redid the whole install... 5-5-1 is functional once again... but I'm having the same errors. This time I didn't run even the first altertable because I figured it wasn't worth it... if I couldn't run the online config editor to update the version # and set any new variables. Also, when I run altertables... is it supposed to do anything more than show up in my browser?

thanks again... for taking your time...

Naomi

Anonymous
Unregistered
Anonymous
Unregistered
It should cycle through all the steps and indicate that it's finished.

ThreadsDev.com Admin | xDev Admin | JoshuaPettit.com Beta Test Site
Visit ThreadsDev for UBB.Threads Modifications, Addons, Templates and Stylesheets.
My UBB.Threads abilities are for hire for upgrades, installs and custom modifications.

Anonymous
Unregistered
Anonymous
Unregistered
Actually - Just an updated.

Naomi contacted me this afternoon and I was able to get her site udpated to 6.3.1 and back online. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />
So this issue is solved. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

ThreadsDev.com Admin | xDev Admin | JoshuaPettit.com Beta Test Site
Visit ThreadsDev for UBB.Threads Modifications, Addons, Templates and Stylesheets.
My UBB.Threads abilities are for hire for upgrades, installs and custom modifications.

Anonymous
Unregistered
Anonymous
Unregistered
This is just a little message to those of you sitting around in your pajamas and wringing your hands!

Call Josh, depart with a few greenbacks... he's fast, he's furioous, and definitely worth the relief!

Gotta love this dude!!!!!!!

Okay... I know... I need some sleep before I start gushing any more!

Naomi


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)