From 24249d8ad52650e78e342a114d67f048efb9aed4 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 3 Jul 2019 11:51:16 +0200 Subject: [PATCH] Audit Trail: regression in audit history (after sql strict mode related changes) fixed. --- includes/db/audit_trail_db.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc index feb85a99..2714448e 100644 --- a/includes/db/audit_trail_db.inc +++ b/includes/db/audit_trail_db.inc @@ -26,7 +26,7 @@ function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='') // to avoid need for subqueries (not existing in MySQL 3) all over the code $sql = "UPDATE ".TB_PREF."audit_trail audit LEFT JOIN ".TB_PREF."fiscal_year year ON year.begin<='$date' AND year.end>='$date' SET audit.gl_seq = IF(audit.id=".db_insert_id().", 0, NULL)," - ."audit.fiscal_year=year.id, stamp=CURRENT_TIMESTAMP" + ."audit.fiscal_year=year.id" . " WHERE type=".db_escape($trans_type)." AND trans_no=" . db_escape($trans_no); -- 2.30.2