Help reinstalling store

I have recently encountered a roadblock with ZC. I have a number of add-ons installed from admin add-ons, to shipping. Most recently I have tried to configure "super orders" and I encountered some errors. After checking the error log and mitigating some of the errors. I have encountered a blank admin page, and now there are no more errors to go by. In reading up on the forums I can only draw the conclusion that between a few unnecessary add-ons and the editing of some core files, it is just too cluttered and we would benefit from a clean install.

I have followed the instructions in the install docs for a migration. I have created a new directory, a new database, and I planned on configuring it and then either pointing it to the existing database, or copying it over to the new db. The problem I encountered is that I do not want to lose all the keywords (I have something like 30 categories, with 80,000 products) and the theme I currently lose will not pull up in the new installation.

Is there a way of overwriting core files (in the existing installation) to upload a fresh installation of zencart? Again, I would like to keep some of the existing files I have (invoices, meta tags, certain files.)

Can anyone provide some insight as to how to best complete this?

Can anyone provide some insight as to how to best complete this?
The procedure would be the same as for an upgrade
Where you compare your current files to a fresh set to locate differing files/customizations that you may or may not want
Use a diff tool like beyond compare or winmerge for this step

kobra:

The procedure would be the same as for an upgrade
Where you compare your current files to a fresh set to locate differing files/customizations that you may or may not want
Use a diff tool like beyond compare or winmerge for this step

I use winmerge, but it is my understanding that the file comparison has to be done on an individual basis. Given that there is somewhere in the neighborhood of 1,000 files, is there any way of comparing at the directory level?

I use winmerge, but it is my understanding that the file comparison has to be done on an individual basis.
Not true but not a ZenCart issue
http://manual.winmerge.org/Open_paths.html#OpenPaths_opendialog

Most recently I have tried to configure "super orders" and I encountered some errors.

Does your hosting company provide backups of your site? If so then perhaps they can perform a rollback to a time before the site was messed up.

Vger

I have a few backups handy. The first I tried to have the hosting company unzip, I had weird re-directs for some of the other sub-domains I have.

I am in the process of FTP'ing a backup from late May hoping that may work. I have also tried uploading a clean install while keeping the directories intact with no luck. The issue is still there..

I have restored a backup from late May before I had any of the issues, and I am having the same issues...

So far I have tried to upload and overwrite with a fresh 1.3.9h, and restored a backup and I still get a blank page with no error. Any input would be greatly appreciated.

I have restored a backup from late May before I had any of the issues, and I am having the same issues...

So far I have tried to upload and overwrite with a fresh 1.3.9h,
Start with a directory like test and a NEW DB and just install 1.3.9h there
After is is installed, you have renamed your admin and can access both the frontend and the admin
Then using phpmyadmin import a DB backup from some date into this NEW DB

As many add-ons make alterations and additions to the database, your need to be a but cautious, but the first step I would undertake is to CLONE (make a copy of) the database.

In phpMyAdmin this is quite straight-forward.

In your C-panel, create a new empty database (call it clone) and apply the same user as exists in the original database.

Then, in phpMyAdmin, open the existing database, and on the right frame, click the EXPORT tab

Then, look at the section that says, and insert / check the following:

Copy database to: [xxxxx_clone] where xxxxx = your hostname
Structure only
Structure and data [tick]
Data only
CREATE DATABASE before copying
Add DROP TABLE / DROP VIEW
Add AUTO_INCREMENT value [tick]
Add constraints
Switch to copied database

Then, click GO button on right-hand side - make sure it's the GO button appropriate for that section.

VOILA - - - you have a COPY of your database, called xxxxx_clone

Now... you can FTP a fresh file-set of ZC 1.3.9h to a SUB-DIRECTORY (perhaps called "clone" as well).

Then, MANUALLY edit the two configure files to indicate all the correct PATHS to the various directories and resources, as well as the database name and its applied username and relevant password.

Then, run zc_install, and choose ONLY to upgrade the database!

If you go all the configurations correct, you will have a 1.3.9h set of files, pointing at your (now upgraded) copy of the original database.

When you navigate to the store, it will look a mess, because the database is telling it to reference a template that does not exist, so go into the admin panel and set the template to "classic".

Then, go to admin >>> configuration, and under LOGGING, change the PATH for Log Destination, to the correct path for this installation. As it is now in a sub-directory, this must be shown.

Then, go to admin >>> configuration, and under SESSIONS, do the same with the PATH where sessions are indicated as being stored.

