Lost database connection

[SMIFFAD]

Really annoying problem and ive come to the end of my whitts with it

I installed ZEN for a customer of mine ages ago, and his host has insisted he change his SQL database password as they were hacked recently

Should have been simple enough, passwords changed, i can log into the database using MYSQL with no problem, and an old install of OSCOMMERCE works fine. For some reason the ZEN cart simply will not connect to the database! Even installed a new instance of zen and that will work!!! but not the old one.

Ive updated the info in the

includes/config.php &
admin/includes/configer.php

Both are correct, and the only thing thats changed is the password, but no joy.

Is there something else odd about Zen that i have missed?

Any help greatly appreciated at this point!

Just incase ive missed something:

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', '************);
define('DB_SERVER_USERNAME', '**********');
define('DB_SERVER_PASSWORD', '*************);
define('DB_DATABASE', '**************');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

[dbltoe]

Does the database actually have a prefix of zen_?

[SMIFFAD]

Does the database actually have a prefix of zen_?

It does indeed... Its always been that, the only thing thats changed is the password for the database.

[dbltoe]

assuming that you meant includes/configure.php and admin/includes/configure.php there is little else that is common to both the admin and catalog as far as database is the password, username, database prefix, and database name. Other than that, I can't think of anything that would make both the cart and the admin inaccessible. They are both not working, correct?

[SMIFFAD]

assuming that you meant includes/configure.php and admin/includes/configure.php there is little else that is common to both the admin and catalog as far as database is the password, username, database prefix, and database name. Other than that, I can't think of anything that would make both the cart and the admin inaccessible. They are both not working, correct?

Interesting question.... the admin side IS working....

Least thats a start some more investigation required.....

[SMIFFAD]

I just cannot see any reason for it not working....

Admin sections working and picking up data,

Ive installed another zen cart - that picks up its tables (how ever it wont read the original zen data)

Ive Restored a recent backup of the sql database, just incase it had corrupted, still nothing.