projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added mysql query retry after database deadlock detection.
[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 c25fdc5111526228c42f858afa8ed8756123b524..c341a2f0d283c6ee171e4b177c414c9a647d07ff 100644
(file)
--- a/
includes/db/audit_trail_db.inc
+++ b/
includes/db/audit_trail_db.inc
@@
-12,6
+12,8
@@
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
{
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
{
+ begin_transaction();
+
$date = date2sql($trans_date);
$sql = "INSERT INTO ".TB_PREF."audit_trail"
. " (type, trans_no, user, gl_date, description)
$date = date2sql($trans_date);
$sql = "INSERT INTO ".TB_PREF."audit_trail"
. " (type, trans_no, user, gl_date, description)
@@
-29,6
+31,7
@@
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
. db_escape($trans_no);
db_query($sql, "Cannot update audit gl_seq");
. db_escape($trans_no);
db_query($sql, "Cannot update audit gl_seq");
+ commit_transaction();
}
function get_audit_trail_all($trans_type, $trans_no)
}
function get_audit_trail_all($trans_type, $trans_no)
@@
-126,4
+129,3
@@
function is_closed_trans($type, $trans_no) {
return db_num_rows($res);
}
return db_num_rows($res);
}
-?>