(You can always reference the ORIGINAL configure.php files to see the basis of these paths).

Then, go to TOOLS, Layout Boxes Controller, and at the bottom of the screen, click RESET button.

... and that should give you a functional store, under the (boring) "classic" template, that is actually drawing data off your known data-sets, which now exist in the CLONED database.

Where you go from this point is largely up to you.

I would firstly try to remove all database configs that relate to add-ons that you now don't have the corresponding PHP files for.

Remember... your (cloned) database still has references to add-ons that needed to make dbase changes - but with a FRESH install of ZC, you no longer have the FILES that drive things.

I find it better to run the various modules' UNINSTALL.SQL files.

In some cases, you may have to remove certain things via phpMyAdmin.

There are likely to be quite a few issues until you get the dbase "compatible" with the files that are running it. But it should not take too long to iron out any significant issues.

What you are left with is a database that is properly patched to 1.3.9, that still retains all yoru product and customer info.

When you are happy with its reliability, you can think of applying a fresh template.

Then, when all is 100%, make this CLONE your live site.

You can try re-installing some of the Add-Ons - remembering of course that you may not need to run their SQL patches if they had one (because the database already contains the data and configs).

For any add-on that you DON'T want, if it had a "install.sql" file, then you now need to run its corresponding "uninstall.sql" file through the TOOLS >>> install sql patches.

When you get the functionality you require

Thank you both for your input! I am in the process of making the suggested changes and will update on my progress.

I have successfully completed all of the suggested changes. I now have a separate directory with a duplicate database.

However, if I try to set the template to my existing template the page loads a blank stylesheet. I initially received an apache error for a large image but after calling the hosting company that did not remedy the issue.

The classic green template loads fine, but when I select my template the page loads blank as seen at https://www.boatersplanet.com/test

Any suggestions?

You should be running 1.3.9h

heck your cache for debug files and see what error if any you are getting

I have a clean install of 1.3.9h with a duplicate database.

The classic green template loads fine which is why I think that it could be a template issue. However, I upgraded to 1.3.9 months ago and I haven't run into an issue with the template.

I am getting the following error message within zencart's debug:

