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

Gateway Time-out error when importing database

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

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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 www.gelcandlecompany.com/demo2

What can be wrong here?
I appreciate anyone's help.
28 Oct 2015, 05:34
#2
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 06:03
#3
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
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, 06:09
#4
lruskauff avatar

lruskauff

Totally Zenned

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

Re: Gateway Time-out error when importing database

Hi
Never mind :).
28 Oct 2015, 12:43
#5
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 17:58
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
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, 18:31
#7
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 22:52
#9
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 00:56
#10
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

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, 04:48
#12
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 15:46
#15
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Posts:
524
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, 20:31
#16
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

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.