PDA

View Full Version : Serious upgrade problems



HondaATC
Tue 10th Apr '07, 1:29am
After uploading all the new 3.6.5 files to my webserver I plugged in the address to the upgrade file and was rewarded with this:


am string PHP error text string
* @param strig File that contained the error
* @param integer Line in the file that contained the error
*/
function catch_db_error($errno, $errstr, $errfile, $errline)
{
global $db;
static $failures;

if (strstr($errstr, 'Lost connection') AND $failures < 5)
{
$failures++;
return;
}

if (is_object($db))
{
$db->halt("$errstr\r\n$errfile on line $errline");
}
else
{
vb_error_handler($errno, $errstr, $errfile, $errline);
}
}

// ################################################## ###########################
/**
* Removes the full path from being disclosed on any errors
*
* @param integer Error number
* @param string PHP error text string
* @param strig File that contained the error
* @param integer Line in the file that contained the error
*/
function vb_error_handler($errno, $errstr, $errfile, $errline)
{
switch ($errno)
{
case E_WARNING:
case E_USER_WARNING:
/* Don't log warnings due to to the false bug reports about valid warnings that we suppress, but still appear in the log
require_once(DIR . '/includes/functions_log_error.php');
$message = "Warning: $errstr in $errfile on line $errline";
log_vbulletin_error($message, 'php');
*/

if (!error_reporting() OR !ini_get('display_errors'))
{
return;
}
$errfile = str_replace(DIR, '', $errfile);
echo "<br /><strong>Warning</strong>: $errstr in <strong>$errfile</strong> on line <strong>$errline</strong><br />";
break;

case E_USER_ERROR:
require_once(DIR . '/includes/functions_log_error.php');
$message = "Fatal error: $errstr in $errfile on line $errline";
log_vbulletin_error($message, 'php');

if (error_reporting() OR ini_get('display_errors'))
{
$errfile = str_replace(DIR, '', $errfile);
echo "<br /><strong>Fatal error:</strong> $errstr in <strong>$errfile</strong> on line <strong>$errline</strong><br />";
}
exit;
break;
}
}

// ################################################## ###########################
/**
* Unicode-safe version of htmlspecialchars()
*
* @param string Text to be made html-safe
*
* @return string
*/
function htmlspecialchars_uni($text, $entities = true)
{
return str_replace(
// replace special html characters
array('<', '>', '"'),
array('&lt;', '&gt;', '&quot;'),
preg_replace(
// translates all non-unicode entities
'/&(?!' . ($entities ? '#[0-9]+' : '(#[0-9]+|[a-z]+)') . ';)/si',
'&amp;',
$text
)
);
}

/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 19:09, Mon Apr 9th 2007
|| # CVS: $RCSfile$ - $Revision: 16483 $
|| ################################################## ##################
\*================================================ ======================*/
?>type'] = intval($logtype);

$moderatorlog['forumid'] = intval($loginfo['forumid']);
$moderatorlog['threadid'] = intval($loginfo['threadid']);
$moderatorlog['postid'] = intval($loginfo['postid']);
$moderatorlog['pollid'] = intval($loginfo['pollid']);
$moderatorlog['attachmentid'] = intval($loginfo['attachmentid']);

$moderatorlog['ipaddress'] = IPADDRESS;

if (is_array($action))
{
$action = serialize($action);
}
$moderatorlog['action'] = $action;

/*insert query*/
$vbulletin->db->query_write(fetch_query_sql($moderatorlog, 'moderatorlog'));
}
}

/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 19:09, Mon Apr 9th 2007
|| # CVS: $RCSfile$ - $Revision: 14633 $
|| ################################################## ##################
\*================================================ ======================*/
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title> Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
blockquote { margin-top: 75px; }
p { font: 11px tahoma, verdana, arial, sans-serif; }
-->
</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:">Technical Staff</a>, whom you can also contact if the problem persists.</p>
<p>We apologise for any inconvenience.</p>

<form><textarea rows="15" cols="70" wrap="off">Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Host 'vps.3wheelerworldforums.com' is not allowed to connect to this MySQL server
/home/hondaatc/public_html/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Tuesday, April 10th 2007 @ 12:23:04 AM
Script : http://3wheelerworldforums.com/install/upgrade.php
Referrer :
IP Address : 75.104.46.69
Username :
Classname : vb_database</textarea></form>
</blockquote>
</blockquote>
</body>
</html>d id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">3wheelerworldforums.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The 3wheelerworldforums.com forum technical staff have been notified of the error, though you may <a href="mailto:">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<form><textarea rows="15" cols="70" wrap="off">Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Host 'vps.3wheelerworldforums.com' is not allowed to connect to this MySQL server
/home/hondaatc/public_html/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Tuesday, April 10th 2007 @ 12:23:04 AM
Script : http://3wheelerworldforums.com/install/upgrade.php
Referrer :
IP Address : 75.104.46.69
Username :
Classname : vb_database</textarea></form>

</body>I uploaded everything in ASCII format, twice. I removed install.php, and I upgraded from the previous version of config.php to the newer format. In addition to that, all my other options seem to match what I was previously running a live forum on. Wht in the world is going on here?

Edit: I accidently typed "install" in my subject, that should be upgrade. I am NOT doing a fresh install, I'm upgrading from a previous 3.5.4 version. Sorry for the confusion.

Steve Machol
Tue 10th Apr '07, 2:14am
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Host 'vps.3wheelerworldforums.com' is not allowed to connect to this MySQL server

