chrometweaks.org

Help with iPage.com domain purchase?

Click Here To View All Answers...


Question I have... Help with iPage.com domain purchase? Hoping for any response. Another question... Ok, i've spent ages searching the forums, and it seems that plenty of people have had my problem before, but no-one has a definitive solution..

No orders are listed when I go into admin -> orders. Typing the correct order ID into the Order ID box and hitting enter brings up the order fine. Orders are being submitted to the database fine. Querying "SELECT * FROM orders;" works fine and all the orders that have been placed show up. The order_status fields for orders are all correct. My orders_status table is fine..

I've tried dropping and creating the orders table again. I've done a diff between the orders.php on the live site, and a development one that I know works on a local machine and it is identical, it's identical to the original as well..

Any ideas?..

Comments (68)

Hmm... I need to find out myself. I don't know what is the right answer. I'll do some Googling and get back to you if I find an decent answer. You should email the people at iPage as they probably could answer your iPage question..

Comment #1

Do you mean admin/orders.php? if so here it is:.

 require('includes/application_top.php');.

 require(DIR_WS_CLASSES'currencies.php');.

 $currencies = new currencies();.

 $orders_statuses = array();.

 $orders_status_array = array();.

 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from "TABLE_ORDERS_STATUS" where language_id = '"(int)$languages_id"'");.

 while ($orders_status = tep_db_fetch_array($orders_status_query)) {.

   $orders_statuses[] = array('id' => $orders_status['orders_status_id'],.

                              'text' => $orders_status['orders_status_name']);.

   $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];.

 }.

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

 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"'");.

         $customer_notified = '0';.

         if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {.

           $notify_comments = '';.

           if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {.

             $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments)"\n\n";.

           }.

           $email = STORE_NAME"\n"EMAIL_SEPARATOR"\n"EMAIL_TEXT_ORDER_NUMBER' '$oID"\n"EMAIL_TEXT_INVOICE_URL' 'tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id='$oID, 'SSL')"\n"EMAIL_TEXT_DATE_ORDERED' 'tep_date_long($check_status['date_purchased'])"\n\n"$notify_commentssprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);.

           tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);.

           $customer_notified = '1';.

         }.

         tep_db_query("insert into "TABLE_ORDERS_STATUS_HISTORY" (orders_id, orders_status_id, date_added, customer_notified, comments) values ('"(int)$oID"', '"tep_db_input($status)"', now(), '"tep_db_input($customer_notified)"', '"tep_db_input($comments)  . "')");.

         $order_updated = true;.

       }.

       if ($order_updated == true) {.

        $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');.

       } else {.

         $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');.

       }.

       tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=edit'));.

       break;.

     case 'deleteconfirm':.

       $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

       tep_remove_order($oID, $HTTP_POST_VARS['restock']);.

       tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));.

       break;.

   }.

 }.

 if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {.

   $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);.

   $orders_query = tep_db_query("select orders_id from "TABLE_ORDERS" where orders_id = '"(int)$oID"'");.

   $order_exists = true;.

   if (!tep_db_num_rows($orders_query)) {.

     $order_exists = false;.

     $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');.

   }.

 }.

 include(DIR_WS_CLASSES'order.php');.

?>.

<!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">.

<script language="javascript" src="includes/general.js"></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">.

<! header //>.

<?php.

 require(DIR_WS_INCLUDES'header.php');.

?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="2" cellpadding="2">.

 <tr>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

   </table></td>.

<! body_text //>.

   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

