summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorTed Trask <ttrask01@yahoo.com>2013-11-18 19:25:28 +0000
committerTed Trask <ttrask01@yahoo.com>2013-11-18 19:25:28 +0000
commita1c6854f74d6226e0e5d4de2820792928d895a68 (patch)
tree22746ce541c216b0dd2411aff2ae8cad3c82d587
parenteebbecf938ad35404b32d5cecaf5b3f3232e2514 (diff)
downloadacf-freeswitch-vmail-a1c6854f74d6226e0e5d4de2820792928d895a68.tar.bz2
acf-freeswitch-vmail-a1c6854f74d6226e0e5d4de2820792928d895a68.tar.xz
Change sql to use BEGIN rather than START
-rw-r--r--vmail-model.lua2
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