diff options
author | Ted Trask <ttrask01@yahoo.com> | 2013-11-18 19:25:28 +0000 |
---|---|---|
committer | Ted Trask <ttrask01@yahoo.com> | 2013-11-18 19:25:28 +0000 |
commit | a1c6854f74d6226e0e5d4de2820792928d895a68 (patch) | |
tree | 22746ce541c216b0dd2411aff2ae8cad3c82d587 | |
parent | eebbecf938ad35404b32d5cecaf5b3f3232e2514 (diff) | |
download | acf-freeswitch-vmail-a1c6854f74d6226e0e5d4de2820792928d895a68.tar.bz2 acf-freeswitch-vmail-a1c6854f74d6226e0e5d4de2820792928d895a68.tar.xz |
Change sql to use BEGIN rather than START
-rw-r--r-- | vmail-model.lua | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/vmail-model.lua b/vmail-model.lua index 789f20c..bab4484 100644 --- a/vmail-model.lua +++ b/vmail-model.lua @@ -203,7 +203,7 @@ local setuserparams = function(userparams) if #uid == 1 then -- There are a few params not to put in the voicemail_values table local ignoreparam = { username=true, ["vm-password"]=true, ["vm-password-confirm"]=true } - vmaildb.runsqlcommand("START TRANSACTION") + vmaildb.runsqlcommand("BEGIN TRANSACTION") sql = "DELETE FROM voicemail_values"..generatewhereclause(nil, nil, nil, uid[1].uid).." AND nid IN (SELECT nid FROM voicemail_params)" vmaildb.runsqlcommand(sql, true) for i,parm in ipairs(params) do |