1046 - No Database Selected - can't solve it

[mit_500]

HI everyone,

my host provider thoughtfully swapped over my install, from server35... to server38... I now get this error when browsing to the catalog

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Easy I figure....I'll just change over these details in the config file (copied here). However, still no joy...any ideas?

 

thanks

 

mike

 

catalog/admin/includes/config.php

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright ? 2003 osCommerce

 

Released under the GNU General Public License

*/

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://server38.hostingbay.net/~cowla'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://server38.hostingbay.net/~cowla');

define('HTTPS_CATALOG_SERVER', 'https://server38.hostingbay.net/~cowla');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/cowla/public_html/shop/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/shop/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/cowla/public_html/shop/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/shop/'); // absolute path required

define('DIR_FS_CATALOG', '/home/cowla/public_html/shop/'); // absolute path required

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

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

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

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_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

 

// define our database connection

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

define('DB_SERVER_USERNAME', 'xxxxxxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxxx');

define('DB_DATABASE', 'xxxxxxxx');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[Guest]

There is a configure.php in the /includes/ directory also.

 

You should *never* post usernames and passwords to a public forum - I hav blanked them out, but you should now change them :-"

 

Matti

[mit_500]

thanks Matti..(and for pointing out name/pw blunder) -= oops.

 

anyway...that /includes/configure.php has null entires - i tried updating these to point to the server - but still no good. Is there anything else to try?:

 

define('HTTP_SERVER', 'server38.hostingbay.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'server38.hostingbay.net'); // eg, https://localhost - should not be empty for productive servers

[mit_500]

oops - that was

 

define('HTTP_SERVER', 'http://server38.hostingbay.net'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'http://server38.hostingbay.net'); // eg, https://localhost - should not be empty for productive servers

[Guest]

check for a configure.php in the /includes/local/ directory - if there is one in there it will override the one in /includes/

 

Matti