From dca4242efab883345aa91daa24f737695e975e71 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Tue, 27 Mar 2018 17:22:05 +0200 Subject: [PATCH] Update Journal Entry SQL query fixed. Strange that it passed the MySql server! --- gl/includes/db/gl_journal.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/gl/includes/db/gl_journal.inc b/gl/includes/db/gl_journal.inc index ae32414c..bb2dc5b9 100644 --- a/gl/includes/db/gl_journal.inc +++ b/gl/includes/db/gl_journal.inc @@ -41,7 +41,7 @@ function update_journal($type, $trans_no, $amount, $tran_date, $currency, $refer ."`source_ref`=".db_escape($source_ref)."," ."`tran_date`="."'".date2sql($tran_date)."'," ."`event_date`="."'".date2sql($event_date)."'," - ."`doc_date`="."'".date2sql($doc_date)."') + ."`doc_date`="."'".date2sql($doc_date)."' WHERE `type`=".db_escape($type)." AND " ."`trans_no`=".db_escape($trans_no); return db_query($sql, 'cannot update journal entry'); -- 2.30.2