Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Join Date
    Mar 2008
    Posts
    2
    Plugin Contributions
    0

    application error There seems to be a problem connecting to our database

    [FONT="Arial Black"]I have had alot of issues with my website, now when i try to go to the store i get the error.
    Sorry!
    There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.

    Now i have read the forums and there may be a problem with my configure files. So i have pasted both files here. Can somebody please tell me if they see any issues with either one.[/FONT]

    [FONT="Arial Black"]admin/includes/configure.php[/FONT]

    // 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://leather2flesh.com.au');
    define('HTTPS_SERVER', 'https://leather2flesh.com.au');
    define('HTTP_CATALOG_SERVER', 'http://leather2flesh.com.au');
    define('HTTPS_CATALOG_SERVER', 'https://leather2flesh.com.au');

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

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

    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', 'zen_');
    define('DB_SERVER', 'localhost');
    define('DB_SERVER_USERNAME', 'mistress_zc1');
    define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');
    define('DB_DATABASE', 'mistress_zc1');
    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/mistress/public_html/store/cache');


    [FONT="Arial Black"]includes/configure.php[/FONT]


    // 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://leather2flesh.com.au');
    define('HTTPS_SERVER', 'https://leather2flesh.com.au');

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

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

    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', 'mistress_zc1');
    define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');
    define('DB_DATABASE', 'mistress_zc1');
    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/mistress/public_html/store/cache');

    [FONT="Arial Black"]Also when i try to log into my store admin i get the following error. Can someone please help me and save me. [/FONT]

    0 DB_ERROR_NOT_CONNECTED
    in:
    [db_cache table]
    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.

  2. #2
    Join Date
    Nov 2007
    Location
    Auckland, New Zealand
    Posts
    61
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    are you sure your password is correct.
    It is probably because you have not added yourself as a user to your database. Go to cPanel, then MySQL Database, and there should be a section which says "Add Users" where you can select your user name from a drop down list and then your databse from a dropdown list. Once you have assigned your username to your databse it should work. If it still does not work then try using a simpler password. Im not sure but the brackets and slashs could be confusing it. tell me if you succed.

  3. #3
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: There seems to be a problem connecting to our database

    Not sure if this is a new problem or if you've had it since day one.

    First, I would change your db password:
    define('DB_SERVER_PASSWORD', 'nRW71{2E19w{\[');

    Get rid of the special characters for now.

    If you still get the error msg. "There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem.", then contact your Hoster. Problem could be on their end.

  4. #4
    Join Date
    Apr 2008
    Posts
    2
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    Hi, Did you problem get resolved? I'm having the same problem, I cannot even access my www.domain.com/admin panel! Did you get yours fixed and if so, how?

  5. #5
    Join Date
    Jan 2008
    Posts
    13
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    I am getting this same message:

    Sorry!
    There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you.


    Help!!

  6. #6
    Join Date
    Feb 2008
    Posts
    37
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    Help!!
    My site has been up and running for months and has been fine, and then this morning the site is down with the message there seems to be a problem connecting to our database, and when I do to my admin I get the answer '0 DB_ERROR_NOT_CONNECTED
    in:
    [db_cache table]
    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.

    Help, help, what can I do to fix this!

  7. #7
    Join Date
    Sep 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    Yea, I need to second (third) this! I've been getting this on and off for a few weeks. I check the forums each time... I've triple checked my configure.php. My hosting provider is MediaTemple and I'm running an SQL container. Media temple is very reliable and since I'm seeing this same thing through out the forum it seems like it could easily be a ZEN cart thing.

    Today its only the ADMIN. And actually as I finish this post, it is now working. It only goes down for a bout 5 minutes at a time. We're not live yet, but it sure is tough when trying to show the client, but I get the following when working with the ADMIN:

    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.

  8. #8
    Join Date
    Sep 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    OH... and this might be helpful: I'm using SSL and sometimes when I add the 's' to the http://...etc... the site comes back. But this is not always the case. Also, I thought when SSL is enabled the site runs exclusively on https// - for example the home logo points to http even thought I may be on an https page.

    ???

  9. #9
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: There seems to be a problem connecting to our database

    SSL links are used when needed, not all the time. And the database problems are probably Hoster related. After all, if your site is working fine and you don't change anything but then start having problems database connecting, it only makes sense the problem is on the Hosting end.

  10. #10
    Join Date
    Sep 2008
    Posts
    8
    Plugin Contributions
    0

    Default Re: There seems to be a problem connecting to our database

    Thanks for the reply. I've got a support ticket out to my provider... I'll keep the thread up to date on what I find.

    Thing is... I keep seeing this problem pop up. The intermittent thing, I mean. What do you think could be the issue on the hosting end?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v150 There seems to be a problem connecting to our database
    By rainbow_pixie_star in forum General Questions
    Replies: 33
    Last Post: 4 Mar 2016, 07:38 PM
  2. There seems to be a problem connecting to our database.
    By janelle in forum General Questions
    Replies: 1
    Last Post: 12 Sep 2012, 09:05 AM
  3. There seems to be a problem connecting to our database
    By carjamz in forum General Questions
    Replies: 2
    Last Post: 28 Feb 2009, 11:30 PM
  4. There seems to be a problem connecting to our database.
    By jenny_lisa1 in forum Basic Configuration
    Replies: 5
    Last Post: 14 Feb 2009, 02:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR