mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Thank you, in my happiness i got carried away. Post edited :) So if i haven't frustrated you guys enough... may i ask why the page would be broken? Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 https://www.griffinrad.com/checkout_shipping.php I'm not sure whats going on there. If you have a catalog directory then you should have a URL like this. https://www.griffinrad.com/catalog/checkout_shipping.php It looks like you have 2 installations going on, on your domain. Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 First of all let's deal the config files. You only want one. The one in catalog/includes directory. The one in catalog/includes/local directory is for your testing local server. Back it up first and then remove it. Your shop is in the /catalog/ directory. So catalog/includes/configure.php should be define('HTTP_SERVER', 'http://www.griffinrad.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://www.griffinrad.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTPS_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', '/catalog/'); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', '/catalog/'); Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 First of all let's deal the config files. You only want one. The one in catalog/includes directory. The one in catalog/includes/local directory is for your testing local server. Back it up first and then remove it. Your shop is in the /catalog/ directory. So catalog/includes/configure.php should be define('HTTP_SERVER', 'http://www.griffinrad.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://www.griffinrad.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTPS_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', '/catalog/'); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', '/catalog/'); Done, i have deleted the conifgure.php located in includes/local/ now i get this error when loading the catalog: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in D:\hshome\aaron\griffinrad.com\catalog\includes\functions\database.php on line 19 Unable to connect to database server! Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Done, i have deleted the conifgure.php located in includes/local/ now i get this error when loading the catalog: Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in D:\hshome\aaron\griffinrad.com\catalog\includes\functions\database.php on line 19 Unable to connect to database server! my new config: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 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://www.griffinrad.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://www.griffinrad.com'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTPS_COOKIE_DOMAIN', 'www.griffinrad.com'); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', '/catalog/'); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', '/catalog/'); 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', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'mysql.myhosting.com'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'username'); define('DB_SERVER_PASSWORD', 'password'); define('DB_DATABASE', 'databaseName '); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' ?> After updating my database location i get a new error: 1046 - No database selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 Make sure this part is filled in with your info. // define our database connection define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', ''); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' On post #19 of this thread you entered you db info. Contact a moderator and ask them to edit that info out for you. Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Make sure this part is filled in with your info. // define our database connection define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', ''); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' On post #19 of this thread you entered you db info. Contact a moderator and ask them to edit that info out for you. Thank you, i will ask a moderator. I have updated the database information with the same information that was working in the includes/local/configure.php, which has been deleted from the server. I made sure i could login using myPHPAdmin and successfully conected to the database and confirmed the name. Is there anything else that can cause that error, or is there somewhere else i was supposed to set up that information that i may have missed? Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 After updating my database location i get a new error: 1046 - No database selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration [TEP STOP] This error is a result of your database configuration not being setup in your catalog/includes/configure.php Or setup incorrectly. Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 Your site is working. The ssl is working. Only one problem. What are the below set to? define('HTTP_COOKIE_PATH', ''); define('HTTPS_COOKIE_PATH', ''); Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 Did you install a osc version with your host cpanel script installer? I'm wondering if you have 2 oscommerce databases? Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Your site is working. The ssl is working. Only one problem. What are the below set to? define('HTTP_COOKIE_PATH', ''); define('HTTPS_COOKIE_PATH', ''); both are set to /catalog/ >_< Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 both are set to /catalog/ >_< I wish the had the guy pulling his hair out LOL Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Did you install a osc version with your host cpanel script installer? I'm wondering if you have 2 oscommerce databases? Yes i did. then i had the hosting company weeks ago come back behind me and delete the orgional install so that i could have a fresh one. Let me go check the OSC in my control pannel Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Yes i did. then i had the hosting company weeks ago come back behind me and delete the orgional install so that i could have a fresh one. Let me go check the OSC in my control pannel I have three... two are set to off, one is running on my domain. I will have them delete the other two Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 Did you just change this define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' Leave that set to mysql Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Did you just change this define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' Leave that set to mysql yes :( i will change it back Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 Looks like you got it now. Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 WOOOOOOOOOO HOOOOOOOOOOOOOOOOO!!!!! Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 You will notice one other problem. You have a red slash through your padalock in firefox. I think that is due to your comodo image on the right side. Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 OK i can't thank you two enough. Just dealing with me is frustrating (thats what my wife says) but helping me fix this, WOW, you two are AWESOME. Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 You will notice one other problem. You have a red slash through your padalock in firefox. I think that is due to your comodo image on the right side. Think that is the footer image, only one showing up as a none-https link. http://griffinrad.com/catalog/images/banners/oscommerce.gif Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Yes Sir! That was it! Link to comment Share on other sites More sharing options...
mossman Posted May 10, 2011 Author Share Posted May 10, 2011 Happy Day In Radiator Land :D Sad i know :thumbsup: Link to comment Share on other sites More sharing options...
NodsDorf Posted May 10, 2011 Share Posted May 10, 2011 I have a 1994 Chevy Blazer radiator that leaking like a stuck pig. Where should I send it? :) Glad you got it sorted out. Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2011 Share Posted May 10, 2011 Think that is the footer image, only one showing up as a none-https link. http://griffinrad.com/catalog/images/banners/oscommerce.gif Good catch. I assumed it was the other one since I see that one being the problem a lot. Guess we know why they say assumptions are the mother of all #!@$ ups/ :D Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.