Database error after uploading upgrade to 3.6.1

[Hurleydoc]

(Sorry about the bold, but it's to differentiate my words from the copy/paste more easily.)

I just downloaded the upgrade for vBulletin 3.6.1 (I had 3.6) and have hit a snag that I don't know how to correct.

Here is what I've done so far:

First, I downloaded all files from the forum to a folder on my hard drive to have as a backup at its current state. I also saved a .sql backup of the database to my hardrive.

Then I followed directions for upgrading from a previous version of Bulletin 3 (version was 3.6):

I closed the board via the admin CP.

I uploaded all files from the "upload" folder except install/install.php by overwriting files to the FTP. (I did not erase previous files, perhaps I should erase and reupload?)

I opened upload/includes folder and saved the old config.php to my backup folder on my computer to have it. I deletec the old "config.php" file from the ftp and changed the "config.php.new" to "config.php".

I opened it into a text editor and then tried to open the URL for my site/forum/install/upgrade.php and instead of the upgrade script, I get a database error. All pages from my site that are vbulletin pages report a database error as shown below:


------------------------------------------------------------------
http://(erased by me).com/forum/image.php?type=dberror
Database error
The database has encountered a problem.
Please try the following:

• Load the page again by clicking the Refresh button in your web browser.
• Open the (erased by me).com home page, then try to open another page.
• Click the Back button to try another link.

The (erased by me).com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
-------------------------------------------------------------------



I get this when trying to run the upgrade.php (with IP and name removed as this is a public forum)...

----------------------------------------------------------
Database error in vBulletin :
mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/hsphere/local/home/(erased by me).com/forum/includes/class_core.php on line 271
MySQL Error :
Error Number :
Date : Sunday, September 24th 2006 @ 01:50:52 PM
Script : http://(erased by me).com/forum/install/upgrade.php
Referrer :
IP Address : (erased by me)
Username :
Classname : vb_database
-----------------------------------------------------


Am I missing something or did I do something wrong with the upgrade?

(And yes, I checked that the PHP and MySQL versions are higher than required.)

[Hurleydoc]

OK, a bit more info...

I deleted the forum folder and reuploaded and changed new.config.php to config.php again. No change, still a database error.

However, if I switch the upgrade version of config with the old config.php file from my 3.6 version, it will open up the /install/upgrade.php page (though I didn't proceed since it isn't the new config file).

Thoughts?

[Hurleydoc]

In the meantime, a valuable lesson learned (a total "duh" thing, I know, but I'm learning)...I'm going to funnel this upgrade version to a dummy folder and put my old 3.6 back on the site so the forum can return to function until I get the problem resolved.

[Hurleydoc]

*bump*

Anyone else have a problem with the upgrade?

[Steve Machol]

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Please see this page for the causes of this error:

http://www.vbulletin.com/docs/html/cantconnect

[Hurleydoc]

From that link:

"Can't connect to local MySQL server through socket
If you are getting this error, it means either:

1. The info in your config.php file is wrong (in which case your forums wouldn't work at all), or

2. MySQL crashed, it's not running or it can't find the socket. You need to contact your host about this. Here is more info on this error:

MySQL 5.1:
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html

MySQL 5.0:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html

MySQL 3.23, 4.0, 4.1:
http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html

In Windows:
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server-on-windows.html
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html "

Since the upgrade seemed to work if I put in the config file from 3.6.0 in place of the one from the upgrade (3.6.1), I'm betting it's option number one. (Also since our other site using the same webhost and mysql system is working just fine, it seems that option number two is less likely.) What I don't see is a solution to that problem. I'm ignorant in the ways of config files, but I'm assuming that the 3.6.0 config file is not meant to be used with the 3.6.1 version files, so where can I find a good 3.6.1 config file for my upgrade since the one that I downloaded seemed to crash the system?

I take it I'm the only one to have had this problem with the new upgrade?

I've currently put back up the 3.6.0 backup and tabled the upgrade until I can resolve this question, but I really would like to be able to upgrade my version if possible, otherwise having a license rather than buying it outright is pointless.

[Steve Machol]

You can use the 3.6.0 config.php file with 3.6.1. There have been no changes to that file.