Stumped: Store Completely Broken after Hard Drive Replacement on server

[ts232]

Help me ZC Community, you’re my only hope. I have spent months (on and off) trying to get my stable 1.5.4 store back up and running after my hosting company had to do an emergency hard drive replacement (I am not 100% sure that the problem occurred at the exact same time as the replacement). Now I cannot log into either the store or admin page. The store page redirects to the first time installation page, and the admin page gives a 500 error. The problem is NOT the paths in the configure files. I have triple checked them via ssh terminal and also verified with my hosting company (Dreamhost dedicated server) that the paths are correct. The SQL database still looks fine, and I am able to log into it fine with the php Sql Admin tools using the password and account that are in the configure file. There have been NO changes to any files for over a year before the system broke. Running PHP 5.6.

There are no errors in the browser javascript console. When I turn on the php debugging facility I see this entry occurs when I try to access the store front:

[03-Jan-2019 06:03:33 America/Los_Angeles] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/hbzenftp/hardbrakes.com/includes/templates/template_default/templates/tpl_zc_install_suggested_default.php:39) in /home/hbzenftp/hardbrakes.com/includes/application_top.php on line 152
myDEBUG-1546524213-952991.log (END)

The PHP error below occurs when I try to access the admin:

[27-Jan-2019 06:57:49 America/Los_Angeles] PHP Warning:  require(/home/hbzenftp/hardbrakes.com/includes/classes/db/mysql/query_factory.php): failed to open stream: No such file or directory in /home/hbzenftp/hardbrakes.com/hbadmin/includes/init_includes/init_database.php on line 17
[27-Jan-2019 06:57:49 America/Los_Angeles] PHP Fatal error:  require(): Failed opening required '/home/hbzenftp/hardbrakes.com/includes/classes/db/mysql/query_factory.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/hbzenftp/hardbrakes.com/hbadmin/includes/init_includes/init_database.php on line 17

I am including my configure files below. I tried turning off the cache method but it made no difference. Any ideas? I am stumped.

Thanks! -Alan

————————————————————————————
/includes/configure.php

<?php
/**
 * @package Configuration Settings circa 1.3.9
 * @copyright Copyright 2003-2010 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 2011-05-03 07:38:14
 */


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

  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/hbzenftp/hardbrakes.com/');

  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', 'mysql.hardbrakes.com');
  define('DB_SERVER_USERNAME', ‘————————————— ‘);
  define('DB_SERVER_PASSWORD', ‘——————————‘);
  define('DB_DATABASE', 'hardbrakes_com');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');
  // for STORE_SESSIONS, 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', ‘none’); 
  define('DIR_FS_SQL_CACHE', '/home/hbzenftp/hardbrakes.com/cache');

// EOF

——————————————————————————
/admin/includes/configure.php

<?php
/**
 * @package Configuration Settings circa 1.3.9
 * @copyright Copyright 2003-2010 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 2011-05-03 07:38:14
 */


/*************** NOTE: This file is similar, but DIFFERENT from the "store" version of configure.php. ***********/
/***************       The 2 files should be kept separate and not used to overwrite each other.      ***********/

// Define the webserver and path parameters
  // Main webserver: eg-http://www.your_domain.com - 
  // HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
  // HTTP_CATALOG_SERVER is your Main webserver: eg-http://www.your_domain.com
  // HTTPS_CATALOG_SERVER is your Secure webserver: eg-https://www.your_domain.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
   *
   * If you desire your *entire* admin to be SSL-protected, make sure you use a "https:" URL for all 4 of the following:
   */
  define('HTTP_SERVER', 'https://HardBrakes.com');
  define('HTTPS_SERVER', 'https://HardBrakes.com');
  define('HTTP_CATALOG_SERVER', 'https://HardBrakes.com');
  define('HTTPS_CATALOG_SERVER', 'https://HardBrakes.com');
