From a1c6854f74d6226e0e5d4de2820792928d895a68 Mon Sep 17 00:00:00 2001 From: Ted Trask Date: Mon, 18 Nov 2013 19:25:28 +0000 Subject: Change sql to use BEGIN rather than START --- vmail-model.lua | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'vmail-model.lua') 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 -- cgit v1.2.3