<?php.

 if (($action == 'edit') && ($order_exists == true)) {.

   $order = new order($oID);.

?>.

     <tr>.

       <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

           <td class="pageHeading" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a>'; ?></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><table width="100%" border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td colspan="3"><?php echo tep_draw_separator(); ?></td>.

         </tr>.

         <tr>.

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

             <tr>.

               <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>.

               <td class="main"><?php echo tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>'); ?></td>.

             </tr>.

             <tr>.

               <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

             </tr>.

             <tr>.

               <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>.

               <td class="main"><?php echo $order->customer['telephone']; ?></td>.

             </tr>.

             <tr>.

               <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>.

               <td class="main"><?php echo '<a href="mailto:'$order->customer['email_address']'"><u>'$order->customer['email_address']'</u></a>'; ?></td>.

             </tr>.

           </table></td>.

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

             <tr>.

               <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>.

               <td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></td>.

             </tr>.

           </table></td>.

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">.

             <tr>.

               <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>.

               <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>.

           <td class="main"><?php echo $order->info['payment_method']; ?></td>.

         </tr>.

<?php.

   if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {.

?>.

         <tr>.

           <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>.

           <td class="main"><?php echo $order->info['cc_type']; ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>.

           <td class="main"><?php echo $order->info['cc_owner']; ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>.

           <td class="main"><?php echo $order->info['cc_number']; ?></td>.

         </tr>.

         <tr>.

           <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>.

           <td class="main"><?php echo $order->info['cc_expires']; ?></td>.

         </tr>.

<?php.

   }.

?>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

         <tr class="dataTableHeadingRow">.

           <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>.

           <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>.

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>.

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>.

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>.

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>.

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>.

         </tr>.

<?php.

   for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {.

     echo '          <tr class="dataTableRow">'"\n" ..

          '            <td class="dataTableContent" valign="top" align="right">'$order->products[$i]['qty']'&nbsp;x</td>'"\n" ..

          '            <td class="dataTableContent" valign="top">'$order->products[$i]['name'];.

     if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {.

       for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {.

         echo '<br><nobr><small>&nbsp;<i> - '$order->products[$i]['attributes'][$j]['option']': '$order->products[$i]['attributes'][$j]['value'];.

         if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' ('$order->products[$i]['attributes'][$j]['prefix']$currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])')';.

         echo '</i></small></nobr>';.

       }.

     }.

     echo '            </td>'"\n" ..

          '            <td class="dataTableContent" valign="top">'$order->products[$i]['model']'</td>'"\n" ..

          '            <td class="dataTableContent" align="right" valign="top">'tep_display_tax_value($order->products[$i]['tax'])'%</td>'"\n" ..

          '            <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '            <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '            <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n" ..

          '            <td class="dataTableContent" align="right" valign="top"><b>'$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value'])'</b></td>'"\n";.

     echo '          </tr>'"\n";.

   }.

?>.

         <tr>.

           <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">.

<?php.

   for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {.

     echo '              <tr>'"\n" ..

          '                <td align="right" class="smallText">'$order->totals[$i]['title']'</td>'"\n" ..

          '                <td align="right" class="smallText">'$order->totals[$i]['text']'</td>'"\n" ..

          '              </tr>'"\n";.

   }.

?>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

     </tr>.

     <tr>.

       <td class="main"><table border="1" cellspacing="0" cellpadding="5">.

         <tr>.

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>.

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>.

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>.

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

         </tr>.

<?php.

   $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments from "TABLE_ORDERS_STATUS_HISTORY" where orders_id = '"tep_db_input($oID)"' order by date_added");.

   if (tep_db_num_rows($orders_history_query)) {.

     while ($orders_history = tep_db_fetch_array($orders_history_query)) {.

       echo '          <tr>'"\n" ..

            '            <td class="smallText" align="center">'tep_datetime_short($orders_history['date_added'])'</td>'"\n" ..

            '            <td class="smallText" align="center">';.

       if ($orders_history['customer_notified'] == '1') {.

         echo tep_image(DIR_WS_ICONS'tick.gif', ICON_TICK)"</td>\n";.

       } else {.

         echo tep_image(DIR_WS_ICONS'cross.gif', ICON_CROSS)"</td>\n";.

       }.

       echo '            <td class="smallText">'$orders_status_array[$orders_history['orders_status_id']]'</td>'"\n" ..

            '            <td class="smallText">'nl2br(tep_db_output($orders_history['comments']))'&nbsp;</td>'"\n" ..

            '          </tr>'"\n";.

     }.

   } else {.

       echo '          <tr>'"\n" ..

            '            <td class="smallText" colspan="5">'TEXT_NO_ORDER_HISTORY'</td>'"\n" ..

            '          </tr>'"\n";.

   }.

