Custom code is not working in 1.5.5e

[Prabu]

Hi all

I'm using following code to store and manage ems information in database in order details page. So my admin/order.php file contains following custom code,. Its working good in my ZC1.3.9h live site. But this same code is not working in my new upgraded 1.5.5e website. It shows white page when i click "Update" button on order detail page. I guessed some order variable formats are changed in 1.5.5e. Please help

// Justin 20111229 Code to update kuroobiya db with extra order info
// Start KUROOBIYA ORDER INFO --------------------------------------------------------

     if (isset($_POST['update_costs']) && ($_POST['update_costs'] == 'on')) {
          
             $order_check = $db->Execute("select orders_id from "
                                         . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                         " where orders_id = '" . zen_db_input($oID) . "'");
             if ($order_check->RecordCount() > 0) {    
                 $order_info_sql = "UPDATE " . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                 " SET orders_status_id = '" . zen_db_input($status) .  "', " .
                                 "date_added = now(), " .
                                 "ems_cost = '" . zen_db_input($ems_cost) .  "', " .
                                 "manuf_denpyo = '" . zen_db_input($manuf_denpyo) .  "', " .
                                 "manuf_cost = '" . zen_db_input($manuf_cost) .  "', " .
                                 "manuf_shipping = '" . zen_db_input($manuf_shipping) .  "', " .
                                 "manuf_tax = '" . zen_db_input($manuf_tax) .  "' " .
                                 "WHERE orders_id = '" . zen_db_input($oID) . "'";     
             }else{
                      $order_info_sql = "insert into " . TABLE_ORDERS_KUROOBIYA_EXTRA . "
                              (orders_id, orders_status_id, date_added, ems_cost, manuf_denpyo, manuf_cost, manuf_shipping, manuf_tax)
                              values ('" . (int)$oID . "',
                              '" . zen_db_input($status) . "',
                              now(),
                              '" . zen_db_input($ems_cost) . "',
                              '" . zen_db_input($manuf_denpyo)  . "',
                              '" . zen_db_input($manuf_cost)  . "',
                              '" . zen_db_input($manuf_shipping)  . "',
                              '" . zen_db_input($manuf_tax)  . "')";
             }
             $db->Execute($order_info_sql);
        }
        
//END Kuroobiya Extra Order Info ..........................................    

// KUROOBIYA ORDER INFO BEGIN, INCLUDE DATABASE FIELDS ------------------------------
$order_info = $db->Execute("select orders_id, orders_status_id, date_added, ems_cost, manuf_denpyo, manuf_cost, manuf_shipping, manuf_tax
                                    from "
                                 . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                 " where orders_id = '" . zen_db_input($oID) . 
                                 "' order by date_added");
 if ($order_info->RecordCount() > 0) {                                 
    $ems_cost = (empty($order_info->fields['ems_cost']) ? '' : $order_info->fields['ems_cost'] );
    $manuf_denpyo = (empty($order_info->fields['manuf_denpyo']) ? '' : $order_info->fields['manuf_denpyo'] );
    $manuf_cost = (empty($order_info->fields['manuf_cost']) ? '' : $order_info->fields['manuf_cost'] );
    $manuf_shipping = (empty($order_info->fields['manuf_shipping']) ? '' : $order_info->fields['manuf_shipping'] );
    $manuf_tax = (empty($order_info->fields['manuf_tax']) ? '' : $order_info->fields['manuf_tax'] );
 }
 
// END KUROOBIYA ORDER INFO-----------------------------------------------------------      

