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.]
