erc Posted August 2, 2006 Share Posted August 2, 2006 I have installed several CRE's before and 2 OSC and the installs have always gone very smooth. However on this install I keep getting the error below. "A test connection made to the database was NOT successful. The error message returned is: Table 'db172728948.configuration' doesn't exist Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company." I have 1 other OSC hosted with my host now and all is well with that one so I doubt that it is the hosts fault. Somethings that I have done are check to see if the config files are set to 777, FTP client is set to auto for uploading the pics and text files, I have also deleted a DB created another one but I still keep getting that error. If anyone can help please let me know. If you are more hands on I have $20 Paypal dollars if you think you can install it. ERC PS. I am trying to upload the OSC that I downloaded from MonsterTemplate with there osc templates. Link to comment Share on other sites More sharing options...
Guest Posted August 2, 2006 Share Posted August 2, 2006 Did you review the /catalog/includes/configure.php and /catalog/admin/includes/configure.php for the correct parameters? // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'username'); define('DB_SERVER_PASSWORD', 'passwd'); define('DB_DATABASE', 'databasename'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // set to 'mysql' Tim Link to comment Share on other sites More sharing options...
trybicki Posted August 2, 2006 Share Posted August 2, 2006 I have installed several CRE's before and 2 OSC and the installs have always gone very smooth. However on this install I keep getting the error below. "A test connection made to the database was NOT successful. The error message returned is: Table 'db172728948.configuration' doesn't exist Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company." I have 1 other OSC hosted with my host now and all is well with that one so I doubt that it is the hosts fault. Somethings that I have done are check to see if the config files are set to 777, FTP client is set to auto for uploading the pics and text files, I have also deleted a DB created another one but I still keep getting that error. If anyone can help please let me know. If you are more hands on I have $20 Paypal dollars if you think you can install it. ERC HEY ERC, i can't really help with the DB problem, but I have a problem with a template monster store too! the admin panel does not work it's just a blank white page... any idea? also, doesn't template monster provide any support ? PS. I am trying to upload the OSC that I downloaded from MonsterTemplate with there osc templates. Link to comment Share on other sites More sharing options...
erc Posted August 2, 2006 Author Share Posted August 2, 2006 Okay here is a cut of my config file, I know what goes in the username and password but I am unsure what they are wanting where the (???) are. Is the DB_SERVER supposed to be Hostame or IP-address of the database server? And is the DB_DATABASE supposed to be the name of the database or something else. It keeps filling it in as "cat" the name of the directory that I am installing this at. The name of the database is something else though. And what should be STORE SESSIONS be set to on a shared server? // define our database connection define('DB_SERVER', '???'); define('DB_SERVER_USERNAME', 'MY USERNAME'); define('DB_SERVER_PASSWORD', 'MY PASSWORD'); define('DB_DATABASE', '???'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); Thanks ERC Link to comment Share on other sites More sharing options...
♥Vger Posted August 2, 2006 Share Posted August 2, 2006 The db_server is usually 'localhost' or the ip address of localhost, which is '127.0.0.1', but it can also be an address unique to the hosting company. The database name is the name of the database you created before you started the install procedure. Vger Link to comment Share on other sites More sharing options...
erc Posted August 3, 2006 Author Share Posted August 3, 2006 The db_server is usually 'localhost' or the ip address of localhost, which is '127.0.0.1', but it can also be an address unique to the hosting company. The database name is the name of the database you created before you started the install procedure. Vger I cant remember excalty but I think that I have always used the database name that my host automaticly provides after I just fill in what description name I want. So if my config files are correct what would be the next step? ERC Link to comment Share on other sites More sharing options...
erc Posted August 3, 2006 Author Share Posted August 3, 2006 I just made sure that my config files had all the correct information and were set at 777. I am still getting the error. If I try to visit my www.osc it gives this error. 1146 - Table 'db172728948.configuration' doesn't exist select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Any more ideas? ERC Link to comment Share on other sites More sharing options...
♥Vger Posted August 3, 2006 Share Posted August 3, 2006 That error will mean that either the 'configuration' table does not exist in the database, in which case there are probably no tables in the database - or else that one or both of your configure.php files do not have the correct database name in them. Vger Link to comment Share on other sites More sharing options...
erc Posted August 3, 2006 Author Share Posted August 3, 2006 That error will mean that either the 'configuration' table does not exist in the database, in which case there are probably no tables in the database - or else that one or both of your configure.php files do not have the correct database name in them. Vger Okay I am here is my config information // define our database connection define('DB_SERVER', 'db453.perfora.net'); THAT IS THE HOSTNAME THAT THE CONTROL PANEL ISSUED define('DB_SERVER_USERNAME', 'USER NAME CONTROL PANEL ISSUED'); define('DB_SERVER_PASSWORD', 'PASSWORD CONTROL PANEL ISSUES'); define('DB_DATABASE', 'db172728948'); THAT IS THE DATABASE NAME THAT THE CONTROL PANEL ISSUED define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> I am almost forsure that the all of the info is correct. If it is correct and there are indeed no tables in the database how do I make that happen? ERC Link to comment Share on other sites More sharing options...
erc Posted August 3, 2006 Author Share Posted August 3, 2006 When I logged into phpmyadmin and looked at the database it did say that there were no tables. Database: db172728948 No tables found in database. ERC Link to comment Share on other sites More sharing options...
erc Posted August 3, 2006 Author Share Posted August 3, 2006 So how do I create these tables then if the installer is not doing it? ERC Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.