Cannot get the site to connect to database

I am able to access my admin section, but I cannot get the store to show up. Instead I get the following message:

http://www.books-japan-online.com/index.php?main_page=

If anyone can help, I would be in their debt.

Anyone? Anyone? Bueller?

Check and make sure that you have the database name, username and password correct in your files:
/includes/configure.php

Compare this to the file:
/admin/includes/configure.php

It appears that the Admin may work and the installer but not your Catalog ...

Yeah they match up, my problem is that I need this database, I word if their is a work around.

Can you get into your Admin?

ctcentralinfo:

Yeah they match upPlease post the contents of both files, removing ONLY the passwords.

admin_includes_configure.php

// Define the webserver and path parameters
// Main webserver: eg, http://localhost - should not be empty for productive servers
// HTTP_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_SERVER is your Secure webserver: eg, https://www.yourdomain.com
// HTTP_CATALOG_SERVER is your Main webserver: eg, http://www.yourdomain.com
// HTTPS_CATALOG_SERVER is your Secure webserver: eg, https://www.yourdomain.com
/*

• URLs for your site will be built via:

• HTTP_SERVER plus DIR_WS_ADMIN or
  

• HTTPS_SERVER plus DIR_WS_HTTPS_ADMIN or 
  

• HTTP_SERVER plus DIR_WS_CATALOG or 
  

• HTTPS_SERVER plus DIR_WS_HTTPS_CATALOG
  

• ...depending on your system configuration settings
  */
  define('HTTP_SERVER', 'http://www.books-japan-online.com');
  define('HTTPS_SERVER', 'https://www.books-japan-online.com');
  define('HTTP_CATALOG_SERVER', 'http://www.books-japan-online.com');
  define('HTTPS_CATALOG_SERVER', 'https://www.books-japan-online.com');

// Use secure webserver for catalog module and/or admin areas?
define('ENABLE_SSL_CATALOG', 'false');
define('ENABLE_SSL_ADMIN', 'false');

// 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_ADMIN', '/admin/');
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_ADMIN', '/admin/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
define('DIR_WS_CATALOG_IMAGES', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'images/');
define('DIR_WS_CATALOG_TEMPLATE', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/templates/');
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', HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'includes/languages/');

// * 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/store/
define('DIR_FS_ADMIN', '/home/wwwcool/public_html/books/admin/');
define('DIR_FS_CATALOG', '/home/wwwcool/public_html/books/');

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_CATALOG_TEMPLATES', DIR_FS_CATALOG . 'includes/templates/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'wwwcool_flonase');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'wwwcool_zencart');
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', 'none');
define('DIR_FS_SQL_CACHE', '/home/wwwcool/public_html/books/cache');

?>

includes_configure.php

// 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.books-japan-online.com');
define('HTTPS_SERVER', 'https://www.books-japan-online.com');

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

// 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', '/');
define('DIR_WS_HTTPS_CATALOG', '/');

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', '/home/wwwcool/public_html/books/forum/');

// * 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/store/
define('DIR_FS_CATALOG', '/home/wwwcool/public_html/books/');

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', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'wwwcool_flonase');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'wwwcool_zencart');
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', 'none');
define('DIR_FS_SQL_CACHE', '/home/wwwcool/public_html/books/cache');

?>

Looks like you also have a problem with your phpBB setup:
http://www.books-japan-online.com/forum/

Please make your /public_html/books/includes/configure.php file "writable" (777).
Then re-upload the file
Then test.

Is your "books-japan-online.com" domain somehow pointed specifically as a subdomain to the /books folder?
Is there another URL by which one can access the "books" folder on your site?

DrByte:

Please make your /public_html/books/includes/configure.php file "writable" (777).
Then re-upload the file
Then test.

Is your "books-japan-online.com" domain somehow pointed specifically as a subdomain to the /books folder?
Is there another URL by which one can access the "books" folder on your site?

You can only access books japan online through /books.

When I created a new database all together the shopping cart worked without a hitch.

I think it might be an issue with the database.

ctcentralinfo:

I think it might be an issue with the database.

I had something similar after moving from local server to a remote one.

Check out your phpbb install, and all configuration regarding it on zen configure and in SQL.

So is their anyway I can fix the database for the catalog section of my website without losing my data?

Somehow I suspect your catalog section is not using the configure.php information that you posted.

DrByte:

Somehow I suspect your catalog section is not using the configure.php information that you posted.

Yeah because if I install it by scratch it works perfectly. Is their something I can remove or add to get the database working?

ctcentralinfo:

Yeah because if I install it by scratch it works perfectly. Is their something I can remove or add to get the database working?

Perhaps a line-by-line comparison between the working and non-working versions of your configure.php files.

Also remember: If your configure.php file on your server is read-only, then any updates you attempt to upload will fail, making things stop working.

DrByte:

Perhaps a line-by-line comparison between the working and non-working versions of your configure.php files.

Also remember: If your configure.php file on your server is read-only, then any updates you attempt to upload will fail, making things stop working.

It's a problem with the database. I realized this when I created a new database using a fresh install. I am really pissed, but at this point unless someone has a solution, their is nothing I can do about it.

Perhaps doing a table-by-table merge will help you ?

I still think it's bad configure.php information, perhaps pointing to invalid table prefixes or something.

I have everything working sort of, I remember having issues with the database when I uploaded a mod from way back so what I did was removed the configure table and replaced with a new one to test it out. and it seemed to do the trick. I still
have a gap in the banner and the category for some reason showing up twice in the header. I will have to upload the rest of the configure files and just be careful not to upload the mod again.