Edit Orders v4.0 Support Thread

[sungmo]

Edit Orders Version 4.1.4
Zencart Version 1.5.1


Hi i have a problem.

when i click update button i meet blank page. however, update button is working on most orders.

so i checked edit_orders.php file. and i saw "if ($status < 1) break;".

most order's status are larger than 1 but orders status having blank page are 0.

can someone explain why some orders have 0 status?

and how to solve not to see blank page?

thanks...

[lat9]

Edit Orders Version 4.1.4
Zencart Version 1.5.1


Hi i have a problem.

when i click update button i meet blank page. however, update button is working on most orders.

so i checked edit_orders.php file. and i saw "if ($status < 1) break;".

most order's status are larger than 1 but orders status having blank page are 0.

can someone explain why some orders have 0 status?

and how to solve not to see blank page?

thanks...

Zen Cart 1.5.1 (released in 2012) is going to be more difficult to debug, but when you receive a blank-page there "should" be a file created in your store's /logs directory named myDEBUG-adm-*.log that identify what the PHP issue is.

Remember that the -adm- debug-logs contain your store's secret-admin name, so if you post the contents of that file, be sure to xxx-out that name.

Other than some underlying PHP-related issue, I have no explanation for your orders that have an undefined (i.e. 0) value for their status-code ... but that's for a separate forum posting to determine.

[sungmo]

Hi thanks for your answer...

below is the myDEBUG-adm-1528817021-296426.log's content

PHP Warning: Cannot modify header information - headers already sent by (output started at /home/tucsoncitycenter/public_html/xxx/edit_orders.php:69) in /home/tucsoncitycenter/public_html/xxx/includes/functions/general.php on line 23

and below is the general.php's 23 line

// Redirect to another page or site
function zen_redirect($url) {
global $logger;

// clean up URL before executing it
while (strstr($url, '&&')) $url = str_replace('&&', '&', $url);
while (strstr($url, '&amp;&amp;')) $url = str_replace('&amp;&amp;', '&amp;', $url);
// header locates should not have the &amp; in the address it breaks things
while (strstr($url, '&amp;')) $url = str_replace('&amp;', '&', $url);

header('Location: ' . $url); // line 23
session_write_close();
if (STORE_PAGE_PARSE_TIME == 'true') {
if (!is_object($logger)) $logger = new logger;
$logger->timer_stop();
}
exit;
}

and below is the DEBUG-update_order-1528817154-119718.log in logs/edit_orders

============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 1128
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_tax;ot_gv;ot_total


can you guess what the problem is on my website?

and if i give you my website's info...can you check for me?

thanks have a good one.

[lat9]

@sungmo, it's been about 2 years since I looked at EO 4.1.4. Would you post the top 100 lines of /your_admin/edit_orders.php (using "CODE" tags) and identify which line is #69.

[sungmo]

@sungmo, it's been about 2 years since I looked at EO 4.1.4. Would you post the top 100 lines of /your_admin/edit_orders.php (using "CODE" tags) and identify which line is #69.

line 69 is after if ($status < 1) break;

thanks...

<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+

global $db;

require('includes/application_top.php');

// Check for commonly broken attribute related items
eo_checks_and_warnings();

// Start the currencies code
include_once(DIR_WS_INCLUDES . 'init_includes/init_currencies.php');

// Use the normal order class instead of the admin one
include(DIR_FS_CATALOG . DIR_WS_CLASSES . 'order.php');

$oID = zen_db_prepare_input($_GET['oID']);
$step = zen_db_prepare_input($_POST['step']);
$add_product_categories_id = zen_db_prepare_input($_POST['add_product_categories_id']);
$add_product_products_id = zen_db_prepare_input($_POST['add_product_products_id']);
$add_product_quantity = zen_db_prepare_input($_POST['add_product_quantity']);

