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 6aa91d9833689c0fdfd4db3a70f2f653f747ab08..c142abdb9fbad020fb1ccaa1e5dce447d15552ce 100644 (file)
--- a/includes/db/audit_trail_db.inc
+++ b/includes/db/audit_trail_db.inc
@@ -12,14 +12,15 @@
 
 function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
 {
+       $descr = substr($descr, 0, 60);
        begin_transaction();
 
        $date = date2sql($trans_date);
        $sql = "INSERT INTO ".TB_PREF."audit_trail"
-               . " (type, trans_no, user, gl_date, description)
+               . " (type, trans_no, user, gl_date, description, stamp)
                        VALUES(".db_escape($trans_type).", ".db_escape($trans_no).","
                        . $_SESSION["wa_current_user"]->user . ","
-                       . "'$date',". db_escape($descr). ")";
+                       . "'$date',". db_escape($descr). ", CURRENT_TIMESTAMP)";
 
        db_query($sql, "Cannot add audit info");
        // all audit records beside just inserted one should have gl_seq set to NULL