?>.

       </table></td>.

     </tr>.

     <tr>.

       <td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>.

     </tr>.

     <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action'))'action=update_order'); ?>.

       <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" cellspacing="0" cellpadding="2">.

         <tr>.

           <td><table border="0" cellspacing="0" cellpadding="2">.

             <tr>.

               <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>.

             </tr>.

             <tr>.

               <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>.

               <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>.

             </tr>.

           </table></td>.

           <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>.

         </tr>.

       </table></td>.

     </form></tr>.

     <tr>.

       <td colspan="2" align="right"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$HTTP_GET_VARS['oID'])'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$HTTP_GET_VARS['oID'])'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')))'">'tep_image_button('button_back.gif', IMAGE_BACK)'</a>'; ?></td>.

     </tr>.

<?php.

 } else {.

?>.

     <tr>.

       <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>.

           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>.

           <td align="right"><table border="0" width="100%" cellspacing="0" cellpadding="0">.

             <tr><?php echo tep_draw_form('orders', FILENAME_ORDERS, '', 'get'); ?>.

               <td class="smallText" align="right"><?php echo HEADING_TITLE_SEARCH' 'tep_draw_input_field('oID', '', 'size="12"')tep_draw_hidden_field('action', 'edit'); ?></td>.

             </form></tr>.

             <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, '', 'get'); ?>.

               <td class="smallText" align="right"><?php echo HEADING_TITLE_STATUS' 'tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td>.

             </form></tr>            .

           </table></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"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>.

               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ORDER_TOTAL; ?></td>.

               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_DATE_PURCHASED; ?></td>.

               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS; ?></td>.

               <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>.

             </tr>.

<?php.

   if (isset($HTTP_GET_VARS['cID'])) {.

     $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

     $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

   } elseif (isset($HTTP_GET_VARS['status'])) {.

     $status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

     $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

   } else {.

     $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by o.orders_id DESC";.

   }.

   $orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);.

   $orders_query = tep_db_query($orders_query_raw);.

   while ($orders = tep_db_fetch_array($orders_query)) {.

   if ((!isset($HTTP_GET_VARS['oID']) || (isset($HTTP_GET_VARS['oID']) && ($HTTP_GET_VARS['oID'] == $orders['orders_id']))) && !isset($oInfo)) {.

       $oInfo = new objectInfo($orders);.

     }.

     if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) {.

       echo '              <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'\'">'"\n";.

     } else {.

       echo '              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'\'">'"\n";.

     }.

?>.

               <td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$orders['orders_id']'&action=edit')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$orders['customers_name']; ?></td>.

               <td class="dataTableContent" align="right"><?php echo strip_tags($orders['order_total']); ?></td>.

               <td class="dataTableContent" align="center"><?php echo tep_datetime_short($orders['date_purchased']); ?></td>.

               <td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>.

               <td class="dataTableContent" align="right"><?php if (isset($oInfo) && is_object($oInfo) && ($orders['orders_id'] == $oInfo->orders_id)) { echo tep_image(DIR_WS_IMAGES'icon_arrow_right.gif', ''); } else { echo '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID'))'oID='$orders['orders_id'])'">'tep_image(DIR_WS_IMAGES'icon_info.gif', IMAGE_ICON_INFO)'</a>'; } ?>&nbsp;</td>.

             </tr>.

<?php.

   }.

