Just moved hosts.. worked fine for a bit...

then....


There seems to have been a problem with the database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.


This is the error that I find in viewing the page source:


Database error in vBulletin :

mysql_connect(): Can't connect to MySQL server on 'localhost' (10061)
D:\domains\weareleeds.com\wwwroot\includes\class_c ore.php on line 279

MySQL Error :
Error Number :
Date : Thursday, August 17th 2006 @ 05:10:52 PM
Script : http://www.weareleeds.com/index.php
Referrer :
IP Address : 80.3.160.9
Username :
Classname : vb_database
-->




This is what I have within my \includes\config.php


// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'forum';

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = 'admin@weareleeds.com';

// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = true;



// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 5533;
// $config['MasterServer']['port'] = 3306;

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = '*****';
$config['MasterServer']['password'] = '*****';

// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;


I changed the port from the default of 3306 as my host advised that is what their settings are, and obviously I have edited out the username and password. Like I said, worked for a bit, then the above happened. All help appreciated.

[Zachery]

Its possible since they made the change they haven't reloaded IIS or restarted the server.

[majoreyeswater]

Originally Posted by Zachery

Its possible since they made the change they haven't reloaded IIS or restarted the server.

Unfortunately, they've restarted twice. Sooo annoying when you don't have access to the server, so much for saving me money, it's costing me a fortune in time.

Their last response was:
"Just changed the extensions location in php.ini from .\ to c:\php4\extensions and phpinfo() doesn't seem to display anything about GD despite a reboot"

I've looked through the phpinfo() output and indeed, GD is not refernced anywhere... you can see this here: PHP info output and I can't pickup GD in admincp at all, so don't know what this might be...

[I-Web]

Just looking thru phpinfo and noticed a few anomolies......

Configuration File (php.ini) Path C:\WINDOWS

is part of yours when it should read......

Configuration File (php.ini) Path C:\WINDOWS\php.ini

also noticed he has 2 installations of php as seen in ENV[Path]

C:\\PHP4;C:\\PHP5;

also looking at info the php.ini is situated in C:\\PHP5\\php.ini

[majoreyeswater]

Thank you for that, I am taking it up with my hosts as I type. Should the php.ini file be situated in the Windows directory at all, especially is later on it is suggesting it is on \PHP5\ - am a little confused by that.

UPDATE:

I have just had a response from the hosting service, although I am getting more than slightly concerned that they don't really know what they are doing:

We have PHP4 and PHP5, some customers prefer one or the other and our control panel allows them to choose which.

PHP4 is in C:\PHP4
PHP5 is in C:\PHP5

Neither should be using a php.ini in C:\Windows. In fact there isn't such a file in that location. They should use their own .ini in their respective directories.

I don't know how (or why) PHP4 could be picking up the .ini for PHP5. I also don't know if there is any way of forcing it to use the correct one. Any ideas?

My set up is pointing to the PHP4 option and rather than change my own board settings, I rather keep the config as it is and get them to correct the PHP config so as simple things like GD lib will actually work.

I'm out of my depth at the moment and short of taking this all back in house, or moving it elsewhere and inconveniencing my users yet again, I could do with some other pointers.

All your inputs and efforts are appreciated.

[Zachery]

Why is because they failed to set the ini dir via the registry. which needs to be set.