Zen Cart Logo
Forums / Upgrading to 1.5.x / Gateway Time-out error when importing database

Gateway Time-out error when importing database

Views: 1,963

Results 1 to 16 of 16
28 Oct 2015, 5:23 AM
#1
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Gateway Time-out error when importing database

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 https://www.gelcandlecompany.com/demo2

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

28 Oct 2015, 5:34 AM
#2
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

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.

28 Oct 2015, 6:03 AM
#3
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Gateway Time-out error when importing database

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

28 Oct 2015, 6:09 AM
#4
lruskauff avatar

lruskauff

Totally Zenned

Join Date:
Sep 2008
Location:
WA
Posts:
559
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

Hi
Never mind :).

28 Oct 2015, 12:43 PM
#5
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

kobra:

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!

28 Oct 2015, 5:58 PM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Gateway Time-out error when importing database

Check your demo2 /logs folder for my debug files

28 Oct 2015, 6:31 PM
#7
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

kobra:

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
28 Oct 2015, 10:52 PM
#9
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

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.

29 Oct 2015, 12:56 AM
#10
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Gateway Time-out error when importing database

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?

29 Oct 2015, 4:48 AM
#12
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

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

Prior to importing/uploading the old database to populate the store with YOUR product, did you drop the tables of the above default product?
-----Did I need to drop tables. Was I missing this step? I thought I was too just create a new database, import my 1.39h data into the new and then do a zcinstall upgrade?

When you "logged into the admin" where in this process of uploading/importing was it possible with this setup?
---------Not sure, it seems that the data is still stuck to the default shop. Is this cause I did not drop tables at some point?

thank you for your help.

29 Oct 2015, 3:46 PM
#15
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

Re: Gateway Time-out error when importing database

I did not drop tables of my default products.
How can I do that?

29 Oct 2015, 8:31 PM
#16
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Gateway Time-out error when importing database

spawnie69:

I did not drop tables of my default products.
How can I do that?

Self answered at this post.