Punkey Posted September 18, 2005 Posted September 18, 2005 Hello all, I am having a disappearing problem!!! I would greatly appreciate if anybody can help me with this. My site is gone and this is the message I'm getting. :'( 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] My host says that he installed the back up and still the site is HIDING!! OH Boy!!! Not again!!!!!!!!!!!!!!!!!!!!!!
Wendy James Posted September 18, 2005 Posted September 18, 2005 I am just guessing but it sounds like your configure.php file(s) do not have your database information. I would take a look at them and make sure they are ok. Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Punkey Posted September 18, 2005 Author Posted September 18, 2005 I am just guessing but it sounds like your configure.php file(s) do not have your database information. I would take a look at them and make sure they are ok. <{POST_SNAPBACK}> Hi, I'm looking at it in MYSQL and http://mysite.net:2082/3rdparty/phpMyAdmin/index.php What am I looking for in "configuration" or should i look somewhere els? T. I. A. OH Boy!!! Not again!!!!!!!!!!!!!!!!!!!!!!
bobg7 Posted September 18, 2005 Posted September 18, 2005 you should be looking at your catalog/includes/configure.php It's a file that needs to be viewed from your hosts file manager or from your desktop. At the bottom of the file you should see something like this: // define our database connection define('DB_SERVER', 'YOUR_DATABASE_SERVER_COM'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'YOUR_DATABASE_USERNAME'); define('DB_SERVER_PASSWORD', 'YOUR_DATABASE_PASSWORD'); define('DB_DATABASE', 'YOUR_DATABASE_NAME'); define('USE_PCONNECT', 'true'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> Also check admin/includes/configure.php Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going.
♥Vger Posted September 18, 2005 Posted September 18, 2005 define('USE_PCONNECT', 'false'); Otherwise you'll greatly cut down on the number of people who can be online at your website at the same time. Vger
Punkey Posted September 18, 2005 Author Posted September 18, 2005 define('USE_PCONNECT', 'false'); Otherwise you'll greatly cut down on the number of people who can be online at your website at the same time. Vger <{POST_SNAPBACK}> Hi again, This is what I see: // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'xxxxxxx_admin'); define('DB_SERVER_PASSWORD', 'xxxxxxxx'); define('DB_DATABASE', 'xxxxxxxx_shop'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> Should I change anything? Thanks <_< OH Boy!!! Not again!!!!!!!!!!!!!!!!!!!!!!
♥Vger Posted September 18, 2005 Posted September 18, 2005 With that error message there are two possibilities: 1. The name of the database is different to what you have put down for it in the configure.php files 2. The database has gone, is dead, is no more, has turned up its toes, shuffled off its mortal coil etc., (acknowledgement to Monty Python) To check if it's number two you need to connect to your phpMyAdmin and see if the database is still there. If it is there, check the name of it against what you have in the configure.php files. Vger
Guest Posted September 20, 2005 Posted September 20, 2005 define('DB_SERVER_USERNAME', 'xxxxxxx_admin'); define('DB_SERVER_PASSWORD', 'xxxxxxxx'); define('DB_DATABASE', 'xxxxxxxx_shop'); That's fine if your user name is xxxxxxx_admin Your password to the database is xxxxxxxx You have a database named xxxxxxxx_shop And you have installed the tables to xxxxxxxx_shop :-"
♥Vger Posted September 20, 2005 Posted September 20, 2005 Must have been sorted, that's over a day old now. Vger
Punkey Posted September 20, 2005 Author Posted September 20, 2005 Must have been sorted, that's over a day old now. Vger <{POST_SNAPBACK}> Hi, I have not been able to fix the problem. I have very bad host the mess up things and can not fix it after. There are lots of data in the MYSQL but I don't know which is which. Only if I could get the last version of the site back, I would move it to some other host. Unless you guys have some other suggestion :huh: :( OH Boy!!! Not again!!!!!!!!!!!!!!!!!!!!!!
Guest Posted September 20, 2005 Posted September 20, 2005 This error means that the database name is incorrect in your configuration file. Matti
Recommended Posts
Archived
This topic is now archived and is closed to further replies.