From fe44bf2e9750f2a6888bc60ae4b35d9e8b0decbb Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 27 Dec 2010 11:41:46 +0000 Subject: [PATCH] [0000380] Database error during direct invoice processing in mysql strict mode. --- sales/includes/db/cust_trans_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sales/includes/db/cust_trans_db.inc b/sales/includes/db/cust_trans_db.inc index 2b3cd451..748fc2a0 100644 --- a/sales/includes/db/cust_trans_db.inc +++ b/sales/includes/db/cust_trans_db.inc @@ -91,7 +91,7 @@ function write_customer_trans($trans_type, $trans_no, $debtor_no, $BranchNo, ".db_escape($Freight).", $FreightTax, $rate, ".db_escape($ship_via).", $AllocAmt, ".db_escape($dimension_id).", ".db_escape($dimension2_id).", " - .db_escape($payment_terms).")"; + .db_escape($payment_terms, true).")"; } else { // may be optional argument should stay unchanged ? $sql = "UPDATE ".TB_PREF."debtor_trans SET debtor_no=".db_escape($debtor_no)." , branch_code=".db_escape($BranchNo).", -- 2.30.2