From: Joe Hunt Date: Mon, 11 Mar 2013 14:06:43 +0000 (+0100) Subject: Fixed error on edit of a customer payment (certain MySql releases). X-Git-Tag: 2.3-final~297^2 X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=66dfa9cf59409247c48a73257ee840bf58bd3937 Fixed error on edit of a customer payment (certain MySql releases). --- 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");