Log in

View Full Version : Database help!

revmitchell
04-21-2008, 05:11 PM
I upgraded and now nothing shows up but a database error on my site. I have a back up but I never have uploaded one before. How do I do this?
Opserty
04-21-2008, 05:47 PM
How can you expect someone to solve your problem when you just say you have an error?

Its like phoning up a mechanic and saying your car is not working and expecting them to fix it just like that. :p
Jase2
04-21-2008, 06:12 PM
^^ Correct hehe.

Please go to where the database error is, and select view/source. Copy-n-paste the full error message here.
revmitchell
04-21-2008, 06:14 PM
I have a back up but I never have uploaded one before. How do I do this?



What is unclear about this so I can clear it up?

Here is what the error reads:

<!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" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<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.pastors-source.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.pastors-source.com forum technical staff have been notified of the error, though you may <a href="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/httpd/vhosts/pastors-source.com/httpdocs/vb/includes/class_core.php on line 311

MySQL Error :
Error Number :
Date : Monday, April 21st 2008 @ 02:15:01 PM
Script : http://www.pastors-source.com/vb/index.php
Referrer :
IP Address : 97.100.161.197
Username :
Classname : vb_database
MySQL Version :
-->


</body>
</html>
Jase2
04-21-2008, 06:15 PM
Why try to upload a backup, when we may know how to correct your current problem, without the need to revert to a backup?
revmitchell
04-21-2008, 06:21 PM
Why try to upload a backup, when we may know how to correct your current problem, without the need to revert to a backup?


well if you can do that it would be appreciated.
Jase2
04-21-2008, 06:32 PM
Access denied for user: 'root@localhost' (Using password: NO)

That means exactly what it says. Check the information in your config.php as it isn't correct.
revmitchell
04-21-2008, 06:53 PM
Now here is the new error:

Parse error: syntax error, unexpected T_VARIABLE in /home/httpd/vhosts/pastors-source.com/httpdocs/vb/includes/config.php on line 123
snunhuck
04-21-2008, 06:55 PM
Check line 123. :) match it with the orinigal config.php.new to ensure you did accidentally edit it where you shouldn't have.
revmitchell
04-21-2008, 06:57 PM
I have no idea to know what line 123 is
snakes1100
04-21-2008, 06:57 PM
fix line 123, did you accidently remove the ' or ; from the line?

$config['SpecialUsers']['canrunqueries'] = '1';

Enter your userid there, make sure you dont remove anything and the userid is between the quotes
revmitchell
04-21-2008, 07:04 PM
Here is that line as it stand right now:

$config['SpecialUsers']['canrunqueries'] = '3';

Anything wrong with that?
Jase2
04-21-2008, 07:08 PM
Try a new config.php file.
snakes1100
04-21-2008, 08:05 PM
Check each line in the file and make sure that no other line has been effected and is in the correct format.

Try to correct your mistake before overwriting it with a new config file
revmitchell
04-21-2008, 08:15 PM
Now I have a new error:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user: 'root@localhost' (Using password: NO)
/home/httpd/vhosts/pastors-source.com/httpdocs/vb/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Monday, April 21st 2008 @ 04:14:29 PM
Script : http://www.pastors-source.com/vb/install/upgrade.php
Referrer :
IP Address : 97.100.161.197
Username :
Classname : vb_database
Jase2
04-21-2008, 08:19 PM
Access denied for user: 'root@localhost' (Using password: NO)

Again, the info in your config.php is incorrect. Check your user and password.
revmitchell
04-21-2008, 08:47 PM
Again, the info in your config.php is incorrect. Check your user and password.

The password is there. i have checked it 10 times. I dont have a clue.
Marco van Herwaarden
04-22-2008, 09:01 AM
Please post the username and password lines from your config.php (you can blank out the password itself).