So what you're saying is that I can comment out curs:close() as it's not needed? Regards, ________________________________ From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Chris Sent: 10 February 2009 21:19 To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Strange error message Closing the connection will force the server to close any open transactions, as well as release recordsets in local memory that reference the connection. However curs is not a recordset. An SQL update is going to return an integer (rows affected) or boolean depending on the which server you use since no recordset is actually requested. --- On Tue, 2/10/09, Nik Middleton <nik.middleton@noblesolutions.co.uk> wrote: From: Nik Middleton <nik.middleton@noblesolutions.co.uk> Subject: [Freeswitch-users] Strange error message To: freeswitch-users@lists.freeswitch.org Date: Tuesday, February 10, 2009, 2:04 PM Hi Guys, I'm baffled by this error. I'm updating the db on call hang-up If I comment out curs:close() no error, but I'm concerned about memory leaks. Can anyone tell me what FS is complaining about? The db gets updated in both cases Regards require "luasql.mysql" function myHangupHook(s, status, arg) freeswitch.consoleLog("info", " : They hung up on US!!!\n"); env = assert (luasql.mysql()) con = assert (env:connect("xxxxl","xxxxxxxxx","pass","192.168.3.205")) curs = assert (con:execute"UPDATE callers SET lastcall = 'BOB' WHERE id = 33292") curs:close() con:close() env:close() freeswitch.consoleLog("NOTICE", "myHangupHook: " .. status .. "\n"); --error() end 2009-02-10 20:53:20 [INFO] switch_cpp.cpp:1086 console_log() : They hung up on US!!! 2009-02-10 20:53:20 [ERR] mod_lua.cpp:176 lua_parse_and_execute() /usr/local/freeswitch/scripts/helloworld.lua:50: attempt to index global 'curs' (a number value) stack traceback: /usr/local/freeswitch/scripts/helloworld.lua:50: in function </usr/local/freeswitch/scripts/helloworld.lua:45> [C]: in function 'hangup' /usr/local/freeswitch/scripts/helloworld.lua:70: in main chunk 2009-02-10 20:53:20 [NOTICE] switch_core_session.c:957 switch_core_session_thread() Session 63 (sofia/internal/1001@192.168.3.206) Ended _______________________________________________ Freeswitch-users mailing list Freeswitch-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org