Problems after switching server -1046

[wildstock]

I'm getting the follwing error after moving the store to new server. All changes were made on both config.php files. Anything else that can be causing such problem? Thanks.

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[Jack_mcs]

The database has to be created and populated on the new server. Was that done?

 

Jack

[wildstock]

The database has to be created and populated on the new server. Was that done?

 

Jack

Yes, the old database was imported into the new server, since both servers were using MySQL 5.0, the only thing that changed was the name of the database, which was updated on both configure.php. All paths to the folders were updated accordingly. Any ideas?

 

I've thinking on just re-installing from scratch then upload the old database data and tables to the working database file.

 

Thank you so much.

 

Ray

[♥geoffreywalton]

Apart from the database name there is the slight matter of the server name. Did you change that?

[wildstock]

Apart from the database name there is the slight matter of the server name. Did you change that?

 

Thanks Geoffrey

 

I have used localhost as the server name on previous server. Do you think I need to hard code the server name? Here's my configure.php I really appreciate if you could take a look. I replaced the login and pass with XXX for safety. Thanks.

 

<?php

define('HTTP_SERVER', 'http://munguiaphotography.com');

define('HTTPS_SERVER', 'https://munguiaphotography.com');

define('ENABLE_SSL', false);

define('HTTP_COOKIE_DOMAIN', 'munguiaphotography.com');

define('HTTPS_COOKIE_DOMAIN', 'munguiaphotography.com');

define('HTTP_COOKIE_PATH', '/store/');

define('HTTPS_COOKIE_PATH', '/store/');

define('DIR_WS_HTTP_CATALOG', '/store/');

define('DIR_WS_HTTPS_CATALOG', '/store/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/www/www/store/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

define('DB_SERVER', 'localhost');

define('DB_SERVER_USERNAME', 'xxxxx');

define('DB_SERVER_PASSWORD', 'xxxxx');

define('DB_DATABASE', 'munguiap_store');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

?>

[Jack_mcs]

As Geoffrey mentioned, the server name could be the problem. Localhost isn't used by all hosts so you need to find out for sure what that should be. The rest of the file looks fine.

 

Jack