<!-- START KUROOBIYA- EXTRA TRACKING INFORMATION -->
<tr><td>
      <table width="100%" border="1" cellspacing="0" cellpadding="3">
         <tr>
             <td class="main" colspan=5><strong>order_info</strong></td>
           </tr>
           <tr>
             <td valign="top" >ems_cost: <?php echo zen_draw_input_field('ems_cost',$ems_cost ); ?></td>
             <td valign="top" >manuf_denpyo: <?php echo zen_draw_input_field('manuf_denpyo',$manuf_denpyo ); ?></td>
             <td valign="top" >manuf_cost: <?php echo zen_draw_input_field('manuf_cost',$manuf_cost ); ?></td>
             <td valign="top" >manuf_ship: <?php echo zen_draw_input_field('manuf_shipping',$manuf_shipping ); ?></td>
             <td valign="top" >manuf_tax: <?php echo zen_draw_input_field('manuf_tax',$manuf_tax ); ?></td>
           </tr>
           </table>
</td></tr>
           
<!-- END KUROOBIYA- EXTRA TRACKING INFORMATION -->

[lat9]

A "white page" implies that there's a myDEBUG-adm-*.log file waiting in your store's /logs directory to let you know what the issue is.

If you post the contents, remember that the myDEBUG-adm-*.log files contain references to your Zen Cart admin directory's name, so be sure to xxx-out those names!

[mc12345678]

When provided/confronted with a white page or partial white page, the following FAQ is very helpful: http://www.zen-cart.com/content.php?124-blank-page

[DrByte]

You've got mixed PHP and HTML, but haven't told it to transition between the two.

Add ?> here:

// END KUROOBIYA ORDER INFO-----------------------------------------------------------      
?>
<!-- START KUROOBIYA- EXTRA TRACKING INFORMATION -->

[Prabu]

Hi All

Thanks for your suggestions.

I've fixed whitepage issue to changed zen_db_scrub_in to zen_db_prepare_input using this thread in admin/orders.php.

https://www.zen-cart.com/printthread...&pp=10&page=47

But still i cant make it work following code to update and retrieve custom data from table in admin/orders.php

<?php          
          // KUROOBIYA ORDER INFO BEGIN, INCLUDE DATABASE FIELDS ------------------------------
$order_info = $db->Execute("select orders_id, orders_status_id, date_added, ems_cost, manuf_denpyo, manuf_cost, manuf_shipping, manuf_tax
                                    from "
                                 . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                 " where orders_id = '" . zen_db_input($oID) . 
                                 "' order by date_added");
 if ($order_info->RecordCount() > 0) {                                 
    $ems_cost = (empty($order_info->fields['ems_cost']) ? '' : $order_info->fields['ems_cost'] );
    $manuf_denpyo = (empty($order_info->fields['manuf_denpyo']) ? '' : $order_info->fields['manuf_denpyo'] );
    $manuf_cost = (empty($order_info->fields['manuf_cost']) ? '' : $order_info->fields['manuf_cost'] );
    $manuf_shipping = (empty($order_info->fields['manuf_shipping']) ? '' : $order_info->fields['manuf_shipping'] );
    $manuf_tax = (empty($order_info->fields['manuf_tax']) ? '' : $order_info->fields['manuf_tax'] );
 }
 
 
// END KUROOBIYA ORDER INFO-----------------------------------------------------------      
 ?>   

<!-- START KUROOBIYA- EXTRA TRACKING INFORMATION -->
<tr><td>
      <table width="100%" border="1" cellspacing="0" cellpadding="3">
         <tr>
             <td class="main" colspan=5><strong>order_info</strong></td>
           </tr>
           <tr>
             <td valign="top" >ems_cost: <?php echo zen_draw_input_field('ems_cost',$ems_cost ); ?></td>
             <td valign="top" >manuf_denpyo: <?php echo zen_draw_input_field('manuf_denpyo',$manuf_denpyo ); ?></td>
             <td valign="top" >manuf_cost: <?php echo zen_draw_input_field('manuf_cost',$manuf_cost ); ?></td>
             <td valign="top" >manuf_ship: <?php echo zen_draw_input_field('manuf_shipping',$manuf_shipping ); ?></td>
             <td valign="top" >manuf_tax: <?php echo zen_draw_input_field('manuf_tax',$manuf_tax ); ?></td>
           </tr>
           </table>