That's your problem. You either have the wrong db info in your config.php file, or you are no longer able to connect to that server. If you are sure the info is correct, then you need to contact your host about this.

HondaATC
Tue 10th Apr '07, 9:38am
Hypothetically speaking, what would the results of my forum database be if I accidently ran a upgrade script for the same version I was already running (minus security patches)? Like, the correct version of the install/includes folder didn't get up uploaded :eek:

HondaATC
Tue 10th Apr '07, 10:56am
Heres what I'm getting now after fiddling with the config file and removing the IP for the server and putting in localhost like it is default:


am string PHP error text string * @param strig File that contained the error * @param integer Line in the file that contained the error */ function catch_db_error($errno, $errstr, $errfile, $errline) { global $db; static $failures; if (strstr($errstr, 'Lost connection') AND $failures < 5) { $failures++; return; } if (is_object($db)) { $db->halt("$errstr\r\n$errfile on line $errline"); } else { vb_error_handler($errno, $errstr, $errfile, $errline); } } // ################################################## ########################### /** * Removes the full path from being disclosed on any errors * * @param integer Error number * @param string PHP error text string * @param strig File that contained the error * @param integer Line in the file that contained the error */ function vb_error_handler($errno, $errstr, $errfile, $errline) { switch ($errno) { case E_WARNING: case E_USER_WARNING: /* Don't log warnings due to to the false bug reports about valid warnings that we suppress, but still appear in the log require_once(DIR . '/includes/functions_log_error.php'); $message = "Warning: $errstr in $errfile on line $errline"; log_vbulletin_error($message, 'php'); */ if (!error_reporting() OR !ini_get('display_errors')) { return; } $errfile = str_replace(DIR, '', $errfile); echo "
Warning: $errstr in $errfile on line $errline
"; break; case E_USER_ERROR: require_once(DIR . '/includes/functions_log_error.php'); $message = "Fatal error: $errstr in $errfile on line $errline"; log_vbulletin_error($message, 'php'); if (error_reporting() OR ini_get('display_errors')) { $errfile = str_replace(DIR, '', $errfile); echo "
Fatal error: $errstr in $errfile on line $errline
"; } exit; break; } } // ################################################## ########################### /** * Unicode-safe version of htmlspecialchars() * * @param string Text to be made html-safe * * @return string */ function htmlspecialchars_uni($text, $entities = true) { return str_replace( // replace special html characters array('<', '>', '"'), array('<', '>', '"'), preg_replace( // translates all non-unicode entities '/&(?!' . ($entities ? '#[0-9]+' : '(#[0-9]+|[a-z]+)') . ';)/si', '&', $text ) ); } /*================================================= =====================*\ || ################################################## ################## || # Downloaded: 19:09, Mon Apr 9th 2007 || # CVS: $RCSfile$ - $Revision: 16483 $ || ################################################## ################## \*================================================ ======================*/ ?> uding and disabled products * * $vbulletin->bf_ugp_forumpermissions['canview'] would be returned as $array['ugp']['forumpermissions']['canview'] * * @return array */ function return_data() { if (vB_Bitfield_Builder::build(true, true) === false) { return false; } $obj =& vB_Bitfield_Builder::init(); return $obj->data; } } /*================================================= =====================*\ || ################################################## ################## || # Downloaded: 19:09, Mon Apr 9th 2007 || # CVS: $RCSfile$ - $Revision: 15646 $ || ################################################## ################## \*================================================ ======================*/ ?>, $attr, $closing = false) { $tmp = "<$tag"; if (!empty($attr)) { foreach ($attr AS $attr_name => $attr_key) { if (strpos($attr_key, '"') !== false) { $attr_key = htmlspecialchars_uni($attr_key); } $tmp .= " $attr_name=\"$attr_key\""; } } $tmp .= ($closing ? " />\n" : '>'); return $tmp; } function escape_cdata($xml) { // strip invalid characters in XML 1.0: 00-08, 11-12 and 14-31 // I did not find any character sets which use these characters. $xml = preg_replace('#[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]#', '', $xml); return str_replace(array(''), array('«![CDATA[', ']]»'), $xml); } function output() { if (!empty($this->open_tags)) { trigger_error("There are still open tags within the document", E_USER_ERROR); return false; } return $this->doc; } function print_xml() { if (defined('NOSHUTDOWNFUNC')) { $this->registry->db->close(); } $this->send_content_type_header(); echo $this->fetch_xml_tag() . $this->output(); exit; } } // ################################################## ########################### class vB_AJAX_XML_Builder extends vB_XML_Builder { function escape_cdata($xml) { $xml = preg_replace('#[\\x00-\\x08\\x0B\\x0C\\x0E-\\x1F]#', '', $xml); return str_replace(array(''), array('<=!=[=C=D=A=T=A=[', ']=]=>'), $xml); } } // ################################################## ########################### // legacy stuff class XMLparser extends vB_XML_Parser { } class XMLexporter extends vB_XML_Builder { } /*================================================= =====================*\ || ################################################## ################## || # Downloaded: 19:09, Mon Apr 9th 2007 || # CVS: $RCSfile$ - $Revision: 15670 $ || ################################################## ################## \*================================================ ======================*/ ?>


I'm certain the mysql database is pointed correctly, as is the login information. The database seems to be intact from the brief inspection I did via phpmyadmin. I'm waiting to hear back from my host but is there anything else I can check on?

Steve Machol
Tue 10th Apr '07, 1:34pm
I can't read that. However if you are sure the info in config.php is correct, then this is a server issue that you need to contact your host about.