new orders disappearing - need help

[rob_illinois]

   I have been having orders disappear on me from time to time. They show up once placed in the admin area no problem, then I go to send an update to the person and check the shipped box. When it updates they order is gone from the admin view. I have to go into the sql db "through phpadmin" and find the order which is at a 0 for status, and not a 1 or 2. Once I update it here to a 1, it shows up again in the admin panel for orders. Ideas on what is going on and how to fix this issue?

 

Thanks

[Bob Terveuren]

Hi there

 

If you look at the orders.php file in your admin folder you'll see (near the top) a chunk of code like:

if (tep_not_null($action)) {
    switch ($action) {
      case 'update_order':
        $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
        $status = tep_db_prepare_input($HTTP_POST_VARS['status']);
        $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);

        $order_updated = false;
        $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");
        $check_status = tep_db_fetch_array($check_status_query);

        if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {
          tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");

there's a line in there  $status = tep_db_prepare_input($HTTP_POST_VARS['status']);

 

your first port of call is to check if the POST value for status holds anything - you can do this via the Developers Tools in most browsers.

 

If there is nothing in there then that's your problem

[BrockleyJohn]

I have an easy workaround for this issue which I've implemented for a couple of people on osc2.2.

 

It seems that occasionally the order status update fails half way through (I suspect there's some iffy error-handling somewhere but never got round to digging for it).

 

In phpmyadmin create an entry in the orders_status table with id 0 and name 'status error - needs manual reset' (or some other text you prefer).

 

This makes sure the order is still displayed and you can just change it in admin/orders.php

[auzStar]

@@rob_illinois

 

Maybe be related to this: http://www.oscommerce.com/forums/topic/399733-modifying-table-orders-status-orders-status-history/