Gateway Time-out error when importing database

[spawnie69]

Hi there I'm working on a 1.54 new demo site.

I was trying to import my 1.39h database to a newly named database file and received a 'Gateway Time-out error' on blue host.
I checked the database at My Sql Databases and it appears to be there as far as I can tell.
So I went ahead to perform my database upgrade using zc_install.

I then clicked on the 'Click here to go to the store' button and received the following message.

WARNING: An Error occurred, please refresh the page and try again.

my demo site is at www.gelcandlecompany.com/demo2

What can be wrong here?
I appreciate anyone's help.

[spawnie69]

I checked the configure.php file and login info to new database looks good. Strange cause I was able to login to the admin and for some reason it's displaying the default zen cart products from the wrong database, not the new one.

[kobra]

Post the configure.php contents here xxing out DB details
Please use the code # tag in the tool bar

[lruskauff]

Hi
Never mind :).

[spawnie69]

Post the configure.php contents here xxing out DB details
Please use the code # tag in the tool bar

<?php
/**
 * @package Configuration Settings circa 1.5.4
 * @copyright Copyright 2003-2014 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * File Built by zc_install on 2015-10-06 08:02:27
 */


/*************** 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.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  define('HTTP_SERVER', 'http://www.gelcandlecompany.com');
  define('HTTPS_SERVER', 'https://www.gelcandlecompany.com');

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

  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', '/xxxxx/xxxxxxx/public_html/demo2/');

  //the following path is a COMPLETE path to the /logs/ folder  eg: /var/www/vhost/accountname/public_html/store/logs ... and no trailing slash
  define('DIR_FS_LOGS', '/XXXXX/XXXXXX/public_html/demo2/logs');

  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_CHARSET', 'utf8');
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'XXXXXX');
  define('DB_SERVER_PASSWORD', 'XXXXXXX');
  define('DB_DATABASE', 'XXXXXXX');

  // 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', '/XXXXX/XXXXX/public_html/demo2/cache');

// EOF

Thanks kobra!

[kobra]

Check your demo2 /logs folder for my debug files

[spawnie69]

Check your demo2 /logs folder for my debug files

[28-Oct-2015 01:19:21 America/Denver] PHP Fatal error:  1146:Table 'XXXXX.template_configuration_group' doesn't exist :: SELECT * FROM template_configuration_group ==> (as called by) /xxxxx/xxxxx/public_html/demo2/includes/init_includes/init_template_config.php on line 10 <== in /xxxxx/xxxxx/public_html/demo2/includes/classes/db/mysql/query_factory.php on line 155

[spawnie69]

My issue led me to this:

https://www.zen-cart.com/content.php...n-doesnt-exist

[spawnie69]

I attempted 3 more times to import my zipped 1.39h database and I still get a Gatewateway error in my php admin. I talked to bluehost they said try sql. I will give that a try.

[mc12345678]

When installing the 154 version, did you include the ZC default product as part of the installation?

Prior to importing/uploading the old database to populate the store with *YOUR* product, did you drop the tables of the above default product?

When you "logged into the admin" where in this process of uploading/importing was it possible with this setup?