</td></tr>
           
<!-- END KUROOBIYA- EXTRA TRACKING INFORMATION -->

<?php
// KUROOBIYA ORDER INFO  BEGIN, DEFINE VALUES  Justin 20111229-------------------------------------
        $ems_cost = str_replace(" ", "", zen_db_prepare_input($_POST['ems_cost']));
        $manuf_denpyo = str_replace(" ", "", zen_db_prepare_input($_POST['manuf_denpyo']));
        $manuf_cost = str_replace(" ", "", zen_db_prepare_input($_POST['manuf_cost']));
        $manuf_shipping = str_replace(" ", "", zen_db_prepare_input($_POST['manuf_shipping']));
        $manuf_tax = str_replace(" ", "", zen_db_prepare_input($_POST['manuf_tax']));        
// END KUROOBIYA ORDER INFO --------------------------------------------------------
// Justin 20111229 Code to update kuroobiya db with extra order info
// Start KUROOBIYA ORDER INFO --------------------------------------------------------

     if (isset($_POST['update_costs']) && ($_POST['update_costs'] == 'on')) {
          
             $order_check = $db->Execute("select orders_id from "
                                         . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                         " where orders_id = '" . zen_db_input($oID) . "'");
             if ($order_check->RecordCount() > 0) {    
                 $order_info_sql = "UPDATE " . TABLE_ORDERS_KUROOBIYA_EXTRA . 
                                 " SET orders_status_id = '" . zen_db_input($status) .  "', " .
                                 "date_added = now(), " .
                                 "ems_cost = '" . zen_db_input($ems_cost) .  "', " .
                                 "manuf_denpyo = '" . zen_db_input($manuf_denpyo) .  "', " .
                                 "manuf_cost = '" . zen_db_input($manuf_cost) .  "', " .
                                 "manuf_shipping = '" . zen_db_input($manuf_shipping) .  "', " .
                                 "manuf_tax = '" . zen_db_input($manuf_tax) .  "' " .
                                 "WHERE orders_id = '" . zen_db_input($oID) . "'";     
             }else{
                      $order_info_sql = "insert into " . TABLE_ORDERS_KUROOBIYA_EXTRA . "
                              (orders_id, orders_status_id, date_added, ems_cost, manuf_denpyo, manuf_cost, manuf_shipping, manuf_tax)
                              values ('" . (int)$oID . "',
                              '" . zen_db_input($status) . "',
                              now(),
                              '" . zen_db_input($ems_cost) . "',
                              '" . zen_db_input($manuf_denpyo)  . "',
                              '" . zen_db_input($manuf_cost)  . "',
                              '" . zen_db_input($manuf_shipping)  . "',
                              '" . zen_db_input($manuf_tax)  . "')";
             }
             $db->Execute($order_info_sql);
        }
        
//END Kuroobiya Extra Order Info ..........................................    */
?>

Please any one. What is wrong with this code and queries? Same code is working good in my old ZC1.3.9h website

[DrByte]

From looking at ONLY the code snippets you quoted, there doesn't appear to be anything wrong with them.

But if you're still getting a "blank white page", then there *are* some critical PHP errors happening. They'll be recorded in the server's /logs/ directory. Read them to get more information about what to fix. Ref: http://www.zen-cart.com/content.php?124-blank-page

[Prabu]

From looking at ONLY the code snippets you quoted, there doesn't appear to be anything wrong with them.

But if you're still getting a "blank white page", then there *are* some critical PHP errors happening. They'll be recorded in the server's /logs/ directory. Read them to get more information about what to fix. Ref: http://www.zen-cart.com/content.php?124-blank-page

Hi

I've fixed white page issue. No issues. But i'm wondering even Select query is not working to retrieve the values from database. I guessed its something went wrong in my Sql queries.