From 66dfa9cf59409247c48a73257ee840bf58bd3937 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 11 Mar 2013 15:06:43 +0100 Subject: [PATCH] Fixed error on edit of a customer payment (certain MySql releases). --- 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 52f05b0f..4f92807a 100644 --- a/sales/includes/db/cust_trans_db.inc +++ b/sales/includes/db/cust_trans_db.inc @@ -103,7 +103,7 @@ function write_customer_trans($trans_type, $trans_no, $debtor_no, $BranchNo, ov_freight=".db_escape($Freight).", ov_freight_tax=$FreightTax, rate=$rate, ship_via=".db_escape($ship_via).", alloc=$AllocAmt, dimension_id=".db_escape($dimension_id).", dimension2_id=".db_escape($dimension2_id).", - payment_terms=".db_escape($payment_terms)." + payment_terms=".db_escape($payment_terms, true)." WHERE trans_no=".db_escape($trans_no)." AND type=".db_escape($trans_type); } db_query($sql, "The debtor transaction record could not be inserted"); -- 2.30.2