$orders_statuses = array();
$orders_status_array = array();
$orders_status_query = $db->Execute("select orders_status_id, orders_status_name
from " . TABLE_ORDERS_STATUS . "
where language_id = '" . (int)$_SESSION['languages_id'] . "' order by orders_status_id");
while (!$orders_status_query->EOF) {
$orders_statuses[] = array('id' => $orders_status_query->fields['orders_status_id'],
'text' => $orders_status_query->fields['orders_status_name'] . ' [' . $orders_status_query->fields['orders_status_id'] . ']');
$orders_status_array[$orders_status_query->fields['orders_status_id']] = $orders_status_query->fields['orders_status_name'];
$orders_status_query->MoveNext();
}

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

if (zen_not_null($action)) {
if(EO_DEBUG_ACTION_LEVEL > 0) eo_log(
'============================================================' . PHP_EOL .
'= Edit Orders (' . EO_VERSION . ') Action Log' . PHP_EOL .
'============================================================' . PHP_EOL .
'Order ID: ' . $oID . PHP_EOL .
'Action Requested: ' . $action . PHP_EOL .
'Enabled Order Totals: ' . str_replace('.php', '', MODULE_ORDER_TOTAL_INSTALLED) . PHP_EOL
);

switch ($action) {

// Update Order
case 'update_order':
$comments = zen_db_prepare_input($_POST['comments']);
$status = (int)zen_db_prepare_input($_POST['status']);
if ($status < 1) break;

$order_updated = false;
$sql_data_array = array(
'customers_name' => zen_db_prepare_input($_POST['update_customer_name']),
'customers_company' => zen_db_prepare_input($_POST['update_customer_company']),
'customers_street_address' => zen_db_prepare_input($_POST['update_customer_street_address']),
'customers_suburb' => zen_db_prepare_input($_POST['update_customer_suburb']),
'customers_city' => zen_db_prepare_input($_POST['update_customer_city']),
'customers_state' => zen_db_prepare_input($_POST['update_customer_state']),
'customers_postcode' => zen_db_prepare_input($_POST['update_customer_postcode']),
'customers_country' => zen_db_prepare_input($_POST['update_customer_country']),
'customers_telephone' => zen_db_prepare_input($_POST['update_customer_telephone']),
'customers_email_address' => zen_db_prepare_input($_POST['update_customer_email_address']),
'last_modified' => 'now()',

'billing_name' => zen_db_prepare_input($_POST['update_billing_name']),
'billing_company' => zen_db_prepare_input($_POST['update_billing_company']),
'billing_street_address' => zen_db_prepare_input($_POST['update_billing_street_address']),
'billing_suburb' => zen_db_prepare_input($_POST['update_billing_suburb']),
'billing_city' => zen_db_prepare_input($_POST['update_billing_city']),
'billing_state' => zen_db_prepare_input($_POST['update_billing_state']),
'billing_postcode' => zen_db_prepare_input($_POST['update_billing_postcode']),
'billing_country' => zen_db_prepare_input($_POST['update_billing_country']),

'delivery_name' => zen_db_prepare_input($_POST['update_delivery_name']),
'delivery_company' => zen_db_prepare_input($_POST['update_delivery_company']),
'delivery_street_address' => zen_db_prepare_input($_POST['update_delivery_street_address']),
'delivery_suburb' => zen_db_prepare_input($_POST['update_delivery_suburb']),
'delivery_city' => zen_db_prepare_input($_POST['update_delivery_city']),
'delivery_state' => zen_db_prepare_input($_POST['update_delivery_state']),
'delivery_postcode' => zen_db_prepare_input($_POST['update_delivery_postcode']),
'delivery_country' => zen_db_prepare_input($_POST['update_delivery_country']),
'payment_method' => zen_db_prepare_input($_POST['update_info_payment_method']),
'cc_type' => zen_db_prepare_input($_POST['update_info_cc_type']),
'cc_owner' => zen_db_prepare_input($_POST['update_info_cc_owner']),
'cc_expires' => zen_db_prepare_input($_POST['update_info_cc_expires'])
);

[lat9]

For future reference, those "CODE" tags are inserted when you click the big # in the toolbar when you're writing a post. To include code (or large blocks of text), click that # button and then insert your code or text between the CODE and /CODE tags.

When you initially display an order for editing, there's a block at the bottom of the page that you use to change an order's status or add a message to the user. The 'status' field is the dropdown list of order-status values, used when you're changing the status of an order.

When you click that dropdown, what values are shown as possible?

[sungmo]

For future reference, those "CODE" tags are inserted when you click the big # in the toolbar when you're writing a post. To include code (or large blocks of text), click that # button and then insert your code or text between the CODE and /CODE tags.

When you initially display an order for editing, there's a block at the bottom of the page that you use to change an order's status or add a message to the user. The 'status' field is the dropdown list of order-status values, used when you're changing the status of an order.

When you click that dropdown, what values are shown as possible?

thanks...

i can see 4 lists..

Pending [1]
Processing [2]
Sent [3]
Update [4]