Cannot connect to to storefront from browser

[rubicontrek]

I am a newbie at this. I installed the latest version on my OSX server. All went pretty well. Today the server had to be restarted. The store both admin and customer side are now not working. I get the following:

0 DB_ERROR_NOT_CONNECTED
in:
[select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have looked at the server and MYSQL is operational. I can connect to the server. I looked at grants for root@localhost and GRANT ALL PRIVILEGES exists.

Why is my store not accessable?

[Ajeh]

1 make sure the right database is in the /includes/configure.php

2 make sure the right username and password is in the /includes/configure.php

3 make sure that when you made the database and username and password that you added the username to the database ...

[rubicontrek]

GOT it working again.
I needed to update configure.php in the includes/configure.php and in the admin/includes/configure.php

Thanks!!

[Ajeh]

Thanks for the update ... glad that you are back on track ...

[liture]

I had the same problem today, but both the configure files are ok I have checked them, the store works perfectly but I can not access the admin panel, any suggestions? and the other question is why did the values change in the configuration field?

[DrByte]

and the other question is why did the values change in the configuration field?

Can you please explain this further?

[liture]

Thank you for your reply. I still have the problem that the store is accessible but I get the error message 0 DB_ERROR_NOT_CONNECTED when I try to visit the admin panel, I have not done any change what so ever to the store, so it was just finding this suddenly one morning, so my question is first how to solve it? and the second comment was related to some answers that I read in this post that the values in the configure.php file should be reviewd, so I was wondering why would they have changed alone?

Hope that you can understand me now since I need urgent help

Now after touching the values in the /admin/include/configure.php I have a white page only and the values are:

define('HTTP_SERVER', 'http://www.mywebsite.com');
define('HTTPS_SERVER', 'https://www.mywebsite.com'); // eg, https://localhost
define('HTTP_CATALOG_SERVER', 'http://www.mywebsite.com');
define('HTTPS_CATALOG_SERVER', 'https://www.mywebsite.com');

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

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/');
define('DIR_WS_BLOCKS', DIR_WS_INCLUDES . 'blocks/');

// * 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/httpd/vhosts/mywebsite.com/httpdocs/shop/admin/');
define('DIR_FS_CATALOG', '/home/httpd/vhosts/mywebsite.com/httpdocs/shop/');

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_CATALOG_BLOCKS', DIR_FS_CATALOG . 'includes/blocks/');
define('DIR_FS_CATALOG_BOXES', DIR_FS_CATALOG . 'includes/boxes/');
define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');
define('DIR_FS_FILE_MANAGER_ROOT', '/home/httpd/vhosts/mywebsite.com/httpdocs/shop'); // path to starting directory of the file manager

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'txex_');
define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty
define('DB_SERVER_USERNAME', 'username');
define('DB_SERVER_PASSWORD', 'password');
define('DB_DATABASE', 'database');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

[DrByte]

You should have a bit more in the file:

define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/home/httpd/vhosts/mywebsite.com/httpdocs/shop/cache');

?> 

After fixing that, you might also try running the fix-cache-key utility in case something's gone awry in the database:
http://www.zen-cart.com/index.php?ma...products_id=82

[Vger]

Which version of Zen Cart is running on your site? I ask because that admin/includes/configure.php file is from one of the earlier versions and not 1.3 - which doesn't have this line:

define('DIR_FS_FILE_MANAGER_ROOT

Vger

[liture]

thank you for your time and reply.

I do have those lines I just did not copy them before, I downloaded the file you mentioned and placed it in the server and tryed to access it after following the instructions inside the code of the file, and I have a white page still, could you please help?

I use the 1.3 version