Unwanted characters showing up in Comments section of Admin - Orders

[lat9]

Right, I misspoke regarding the extra backslashes in the data. What you should be seeing in the comments field is:

Joe,

Have received your payment, thank you. The TEST ITEM will be shipping out tomorrow. The tracking number is sdfgskldfjsdlkfjsdlkfjsd654684.

Look forward to doing more business.

Thanks, Ted

where those \r\n sequences were converted to their CRLF equivalents.

I'm pretty sure that it's the edit_orders processing, as the built-in orders.php handling performs the database insert "directly" (i.e. using the $db->Execute function) while edit_orders uses the zen_db_perform function.

You might try editing your copy of edit_orders.php, changing this block:

      $sql_data_array = array(
        'orders_id' => (int)$oID,
        'orders_status_id' => zen_db_input($status),
        'date_added' => 'now()',
        'customer_notified' => zen_db_input($customer_notified),
        'comments' => zen_db_input($comments),
      );
      // BEGIN TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
      foreach($track_id as $id => $track) {
        $sql_data_array['track_id' . $id] = zen_db_input($track);
      }
      unset($id); unset($track);
      // END TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
      zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

removing the calls to zen_db_input, as follows:

      $sql_data_array = array(
        'orders_id' => (int)$oID,
        'orders_status_id' => $status,
        'date_added' => 'now()',
        'customer_notified' => $customer_notified,
        'comments' => $comments,
      );
      // BEGIN TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
      foreach($track_id as $id => $track) {
        $sql_data_array['track_id' . $id] = $track;
      }
      unset($id); unset($track);
      // END TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
      zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

[Ted Grapler]

Changing the code in ADMIN/edit_orders.php as suggested has solved the problem.

Just made a donation to the Zen Cart team in appreciation for all the help I have gotten on the forum for several issues from lat9, MC12345678, kobra, Dr. Byte, picaflor-azul, and others.

Thanks and please keep up the good work.

[swguy]

It seems as though after applying this fix, multiline comments now contain embedded HTML break characters:

**Test remark 1<br />Test remark 2<br />Test remark 3