Zen Cart Logo
Forums / Installing on a Windows Server / Error when trying to go to Admin, v154 on PHP 5.2

Error when trying to go to Admin, v154 on PHP 5.2

Views: 7,780

Results 21 to 28 of 28
2 Feb 2016, 7:58 PM
#21
wcsur avatar

wcsur

New Zenner

Join Date:
Mar 2014
Location:
Washington state
Posts:
59
Plugin Contributions:
0

Error when trying to go to Admin, v154 on PHP 5.2

Error I'm getting trying to go to admin:

The website encountered an error while retrieving http://thedreamweaver.netau.net/zen-cart/admin/index.php. It may be down for maintenance or configured incorrectly.

admin/index.php:

<?php /** * @package admin * @copyright Copyright 2003-2013 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 GIT: $Id: Author: DrByte Wed Oct 23 14:38:22 2013 -0400 Modified in v1.5.2 $ */ $version_check_index=true; require('includes/application_top.php'); $languages = zen_get_languages(); $languages_array = array(); $languages_selected = DEFAULT_LANGUAGE; for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $languages_array[] = array('id' => $languages[$i]['code'], 'text' => $languages[$i]['name']); if ($languages[$i]['directory'] == $_SESSION['language']) { $languages_selected = $languages[$i]['code']; } } ?> <!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> <meta name="robots" content="noindex, nofollow" /> <script language="JavaScript" src="includes/menu.js" type="text/JavaScript"></script> <link href="includes/stylesheet.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS" /> <script type="text/javascript"> <!-- function init() { cssjsmenu('navbar'); if (document.getElementById) { var kill = document.getElementById('hoverJS'); kill.disabled = true; } } // --> </script> </head> <body onLoad="init()"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <?php

$customers = $db->Execute("select count(*) as count from " . TABLE_CUSTOMERS);

$products = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");

$products_off = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '0'");

$reviews = $db->Execute("select count() as count from " . TABLE_REVIEWS);
$reviews_pending = $db->Execute("select count(
) as count from " . TABLE_REVIEWS . " where status='0'");

$newsletters = $db->Execute("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");

$counter_query = "select startdate, counter from " . TABLE_COUNTER;
$counter = $db->Execute($counter_query);
$counter_startdate = $counter->fields['startdate'];
// $counter_startdate_formatted = strftime(DATE_FORMAT_LONG, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4)));
$counter_startdate_formatted = strftime(DATE_FORMAT_SHORT, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4)));

$specials = $db->Execute("select count() as count from " . TABLE_SPECIALS . " where status= '0'");
$specials_act = $db->Execute("select count(
) as count from " . TABLE_SPECIALS . " where status= '1'");
$featured = $db->Execute("select count() as count from " . TABLE_FEATURED . " where status= '0'");
$featured_act = $db->Execute("select count(
) as count from " . TABLE_FEATURED . " where status= '1'");
$salemaker = $db->Execute("select count() as count from " . TABLE_SALEMAKER_SALES . " where sale_status = '0'");
$salemaker_act = $db->Execute("select count(
) as count from " . TABLE_SALEMAKER_SALES . " where sale_status = '1'");

?>

