Bug 4980: The field characters size of "Memo" in voiding a transaction doesn't corres...

[fa-stable.git] / includes / db / audit_trail_db.inc

diff --git a/includes/db/audit_trail_db.inc b/includes/db/audit_trail_db.inc
index feb85a991f744b6ed3facf54fd4fffaff18d7964..c142abdb9fbad020fb1ccaa1e5dce447d15552ce 100644 (file)
--- a/includes/db/audit_trail_db.inc
+++ b/includes/db/audit_trail_db.inc
@@ -12,6 +12,7 @@
 
 function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
 {
+       $descr = substr($descr, 0, 60);
        begin_transaction();
 
        $date = date2sql($trans_date);
@@ -26,7 +27,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);