From beb0a3172f74e1b02104e31a79e34a779d9ca011 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Fri, 25 Jan 2019 21:27:35 +0100 Subject: [PATCH 1/1] Additional sql strict mode related fix in add_trans_tax_details(). --- gl/includes/db/gl_db_trans.inc | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc index d7e01aa3..feb17f09 100644 --- a/gl/includes/db/gl_db_trans.inc +++ b/gl/includes/db/gl_db_trans.inc @@ -468,8 +468,10 @@ function add_trans_tax_details($trans_type, $trans_no, $tax_id, $rate, $included (trans_type, trans_no, tran_date, tax_type_id, rate, ex_rate, included_in_price, net_amount, amount, memo, reg_type) VALUES (".db_escape($trans_type)."," . db_escape($trans_no).",'" - .date2sql($tran_date)."',".db_escape($tax_id)."," - .db_escape($rate).",".db_escape($ex_rate).",".($included ? 1:0)."," + .date2sql($tran_date)."'," + .(int)($tax_id)."," + .(float)($rate)."," + .(float)($ex_rate).",".($included ? 1:0)."," .db_escape($net_amount)."," .db_escape($amount).",".db_escape($memo).",".db_escape($reg_type, true).")"; -- 2.30.2