Cannot connect to database anymore

[travel124]

I am using version v1.3.8a. Earlier this week I edited the config file and since then I have not been able to connect to my database.

I had a backup of my mu config files, I uploaded those and my site would not work.

I have access to my Cpanel and know what my user and ID pass is and still cannot connect. I also updated my my dateabase but still cannot connect for some strange reason.

I have read and read the forums to try to figure out what is wrong. I tried a fresh install to connect with the same data base, it pulls some of my previouse store items but not my all of catagories. I am lost at this point.

I called my host yesterday and they said they could not help me.

Thanks for any help.

[stevesh]

I tried a fresh install to connect with the same data base, it pulls some of my previouse store items but not my all of catagories. I am lost at this point.

Does this mean that the fresh installation is connecting with the database? A link to your site might let us see something you're missing.

[travel124]

I am fine now and back up. I was able to connect to the newer database. I somehow lost all my info from all my old data base. What bugs me is my parent directory keeps showing in public view and I cant figure out why it is doing that and how to change it from showing.

Do I have my zen files where they are supposed to be?

public_html/shoppe

I renamed my zencart store to /shoppe and named my admin to my sons name and added numbers for security.

Thanks!

:)

[stevesh]

If you mean that when someone goes to the root of your site, they see Index of ..., that means there's no index file in the root directory. I'm not sure why you moved your store to a subdirectory, but if that's where you want it, you'll need to create an index.html page for the root. Maybe an image of some sort that links to /shoppe.

[travel124]

Ok, so all i need to do is bump all my files just below the public_html folder.

I will then have to edit the config files. That is how I lost my first data base files.

[kdb04d]

are u sure ur config files weren't just unable to overide because u didnt change the permissions its happened to me before

[travel124]

I don't remember what I did now. I just bumped up the files and edited the config files and f'd up the site again...lol

[travel124]

ok i posted the includes config file. I am getting a 500 page error. I added >>>>>> is this correct???? where i edited in the config file.

I can login to the admin side fine.

Thanks again for your help. :)


<?php
/**
* @package Configuration Settings circa 1.3.8
* @copyright Copyright 2003-2007 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
*/


/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/
/*************** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
define('HTTP_SERVER', 'http://www.mysite.com'); >>>>>> is this correct????
define('HTTPS_SERVER', 'https://www.mysite.com'); >>>>>> is this correct????

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/public_html/'); >>>>>> is this correct????
define('DIR_WS_HTTPS_CATALOG', '/public_html/'); >>>>>> is this correct????

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
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', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/
define('DIR_FS_CATALOG', '/home/######/public_html/'); >>>>>> is this correct????

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '#####');
define('DB_SERVER_PASSWORD', '####');
define('DB_DATABASE', '######');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'database');
define('DIR_FS_SQL_CACHE', '/home/######/public_html/cache'); >>>>>> is this correct????

// EOF

[stevesh]

Everything looks right except:

define('DIR_WS_CATALOG', '/public_html/'); >>>>>> is this correct????
define('DIR_WS_HTTPS_CATALOG', '/public_html/'); >>>>>> is this correct????

shiould be

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

[travel124]

ok I have changed those and I am still getting the same error. tx

http://www.lorigiles.com/