?>.

             <tr>.

               <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">.

                 <tr>.

                   <td class="smallText" valign="top"><?php echo $orders_split->display_count($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></td>.

                   <td class="smallText" align="right"><?php echo $orders_split->display_links($orders_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td>.

                 </tr>.

               </table></td>.

             </tr>.

           </table></td>.

<?php.

 $heading = array();.

 $contents = array();.

 switch ($action) {.

   case 'delete':.

     $heading[] = array('text' => '<b>'TEXT_INFO_HEADING_DELETE_ORDER'</b>');.

     $contents = array('form' => tep_draw_form('orders', FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=deleteconfirm'));.

     $contents[] = array('text' => TEXT_INFO_DELETE_INTRO'<br><br><b>'$cInfo->customers_firstname' '$cInfo->customers_lastname'</b>');.

     $contents[] = array('text' => '<br>'tep_draw_checkbox_field('restock')' 'TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);.

     $contents[] = array('align' => 'center', 'text' => '<br>'tep_image_submit('button_delete.gif', IMAGE_DELETE)' <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id)'">'tep_image_button('button_cancel.gif', IMAGE_CANCEL)'</a>');.

     break;.

   default:.

     if (isset($oInfo) && is_object($oInfo)) {.

       $heading[] = array('text' => '<b>['$oInfo->orders_id']&nbsp;&nbsp;'tep_datetime_short($oInfo->date_purchased)'</b>');.

       $contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=edit')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))'oID='$oInfo->orders_id'&action=delete')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a>');.

       $contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_ORDERS_INVOICE, 'oID='$oInfo->orders_id)'" TARGET="_blank">'tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE)'</a> <a href="'tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID='$oInfo->orders_id)'" TARGET="_blank">'tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP)'</a>');.

       $contents[] = array('text' => '<br>'TEXT_DATE_ORDER_CREATED' 'tep_date_short($oInfo->date_purchased));.

       if (tep_not_null($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED' 'tep_date_short($oInfo->last_modified));.

       $contents[] = array('text' => '<br>'TEXT_INFO_PAYMENT_METHOD' '  . $oInfo->payment_method);.

     }.

     break;.

 }.

 if ( (tep_not_null($heading)) && (tep_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>.

<?php.

 }.

?>.

   </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'); ?>..

Comment #2

Hi All,.

I have had this very same problem and have been able to kludge a solution by changing the sql on $orders_query_raw. Somehow, removing the ot.class stuff at the end of the query fixes it. I have not researched much into it but in my application, I don't need the shipping totals, just the product totals. So that worked out okay for me. The original query has been commented out in the next lines. Try substituting this in /admin/orders.php (line 377-393) and see if it works for you..

If (isset($HTTP_GET_VARS['cID'])) {.

     $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);.

//  ORIGINAL    $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and ot.class = 'ot_total' order by orders_id DESC";.

// NEW      .

$orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.customers_id = '"(int)$cID"' and o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' order by orders_id DESC";.

   } elseif (isset($HTTP_GET_VARS['status'])) {.

     $status = tep_db_prepare_input($HTTP_GET_VARS['status']);.

// ORIGINAL      $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' and ot.class = 'ot_total' order by o.orders_id DESC";.

// NEW      .

$orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"' and s.orders_status_id = '"(int)$status"' order by o.orders_id DESC";.

   } else {.

     $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from "TABLE_ORDERS" o left join "TABLE_ORDERS_TOTAL" ot on (o.orders_id = ot.orders_id), "TABLE_ORDERS_STATUS" s where o.orders_status = s.orders_status_id and s.language_id = '"(int)$languages_id"'  order by o.orders_id DESC";.

   }..

Comment #3

Daniel,.

The only other thing I can suggest and you may have probably tried this already. Take that SQL ($orders_query_raw) open mysql query window and run that it. In my case, it was that sql that was the problem. When I did it with the original sql, I found on my database that it didn't return any rows. I then started to edit it until it worked. That's kind of how I narrowed it down..

Hope this helps a little...

Comment #4

Yeah i'd had a play with query but in the end got sick of it. I ended up just re-loading the db from scratch, which interestingly fixed the problem. Seems strange considering it looked as though everything in the db end of things was fine..

Seems a pity I couldn't find exactly what was causing the problem..

Comment #5

I thought I was the only one with thi sproblem... pfff.....

Comment #6

Ok, i've spent ages searching the forums, and it seems that plenty of people have had my problem before, but no-one has a definitive solution..

No orders are listed when I go into admin -> orders. Typing the correct order ID into the Order ID box and hitting enter brings up the order fine. Orders are being submitted to the database fine. Querying "SELECT * FROM orders;" works fine and all the orders that have been placed show up. The order_status fields for orders are all correct. My orders_status table is fine..

I've tried dropping and creating the orders table again. I've done a diff between the orders.php on the live site, and a development one that I know works on a local machine and it is identical, it's identical to the original as well..

Any ideas?..

Comment #7

Daniel,.

Pull a copy of your orders file from the admin and post only the relavant and unsecured information here Ill take a look see and see if I can figure it out.... I have not had this problem ever but have seen it before and sometimes it's just a glitch in something you may have changed in the coding.....

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.