Update Journal Entry SQL query fixed. Strange that it passed the MySql server!

diff --git a/gl/includes/db/gl_journal.inc b/gl/includes/db/gl_journal.inc
index ae32414cf24ae9615179ada6fbb4590a3cb3714c..bb2dc5b90dd76e7ca12ea1b851b8b721f443c1d5 100644 (file)
--- 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');