[Forum] Failed upgrade

[Crossett]

Was upgrading from 4.0 and when I went to load the upgrade.php file in a browser I got this error.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
/home/cr0ssettps/thegunvault.org/forums/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Friday, December 17th 2010 @ 11:25:10 AM
Error Date : Friday, December 17th 2010 @ 11:25:10 AM
Script : http://thegunvault.org/forums/install/upgrade.php
Referrer :
IP Address : 97.77.98.98
Username :
Classname : vB_Database
MySQL Version :

Don't know what went wrong, or what I should do from here.

[TheLastSuperman]

Seems as if your server just well.. hiccup'd so you should be able to try it again just fine IF you never started the script? If you did it might be well advised to restore a backup and try again .

[Crossett]

Trying to run the upgrade.php file still gives me the same error

[Loco.M]

double check your config.php file
I bet you don't have the correct DB info in it..

[Crossett]

double check your config.php file
I bet you don't have the correct DB info in it..

This seems to be the problem, and I overwrote the old one... *facepalm*

Now to find out all the correct information again.

[Loco.M]

It's a pretty easy fix, let us know if you run into problems or can't find the old DB info.

[Crossett]

It's a pretty easy fix, let us know if you run into problems or can't find the old DB info.

I don't know exactly where to find the info, or what I need to change.

[Loco.M]

okay, one step at a time..
do you have cpanel or some type of hosting panel with your host?

[Crossett]

yes

[Loco.M]

okay, do you see a mysql icon like this


actually, if you want me to take a look (like I did here yesterday) I can get you setup in a matter of minutes
just shoot me a pm and we can go from there

[Loco.M]

well you have changed something, this shouldn't show all this gibberish and it wasn't when I looked 10 mins ago

http://thegunvault.org/forums/

I would open up a support ticket and have them take a look
send them the same login info you sent me along with the url to your forum (in the sensitive data section)

[Crossett]

well you have changed something, this shouldn't show all this gibberish and it wasn't when I looked 10 mins ago

http://thegunvault.org/forums/

I would open up a support ticket and have them take a look
send them the same login info you sent me along with the url to your forum (in the sensitive data section)

Yeah I changed the config.php file. A member of the forum was trying to fix it. I tried a support ticket, but since I didn't buy the suite just the forum they won't do anything and referred me here.

That obviously didn't work so I changed back to the config file with no information about the DB in it just like before

[Loco.M]

we got things working again
this is what happen, for future reference..

the db server wasn't set correctly, it was set to localhost, and it needed to be mysql.hostingsite.com etc..
also the table prefix was off