Editing configure.php because DB_ERROR

[vanhooffmodelbouw]

Hi,

My site gets an error since a few days: 0 DB_ERROR_NOT_CONNECTED. I know that this problem is due to my host who did move the server. The site cannot connect anymore to the MySql database.

In the forum of my host they talk about editing the config because it contains probably an hardcoded IP-address. I looked up the configure.php file in the includes folder. And found this line:

define('DB_SERVER', '10.0.0.3'); // eg, localhost - should not be empty

In my phpmyadmin i see:

MySQL 5.1.9-beta-log draait op 10.0.1.40 als [email protected]

So, i tried to change the 10.0.0.3 in the 10.0.1.40, but it won't to the job. How can i get my site up and running again?

Thanks in advance.

[birdoasis]

Try localhost instead of the ip number.

localhost should work everywhere, no matter what server your on.

If you still can't connect, create a new user, assign that user to your db, and then add the new user to your config with the password for the new user.

[vanhooffmodelbouw]

I edited: define('DB_SERVER', '10.0.0.3'); -> define('DB_SERVER', 'localhost');

But it didn't seem to help. Is this the only line i have to edit?

Nothing changed to the sql database names, only the ip adres of the server changed and apparantly because of wrong coding i get the error. So, I don't think other database names will help.

[vanhooffmodelbouw]

The problem is solved.

One must edit the configure file in the includes map and in the admin/includes map. I changed define('DB_SERVER', '10.0.0.3'); in define('DB_SERVER', 'sql1.hostname.com');. After this, also repaired the who_online table in sql en reset the permission to read/write the configure file (CHMOD).

[vanhooffmodelbouw]

It seems that a new problem occured.

I cannot login to my admin pages. The user name and password is correct, because otherwise an error will occur. This time no error occured and after clicking login i will be redirected to the same login page. This same problem will occur when customers try to login to the site.

Anybody knows what causes this problem and how i can solve it?