Database Error...!

[host.co.in]

I have transferred one account from one old server to a new server and now I am getting Database Error when i check oscommerce section of site of the customer. Tell me all 3 possible solutions to troubleshoot this problem and make his oscommerce work as it was working on old server.

[rubel]

In this case all the database related issues have to be checked.

1. Temp partition should not be full.

2. The files where the error is getting have to be checked for ownership(mysql.mysql) and permission(700).

3. Should be used mysql_connect() instead of mysql_pconnect().

4. The file which set Mysql connections has to be checked for dbuser, dbpass, dbname etc.

5. If accessing database remotely then add % sign in cpanel>>mysql>>access hosts.

6. Restarting mysql service.

[Jayesh_M]

Also check following..

1. In the configuration.php or whatever config file in the home directory or wherever it is located change the absolute path for the oscommerce directory.
change the absolute_path field given is correct location or not as the username if changed then the path will also be changed.
2. Assign the user to database. from cpanel >> Mysql database >> Add user to database.
3. Try deleting the priviledges and the user ( if you know the password of that user then only from the configfile). Recreate the uer and assign epriviledges to the user.
3 Other solution will depend on the type of error that you are getting.

All te best..
Jayesh Mahajan.

---------------------------------------------------------------
Never Never Never NEVER GIVE UP. ..
---------------------------------------------------------------