Admin error Message

[taffy056]

Hi,

 

I have moved my installation of oscommerce to a different server, I have changed all the settings ineed in the file configure to suit the new server, but I keep gettting the error below, is there somewhere actually in the database itself that I need to change, because it keeps on asking for the old host location

 

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'db.oneandone.co.uk' (1) in /home/sites/domain.org.uk/public_html/shop/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

Many Thanks,

 

Craig

[Guest]

Did you change it in both the includes/configure.php and admin/includes/configure.php files? There is nowhere in the database itself where it refers to db connection info like it does in those files.

 

-jared

[taffy056]

Hi,

 

Thanks for the reply, they have both been edited for the new database, the setting reads as follows for both files:

 

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

 

Regards,

 

Craig

[Guest]

Silly question, but have you updated all of the following settings?:

 

  define('DB_SERVER', 'serverblah'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'usernameblah');
 define('DB_SERVER_PASSWORD', 'passwordblah');
 define('DB_DATABASE', 'databaseblah');

[taffy056]

Hi,

 

Yes all settings have been changed.

 

Thanks

 

Craig

[Guest]

If 'db.oneandone.co.uk' is being referred to and you can't see it anywhere in the configure.php files then one can only assume it's a caching issue of some kind. :/

[taffy056]

Hello,

 

What do you mean its caching issue, I don't really know what to do if it is, the shop is on a completely different server now, and all the database settings in configure.php has been changed to reflect that. I had a similar problem when changing subdreamer portal on a different website over, the problem there was that the old database setting was still in the database files somewhere, it was fixed by changing this to the current database. So perhaps its a similar problem with oscommerce?

 

Craig

[Guest]

Some web hosting companies use another configure.php file in the auto-setup scripts. It's in the catalog/includes/local directory. There may be another in admin/includes/local. Check there.

 

-jared