<div id="colone"> <div class="reportBox"> <div class="header"><?php echo BOX_TITLE_STATISTICS; ?> </div> <?php echo '<div class="row"><span class="left">' . BOX_ENTRY_COUNTER_DATE . '</span><span class="rigth"> ' . $counter_startdate_formatted . '</span></div>'; echo '<div class="row"><span class="left">' . BOX_ENTRY_COUNTER . '</span><span class="rigth"> ' . $counter->fields['counter'] . '</span></div>'; echo '<div class="row"><span class="left">' . BOX_ENTRY_CUSTOMERS . '</span><span class="rigth"> ' . $customers->fields['count'] . '</span></div>'; echo '<div class="row"><span class="left">' . BOX_ENTRY_PRODUCTS . ' </span><span class="rigth">' . $products->fields['count'] . '</span></div>'; echo '<div class="row"><span class="left">' . BOX_ENTRY_PRODUCTS_OFF . ' </span><span class="rigth">' . $products_off->fields['count'] . '</span></div>'; echo '<div class="row"><span class="left">' . BOX_ENTRY_REVIEWS . '</span><span class="rigth">' . $reviews->fields['count']. '</span></div>'; if (REVIEWS_APPROVAL=='1') { echo '<div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_REVIEWS, 'status=1', 'NONSSL') . '">' . BOX_ENTRY_REVIEWS_PENDING . '</a></span><span class="rigth">' . $reviews_pending->fields['count']. '</span></div>'; } echo '<div class="row"><span class="left">' . BOX_ENTRY_NEWSLETTERS . '</span><span class="rigth"> ' . $newsletters->fields['count']. '</span></div>';

echo '<br /><div class="row"><span class="left">' . BOX_ENTRY_SPECIALS_EXPIRED . '</span><span class="rigth"> ' . $specials->fields['count']. '</span></div>';
echo '<div class="row"><span class="left">' . BOX_ENTRY_SPECIALS_ACTIVE . '</span><span class="rigth"> ' . $specials_act->fields['count']. '</span></div>';
echo '<div class="row"><span class="left">' . BOX_ENTRY_FEATURED_EXPIRED . '</span><span class="rigth"> ' . $featured->fields['count']. '</span></div>';
echo '<div class="row"><span class="left">' . BOX_ENTRY_FEATURED_ACTIVE . '</span><span class="rigth"> ' . $featured_act->fields['count']. '</span></div>';
echo '<div class="row"><span class="left">' . BOX_ENTRY_SALEMAKER_EXPIRED . '</span><span class="rigth"> ' . $salemaker->fields['count']. '</span></div>';
echo '<div class="row"><span class="left">' . BOX_ENTRY_SALEMAKER_ACTIVE . '</span><span class="rigth"> ' . $salemaker_act->fields['count']. '</span></div>';

?>

</div> <div class="reportBox"> <div class="header"><?php echo BOX_TITLE_ORDERS; ?> </div> <?php $orders_contents = ''; $orders_status = $db->Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'");

while (!$orders_status->EOF) {
$orders_pending = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status->fields['orders_status_id'] . "'");

$orders_contents .= '<div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status->fields['orders_status_id'], 'NONSSL') . '">' . $orders_status->fields['orders_status_name'] . '</a>:</span><span class="rigth"> ' . $orders_pending->fields['count'] . '</span>   </div>';
$orders_status->MoveNext();

}

echo $orders_contents;
?>

</div> </div> <div id="coltwo"> <div class="reportBox"> <div class="header"><?php echo BOX_ENTRY_NEW_CUSTOMERS; ?> </div> <?php $customers = $db->Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, c.customers_email_address as customers_email_address, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " a on c.customers_id = a.customers_info_id order by a.customers_info_date_account_created DESC limit 5");

while (!$customers->EOF) {
$customers->fields['customers_firstname'] = zen_output_string_protected($customers->fields['customers_firstname']);
$customers->fields['customers_lastname'] = zen_output_string_protected($customers->fields['customers_lastname']);
echo ' <div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_CUSTOMERS, 'search=' . $customers->fields['customers_email_address'] . '&origin=' . FILENAME_DEFAULT, 'NONSSL') . '" class="contentlink">'. $customers->fields['customers_firstname'] . ' ' . $customers->fields['customers_lastname'] . '</a></span><span class="rigth">' . "\n";
echo zen_date_short($customers->fields['customers_info_date_account_created']);
echo ' </span></div>' . "\n";
$customers->MoveNext();
}
?>

</div> <div class="reportBox"> <?php $counter_query = "select startdate, counter, session_counter from " . TABLE_COUNTER_HISTORY . " order by startdate DESC limit 10"; $counter = $db->Execute($counter_query); ?> <div class="header"><?php echo sprintf(LAST_10_DAYS, $counter->RecordCount()); ?><?php echo '<span class="rigth">    ' . SESSION . ' - ' . TOTAL . '</span>'; ?></div> <?php

while (!$counter->EOF) {
$counter_startdate = $counter->fields['startdate'];
$counter_startdate_formatted = strftime(DATE_FORMAT_SHORT, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4)));
echo ' <div class="row"><span class="left">' . $counter_startdate_formatted . '</span><span class="rigth"> ' . $counter->fields['session_counter'] . ' - ' . $counter->fields['counter'] . '</span> </div>' . "\n";
$counter->MoveNext();
}
?>

</div> </div> <div id="colthree"> <div class="reportBox"> <div class="header"><?php echo BOX_ENTRY_NEW_ORDERS; ?> </div> <?php $orders = $db->Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id and class = 'ot_total') order by orders_id DESC limit 5");

while (!$orders->EOF) {
echo ' <div class="row"><span class="left"><a href="' . zen_href_link(FILENAME_ORDERS, 'oID=' . $orders->fields['orders_id'] . '&origin=' . FILENAME_DEFAULT, 'NONSSL') . '" class="contentlink"> ' . $orders->fields['customers_name'] . '</a></span><span class="center">' . $orders->fields['order_total'] . '</span><span class="rigth">' . "\n";
echo zen_date_short($orders->fields['date_purchased']);
echo ' </span></div>' . "\n";
$orders->MoveNext();
}
?>

</div> </div> <!-- The following copyright announcement is in compliance to section 2c of the GNU General Public License, and thus can not be removed, or can only be modified appropriately.

Please leave this comment intact together with the
following copyright announcement. //-->

