WARNING: Missing Shipping Information (& all other account history info)

[MyGreyGoose]

None of the order info in my account_history_info, order_status, and tracker pages are showing up, e.g., the order's products, totals, addresses, etc. The order status history IS showing up, though. What could be causing this? The code below is an example of where it's not coming up, i.e., the WARNING: Missing Shipping Information appears b/c $order->info['shipping_method']) must be null.

From tpl_account_history_info_default.php:

<?php
    if (zen_not_null($order->info['shipping_method'])) {
?>
<h4><?php echo HEADING_SHIPPING_METHOD; ?></h4>
<div><?php echo $order->info['shipping_method']; ?></div>
<?php } else { // temporary just remove these 4 lines ?>
<div>WARNING: Missing Shipping Information</div>
<?php
    }
?>

Other stuff that does not show up:

<div id="myAccountPaymentInfo" class="floatingBox forward">
<h3><?php echo HEADING_BILLING_ADDRESS; ?></h3>
<address><?php echo zen_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br />'); ?></address>

<h4><?php echo HEADING_PAYMENT_METHOD; ?></h4>
<div><?php echo $order->info['payment_method']; ?></div>
</div>
<br class="clearBoth" />
</div>

and

 <?php
  for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
  ?>
    <tr>
        <td class="accountQuantityDisplay"><?php echo  $order->products[$i]['qty'] . QUANTITY_SUFFIX; ?></td>
        <td class="accountProductDisplay"><?php echo  $order->products[$i]['name'];

    if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
      echo '<ul id="orderAttribsList">';
      for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
        echo '<li>' . $order->products[$i]['attributes'][$j]['option'] . TEXT_OPTION_DIVIDER . nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value'])) . '</li>';
      }
        echo '</ul>';
    }
?>
        </td>

[MyGreyGoose]

Anyone? Any thoughts, no matter how random?

[DrByte]

It would seem that you're missing important information from the "orders" table, and maybe also the "orders_products" and "orders_products_attributes" tables as well.
Several tables are involved in the storage of order data: http://www.zen-cart.com/wiki/index.p...#Order_History


You've only mentioned what the storefront is showing, and haven't mentioned what the admin side shows.

Also, when did this start happening? How does that relate to other events performed by the store administrator? installation of mods/addons? server database issues? attempted database backup/restores by administrators? etc

If you load up a backup of your database data into another temporary database, do you see the same thing?
How far back does the missing data go?

Is this affecting just one order or many? How many?
Has it ever worked right? What happened since then?
What addons are installed?
What version of Zen Cart?
What version of PHP and MySQL?

Is any product data affected? or just order history?
Has anybody been playing with importing and exporting data but perhaps shouldn't have?