//  define('HTTP_SERVER', 'http://www.hardbrakes.com');
//  define('HTTPS_SERVER', 'https://www.hardbrakes.com');
//  define('HTTP_CATALOG_SERVER', 'http://www.hardbrakes.com');
//  define('HTTPS_CATALOG_SERVER', 'https://www.hardbrakes.com');

  // Use secure webserver for catalog module and/or admin areas?
  define('ENABLE_SSL_CATALOG', 'true');
  define('ENABLE_SSL_ADMIN', '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_ADMIN', '/hbadmin/');
  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_ADMIN', '/hbadmin/');
  define('DIR_WS_HTTPS_CATALOG', '/');

  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/hbzenftp/hardbrakes.com/hbadmin/');
  define('DIR_FS_CATALOG', '/home/hbzenftp/hardbrakes.com/');

  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', 'mysql.hardbrakes.com');
  define('DB_SERVER_USERNAME', ‘————————————‘);
  define('DB_SERVER_PASSWORD', ‘———————————‘);
  define('DB_DATABASE', 'hardbrakes_com');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'db');
  // for STORE_SESSIONS, 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/hbzenftp/hardbrakes.com/cache');

// EOF

[mc12345678]

So a couple of things...
The configure.php files for both store and admin do not match the format expected for ZC 1.5.1 and above...

Also, the error message when accessing the site goes on to describe:

Additional *IMPORTANT* Details: includes/configure.php file empty or file not found, OR wrong DB_TYPE set, OR cannot find includes/autoload_func.php which suggests paths are wrong or files were not uploaded correctly

And the error messages (while the first about the catalog is perhaps a little misleading, but is addressed by this FAQ:https://www.zen-cart.com/content.php...s-already-sent

The second well, it clearly indicates that a file can not be found: /home/hbzenftp/hardbrakes.com/includes/classes/db/mysql/query_factory.php

Is it because the path data is wrong? Or has the file been removed? Both the store front and the admin have to use that file to perform database access... a failure to access the database would/could cause the problems seen.

The question becomes why can the database not be accessed?

[ts232]

So a couple of things...
The configure.php files for both store and admin do not match the format expected for ZC 1.5.1 and above...

...

The second well, it clearly indicates that a file can not be found: /home/hbzenftp/hardbrakes.com/includes/classes/db/mysql/query_factory.php

Is it because the path data is wrong? Or has the file been removed? Both the store front and the admin have to use that file to perform database access... a failure to access the database would/could cause the problems seen.

The question becomes why can the database not be accessed?

My /home/hbzenftp/hardbrakes.com/includes/classes/db is empty, and it has been for all of my working backups going back to at least 1.5.3. Somehow my system was working fine with the empty directory before. Perhaps what is new is that the query_factory.php file is being attempted to access via

/home/hbzenftp/hardbrakes.com/hbadmin/includes/init_includes/init_database.php on line 17

now? What would trigger the system to call init_database.php? This has been a stable system with no file changes for a year.

When I was looking for causes I did notice that my host auto-upgraded my php installation to 7.x. I tried switching that back to PHP 5.6 but the problem persists. Could the PHP upgrade have caused this?

[mc12345678]

No php version change itself would not cause files to be removed. That would be some other cause.

Why the backups worked would have to be because of some other modification(s) that have changed how the fileset compares to a default install of the program.

That directory has had content at least since ZC 1.5.1, so don't know what is up with the existing fileset.

[ts232]

No php version change itself would not cause files to be removed. That would be some other cause.

Why the backups worked would have to be because of some other modification(s) that have changed how the fileset compares to a default install of the program.

That directory has had content at least since ZC 1.5.1, so don't know what is up with the existing fileset.

Thank You!!!

I grabbed the mysql directory from the distribution 1.5.6a and plugged it into my current install and everything seems to be working fine now. The big mystery is why all of my backups going back to 1.3.8 were missing this directory, and how did it manage to work all those years without it?

[Design75]

I suspect that the folder and it contents were there, but that your back-up settings somehow excluded it from the back-up

Thank You!!!

I grabbed the mysql directory from the distribution 1.5.6a and plugged it into my current install and everything seems to be working fine now. The big mystery is why all of my backups going back to 1.3.8 were missing this directory, and how did it manage to work all those years without it?

[mc12345678]

Also, now that you have chosen to use a file from a different version of ZC than the rest of your store, you are actually going to have problems that you may not yet have realized. There are changes that were made in ZC 1.5.5 related to randomizing sql queries.

The suggested way to have upgraded (which wasn't followed as can be seen by the configure.php files) is: http://www.zen-cart.com/entry.php?3-...d-of-upgrading