PDA

View Full Version : Panic, i try to upgrade from 3.6.3 to 3.6.4



tonynlek
Sun 28th Jan '07, 12:48pm
Guys, i am in a panic mood now. after i tried to do a upgrade, after it is done , it give me database error. my whole forum is gone.. what has happen?

Steve Machol
Sun 28th Jan '07, 12:51pm
We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

tonynlek
Sun 28th Jan '07, 12:54pm
OK, i try to install again, in the process of transferring the files now in my FTP. IF it happens again, i will post the view/source.

tonynlek
Sun 28th Jan '07, 1:43pm
Below is the source code of the error page, Please check for me. Panicing now..:(

<!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">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="../image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td 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="/">www.superveggiehealth.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 www.superveggiehealth.com (http://www.superveggiehealth.com) forum technical staff have been notified of the error, though you may <a href="<A href="mailto:dbmaster@example.com">contact">mailto:dbmaster@example.com">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" id="message">Database error in vBulletin :
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'root'@'localhost' (using password: NO)
/home/super53/public_html/forum/includes/class_core.php on line 273
MySQL Error :
Error Number :
Date : Sunday, January 28th 2007 @ 09:41:11 AM
Script : http://www.superveggiehealth.com/forum/install/upgrade.php
Referrer :
IP Address : 165.21.155.10
Username :
Classname : vb_database</textarea></form>
</body>
</html>

tonynlek
Sun 28th Jan '07, 1:44pm
<!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">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td 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="/">www.superveggiehealth.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 www.superveggiehealth.com (http://www.superveggiehealth.com) forum technical staff have been notified of the error, though you may <a href="<A href="mailto:dbmaster@example.com">contact">mailto:dbmaster@example.com">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>

<!--
Database error in vBulletin :
mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'root'@'localhost' (using password: NO)
/home/super53/public_html/forum/includes/class_core.php on line 273
MySQL Error :
Error Number :
Date : Sunday, January 28th 2007 @ 09:44:08 AM
Script : http://www.superveggiehealth.com/forum/
Referrer :
IP Address : 165.21.155.17
Username :
Classname : vb_database
-->

</body>
</html>

Steve Machol
Sun 28th Jan '07, 2:36pm
The relevant error is:

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Access denied for user 'root'@'localhost' (using password: NO)

It looks like you did not edit config.php with your specific database info. Please read this for all the known causes of this error:

http://www.vbulletin.com/forum/showthread.php?t=194542

Carrie Anderson
Sun 28th Jan '07, 2:39pm
Looks like you might have accidentally overwritten your vB config.php file. Open the vB config.php file and reset your values. Unless specifically indicated, you don't need to overwrite the vB config.php file when doing an upgrade.

EDIT: Steve is fast. :D

tonynlek
Sun 28th Jan '07, 5:03pm
so how should i do it? Open it from the one that i have loaded inthe server? Is my data all gone?

Sorry what do you mean why no need to overwrite the vb config.php file. I only thought that i need to delete the install.php and everything is ok and just upload everything up.

tonynlek
Sun 28th Jan '07, 5:05pm
It looks like you did not edit config.php with your specific database info. Please read this for all the known causes of this error:


Do i have to edit my config.php, The upgrade readme file didnt tell me to do that.

Steve Machol
Sun 28th Jan '07, 5:42pm
You should not have to re-edit your config.php file upgrading from 3.6.3 to 3.6.4. Unless you have changed the db info you can use the same file and settings.

derekivey
Sun 28th Jan '07, 5:42pm
You probably overwrote your old config file. In that case, you need to edit the config.php file (located in the includes directory), like you did when you installed for the first time. After you edit it, it should work.

tonynlek
Sun 28th Jan '07, 5:48pm
Beside the database username and password, what other things should i put in? Gee, i forgot the password. Would my webhost be able to retrieve it for me?

I saw config.php ( which i have overwritten) and i also see a config.php.php ( this is VB 3.6.3, should i delete this one away?)

Steve Machol
Sun 28th Jan '07, 5:54pm
If you do not have a backup of your working config.php file, then I suggest contacting your host for the correct db info.