[16-Jun-2011 22:17:04] PHP Warning:  require(includes//browser_agent.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/USER/public_html/test/includes/templates/ZC03C00282/common/tpl_main_page.php on line 39
[16-Jun-2011 22:17:04] PHP Warning:  require(includes//browser_agent.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/USER/public_html/test/includes/templates/ZC03C00282/common/tpl_main_page.php on line 39
[16-Jun-2011 22:17:04] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes//browser_agent.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/USER/php') in /home/USER/public_html/test/includes/templates/ZC03C00282/common/tpl_main_page.php on line 39

I reached out to the company which I purchased the template from and they would let me re-download the template again for $20. I'm not worried about that, but it would be a waste if it isn't a template/stylesheet issue.

... and I also just saw this

[17-Jun-2011 00:24:09] PHP Fatal error:  Call to undefined function cfg_select_option() in /home/USER/public_html/test/wingnut/configuration.php(179) : eval()'d code on line 1

Failed opening required 'includes//[B]browser_agent.php[/B]

browser_agent.php is not a ZenCart File

And it appears that your install is hacked have a look at the file on the server compared to a fresh copy of
/test/wingnut/configuration.php

eval()'d code on line 1

A fresh copy line one is

<?php

What is the code on line one of that file??

The code eval()'d does not appear ANYWHERE in the default install of 1.3.9h.

Vger

Vger:

The code eval()'d does not appear ANYWHERE in the default install of 1.3.9h.

Vger

I compared with the fresh install and the line it is referring to is in admin/configuration.php line 179:

eval('$value_field = ' . $cInfo->set_function . '"' . htmlspecialchars($cInfo->configuration_value) . '");');

The only thing on line 1 of that file is <?php and eval is not the same as eval()'d

Vger

Vger:

The only thing on line 1 of that file is <?php and eval is not the same as eval()'d

Vger

The only thing I have on line 1 of that file is "<?php" and the error refers to line 179 which I posted. I will provide the entire configuration.php file below.

<?php
/**
 * @package admin
 * @copyright Copyright 2003-2009 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: configuration.php 14193 2009-08-18 04:15:13Z drbyte $
 */


  require('includes/application_top.php');

  $action = (isset($_GET['action']) ? $_GET['action'] : '');

  if (zen_not_null($action)) {
    switch ($action) {
      case 'save':
        // demo active test
        if (zen_admin_demo()) {
          $_GET['action']= '';
          $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
          zen_redirect(zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cID));
        }
        $configuration_value = zen_db_prepare_input($_POST['configuration_value']);
        $cID = zen_db_prepare_input($_GET['cID']);

        $db->Execute("update " . TABLE_CONFIGURATION . "
                      set configuration_value = '" . zen_db_input($configuration_value) . "',
                          last_modified = now() where configuration_id = '" . (int)$cID . "'");
        $configuration_query = 'select configuration_key as cfgkey, configuration_value as cfgvalue
                          from ' . TABLE_CONFIGURATION;

        $configuration = $db->Execute($configuration_query);

        // set the WARN_BEFORE_DOWN_FOR_MAINTENANCE to false if DOWN_FOR_MAINTENANCE = true
        if ( (WARN_BEFORE_DOWN_FOR_MAINTENANCE == 'true') && (DOWN_FOR_MAINTENANCE == 'true') ) {
        $db->Execute("update " . TABLE_CONFIGURATION . "
                      set configuration_value = 'false', last_modified = '" . NOW . "'
                      where configuration_key = 'WARN_BEFORE_DOWN_FOR_MAINTENANCE'"); }

        $configuration_query = 'select configuration_key as cfgkey, configuration_value as cfgvalue
                          from ' . TABLE_CONFIGURATION;

        $configuration = $db->Execute($configuration_query);

        zen_redirect(zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cID));
        break;
    }
  }

  $gID = (isset($_GET['gID'])) ? $_GET['gID'] : 1;
  $_GET['gID'] = $gID;
  $cfg_group = $db->Execute("select configuration_group_title
                             from " . TABLE_CONFIGURATION_GROUP . "
                             where configuration_group_id = '" . (int)$gID . "'");

if ($gID == 7) {
        $shipping_errors = '';
        if (zen_get_configuration_key_value('SHIPPING_ORIGIN_ZIP') == 'NONE' or zen_get_configuration_key_value('SHIPPING_ORIGIN_ZIP') == '') {
          $shipping_errors .= '<br />' . ERROR_SHIPPING_ORIGIN_ZIP;
        }
        if (zen_get_configuration_key_value('ORDER_WEIGHT_ZERO_STATUS') == '1' and !defined('MODULE_SHIPPING_FREESHIPPER_STATUS')) {
          $shipping_errors .= '<br />' . ERROR_ORDER_WEIGHT_ZERO_STATUS;
        }
        if (defined('MODULE_SHIPPING_USPS_STATUS') and (MODULE_SHIPPING_USPS_USERID=='NONE' or MODULE_SHIPPING_USPS_SERVER == 'test')) {
          $shipping_errors .= '<br />' . ERROR_USPS_STATUS;
        }
        if ($shipping_errors != '') {
          $messageStack->add(ERROR_SHIPPING_CONFIGURATION . $shipping_errors, 'caution');
        }
}

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" src="includes/general.js"></script>
<script type="text/javascript">
  <!--
  function init()
  {
    cssjsmenu('navbar');
    if (document.getElementById)
    {
      var kill = document.getElementById('hoverJS');
      kill.disabled = true;
    }
  }
  // -->
</script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="init()">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading"><?php echo $cfg_group->fields['configuration_group_title']; ?></td>
            <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr class="dataTableHeadingRow">
                <td class="dataTableHeadingContent" width="55%"><?php echo TABLE_HEADING_CONFIGURATION_TITLE; ?></td>
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CONFIGURATION_VALUE; ?></td>
                <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>
              </tr>
<?php
  $configuration = $db->Execute("select configuration_id, configuration_title, configuration_value, configuration_key,
                                        use_function from " . TABLE_CONFIGURATION . "
                                        where configuration_group_id = '" . (int)$gID . "'
                                        order by sort_order");
  while (!$configuration->EOF) {
    if (zen_not_null($configuration->fields['use_function'])) {
      $use_function = $configuration->fields['use_function'];
      if (preg_match('/->/', $use_function)) {
        $class_method = explode('->', $use_function);
        if (!is_object(${$class_method[0]})) {
          include(DIR_WS_CLASSES . $class_method[0] . '.php');
          ${$class_method[0]} = new $class_method[0]();
        }
        $cfgValue = zen_call_function($class_method[1], $configuration->fields['configuration_value'], ${$class_method[0]});
      } else {
        $cfgValue = zen_call_function($use_function, $configuration->fields['configuration_value']);
      }
    } else {
      $cfgValue = $configuration->fields['configuration_value'];
    }

    if ((!isset($_GET['cID']) || (isset($_GET['cID']) && ($_GET['cID'] == $configuration->fields['configuration_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {
      $cfg_extra = $db->Execute("select configuration_key, configuration_description, date_added,
                                        last_modified, use_function, set_function
                                 from " . TABLE_CONFIGURATION . "
                                 where configuration_id = '" . (int)$configuration->fields['configuration_id'] . "'");
      $cInfo_array = array_merge($configuration->fields, $cfg_extra->fields);
      $cInfo = new objectInfo($cInfo_array);
    }

    if ( (isset($cInfo) && is_object($cInfo)) && ($configuration->fields['configuration_id'] == $cInfo->configuration_id) ) {
      echo '                  <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cInfo->configuration_id . '&action=edit') . '\'">' . "\n";
    } else {
      echo '                  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $configuration->fields['configuration_id'] . '&action=edit') . '\'">' . "\n";
    }
?>
                <td class="dataTableContent"><?php echo $configuration->fields['configuration_title']; ?></td>
                <td class="dataTableContent"><?php echo htmlspecialchars($cfgValue); ?></td>
                <td class="dataTableContent" align="right"><?php if ( (isset($cInfo) && is_object($cInfo)) && ($configuration->fields['configuration_id'] == $cInfo->configuration_id) ) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $configuration->fields['configuration_id']) . '" name="link_' . $configuration->fields['configuration_key'] . '">' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
              </tr>
<?php
    $configuration->MoveNext();
  }
?>
            </table></td>
<?php
  $heading = array();
  $contents = array();

  switch ($action) {
    case 'edit':
      $heading[] = array('text' => '<b>' . $cInfo->configuration_title . '</b>');

      if ($cInfo->set_function) {
        eval('$value_field = ' . $cInfo->set_function . '"' . htmlspecialchars($cInfo->configuration_value) . '");');
      } else {
        $value_field = zen_draw_input_field('configuration_value', $cInfo->configuration_value, 'size="60"');
      }

      $contents = array('form' => zen_draw_form('configuration', FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cInfo->configuration_id . '&action=save'));
      if (ADMIN_CONFIGURATION_KEY_ON == 1) {
        $contents[] = array('text' => '<strong>Key: ' . $cInfo->configuration_key . '</strong><br />');
      }
      $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);
      $contents[] = array('text' => '<br><b>' . $cInfo->configuration_title . '</b><br>' . $cInfo->configuration_description . '<br>' . $value_field);
      $contents[] = array('align' => 'center', 'text' => '<br>' . zen_image_submit('button_update.gif', IMAGE_UPDATE, 'name="submit' . $cInfo->configuration_key . '"') . ' <a href="' . zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cInfo->configuration_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
      break;
    default:
      if (isset($cInfo) && is_object($cInfo)) {
        $heading[] = array('text' => '<b>' . $cInfo->configuration_title . '</b>');
        if (ADMIN_CONFIGURATION_KEY_ON == 1) {
          $contents[] = array('text' => '<strong>Key: ' . $cInfo->configuration_key . '</strong><br />');
        }

        $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_CONFIGURATION, 'gID=' . $_GET['gID'] . '&cID=' . $cInfo->configuration_id . '&action=edit') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a>');
        $contents[] = array('text' => '<br>' . $cInfo->configuration_description);
        $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . zen_date_short($cInfo->date_added));
        if (zen_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_INFO_LAST_MODIFIED . ' ' . zen_date_short($cInfo->last_modified));
      }
      break;
  }

  if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) {
    echo '            <td width="25%" valign="top">' . "\n";

    $box = new box;
    echo $box->infoBox($heading, $contents);

    echo '            </td>' . "\n";
  }
?>
          </tr>
        </table></td>
      </tr>
    </table></td>
<!-- body_text_eof //-->
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Error:

[17-Jun-2011 00:24:09] PHP Fatal error:  Call to undefined function cfg_select_option() in /home/USER/public_html/test/ADMIN/configuration.php(179) : eval()'d code on line 1

I've compared your file against a default 1.3.9h file, and they are identical - so the problem lies elsewhere.

Failed opening required 'includes//browser_agent.php

As has already been said - that file isn't part of Zen Cart.

It seems that your site is still hacked.

Vger