Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
4 registered members (isaac, joe_bruce, Geoff, JAISP), 63 guests, and 127 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 3,390
Joined: November 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 19
Ruben 10
Gizmo 8
Slaz 2
Geoff 2
FREAK 2
GregK 1
DennyP 1
Latest Photos
Testing to drag photos
Comfortable Cats
Test
BSA photos
Chinese Buddhist temple.
Previous Thread
Next Thread
Print Thread
Help with sql errors upgrade/server switch - please [solved] #21188
08/14/03 03:26 AM
08/14/03 03:26 AM
A
Anonymous OP
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.]

Re: Help with sql errors upgrade/server switch - please [solved] #21189
08/14/03 05:04 AM
08/14/03 05:04 AM
A
Anonymous OP
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.

Re: Help with sql errors upgrade/server switch - please [solved] #21190
08/14/03 01:14 PM
08/14/03 01:14 PM
A
Anonymous OP
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

Re: Help with sql errors upgrade/server switch - please [solved] #21191
08/15/03 03:45 AM
08/15/03 03:45 AM
A
Anonymous OP
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.

Re: Help with sql errors upgrade/server switch - please [solved] #21192
08/15/03 03:56 AM
08/15/03 03:56 AM
A
Anonymous OP
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

Re: Help with sql errors upgrade/server switch - please [solved] #21193
08/14/03 04:00 PM
08/14/03 04:00 PM
A
Anonymous OP
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

Re: Help with sql errors upgrade/server switch - please [solved] #21194
08/14/03 05:52 PM
08/14/03 05:52 PM
A
Anonymous OP
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.

Re: Help with sql errors upgrade/server switch - please [solved] #21195
08/14/03 07:56 PM
08/14/03 07:56 PM
A
Anonymous OP
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.

Re: Help with sql errors upgrade/server switch - please [solved] #21196
08/14/03 08:45 PM
08/14/03 08:45 PM
A
Anonymous OP
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


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
UBB.threads 7.6.2 - Released
by isaac. 09/17/18 08:08 AM
7.6.2 Changelog Discussion
by isaac. 09/17/18 06:35 AM
Upgrade Documentation
by DennyP. 09/15/18 03:55 PM
PHP 7.2
by Geoff. 09/12/18 10:22 PM
Email Cleanup-Is it possible?
by Ruben. 09/06/18 11:25 AM
Forum Statistics
Forums36
Topics35,139
Posts191,436
Members12,105
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2