<div class="copyrightrow"><a href="http://www.zen-cart.com" target="_blank"><img src="images/small_zen_logo.gif" alt="Zen Cart:: the art of e-commerce" border="0" /></a><br /><br />E-Commerce Engine Copyright © 2003-<?php echo date('Y'); ?> <a href="http://www.zen-cart.com" target="_blank">Zen Cart®</a></div><div class="warrantyrow"><br /><br />Zen Cart is derived from: Copyright © 2003 osCommerce<br />This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;<br />without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE<br />and is redistributable under the <a href="http://www.zen-cart.com/license/2_0.txt" target="_blank">GNU General Public License</a><br /> </div> </body> </html> <?php require('includes/application_bottom.php'); ?>
2 Feb 2016, 8:55 PM
#22
rixstix avatar

rixstix

Totally Zenned

Join Date:
Aug 2009
Location:
North Idaho, USA
Posts:
2,015
Plugin Contributions:
0

Re: Error when trying to go to Admin, v154 on PHP 5.2

Since you stated that you are using php 5.2.xx

Not sure if any is applicable to a Windows Server Install as you indicated but

Have you looked at this thread and implemented the php5.2 suggestions?
https://www.zen-cart.com/showthread.php?215694-Known-Bugs-%28and-fixes%29-with-v1-5-4

2 Feb 2016, 9:35 PM
#23
wcsur avatar

wcsur

New Zenner

Join Date:
Mar 2014
Location:
Washington state
Posts:
59
Plugin Contributions:
0

Re: Error when trying to go to Admin, v154 on PHP 5.2

RixStix:

Since you stated that you are using php 5.2.xx

Not sure if any is applicable to a Windows Server Install as you indicated but

Have you looked at this thread and implemented the php5.2 suggestions?
https://www.zen-cart.com/showthread.php?215694-Known-Bugs-%28and-fixes%29-with-v1-5-4

2 fixes in there made everything work! THANK YOU VERY MUCH!

2 Feb 2016, 10:21 PM
#24
rixstix avatar

rixstix

Totally Zenned

Join Date:
Aug 2009
Location:
North Idaho, USA
Posts:
2,015
Plugin Contributions:
0

Re: Error when trying to go to Admin, v154 on PHP 5.2

Glad to see that was able to get you running.

I'd consider those fixes as temporary/stopgap until you can get php upgraded to support the current zencart versions.

2 Feb 2016, 10:41 PM
#25
wcsur avatar

wcsur

New Zenner

Join Date:
Mar 2014
Location:
Washington state
Posts:
59
Plugin Contributions:
0

Re: Error when trying to go to Admin, v154 on PHP 5.2

RixStix:

Glad to see that was able to get you running.

I'd consider those fixes as temporary/stopgap until you can get php upgraded to support the current zencart versions.

Asked them if they are going to upgrade as it was out of date. Waiting on an answer.

3 Feb 2016, 3:59 PM
#26
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Error when trying to go to Admin, v154 on PHP 5.2

mc12345678:

This message is on your store front and is part of why you can't access the admin at this time:

Hmmm, is this something new? I'm sure I've been able to access the admin section of a site even when the install folder does exist.

Now I'm not so sure (is my memory really deteriorating that quickly, I seem to be forgetting a lot of 'details' lately)

������

3 Feb 2016, 7:27 PM
#27
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: Error when trying to go to Admin, v154 on PHP 5.2

RodG:

Hmmm, is this something new? I'm sure I've been able to access the admin section of a site even when the install folder does exist.

Now I'm not so sure (is my memory really deteriorating that quickly, I seem to be forgetting a lot of 'details' lately)

������

Maybe it was the short holiday from ZC that has caused the loss of details. :) I'm still trying to get to a condition to test my statement above about the presence of a full zc_install directory having an impact on accessing the admin... I thought the last time I forgot to rename/remove the directory I was prompted with an info screen advising me to address it before moving forward. Hmm, I guess I could look through the admin code path in absence of running a true test...

3 Feb 2016, 8:48 PM
#28
mc12345678 avatar

mc12345678

Totally Zenned

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

Re: Error when trying to go to Admin, v154 on PHP 5.2

RodG:

Hmmm, is this something new? I'm sure I've been able to access the admin section of a site even when the install folder does exist.

Now I'm not so sure (is my memory really deteriorating that quickly, I seem to be forgetting a lot of 'details' lately)

������

Gave up in the review of admin/index.php, and admin/includes/application_top.php and did a search of the files. In ZC 1.5.4 the issue is addressed in admin/includes/init_includes/init_admin_auth.php lines 22-26 at least when not in a series of a test environment/having overridden some constants, etc... Basically redirected to a forbidden page... Yes, all sorts of ways to work around it, but basic install would prevent access to the admin if the zc_install directory existed regardless of content within.