Disaster

[rmyles]

I had somewhat of a disaster tonight and I had to reinstall. I've done a pretty good job of getting things up and running again but now when I try to use the config tool I get this message:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

Can someone help me with this, I'd really like to go to bed sometime tonight...

 

Thanks

[rseigel]

You need to set the database values in /admin/includes/configure.php

[rmyles]

Thanks for responding, I changed the values you recommended but I still got the error. Could someone take a look at my config file and tell me if I missed something?

 

Thanks

 

<?php

/*

$Id: configure.php,v 1.13 2002/07/20 09:08:31 project3000 Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

define('HTTP_SERVER', 'http://www.talespinners.ca'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

define('HTTP_CATALOG_SERVER', '/catalog/');

define('HTTPS_CATALOG_SERVER', '');

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

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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');

define('DB_SERVER_USERNAME', '');

define('DB_SERVER_PASSWORD', '');

define('DB_DATABASE', '');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

[Guest]

// define our database connection

define('DB_SERVER', 'localhost'); <-- fill in the address to mysql server

define('DB_SERVER_USERNAME', 'CHANGEME'); <-- username on mysql

define('DB_SERVER_PASSWORD', 'CHANGEME'); <-- password on mysql

define('DB_DATABASE', 'CHANGEME'); <-- the name of the databas

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

 

change that and try again

[rmyles]

I did try updating those fields but it didn't seem to do anything. When I posted the file I removed them for obvious reasons. :D

 

Does the rest of the file look ok?

 

I've reinstalled a couple of times but when I reach the step at the end where I choose the catalog or admin tool, I choose admin tool and get this message. The catalog works fine

[Guest]

rmyles - check to make sure the admin username & password for your MySQL installation (server side) are the same as what you are defining in your admin/configure.php .

 

Also check the priviledges for the MySQL admin, could they have changed?

 

-innovous