[Freeswitch-users] Strange error message

[Nik Middleton]

So what you're saying is that I can comment out curs:close()  as it's
not needed?

 

Regards,

 

 

 

________________________________

From: freeswitch-users-bounces at lists.freeswitch.org
[mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of
Chris
Sent: 10 February 2009 21:19
To: freeswitch-users at 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 at noblesolutions.co.uk>
wrote:

	From: Nik Middleton <nik.middleton at noblesolutions.co.uk>
	Subject: [Freeswitch-users] Strange error message
	To: freeswitch-users at 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 at 192.168.3.206) Ended

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090210/cb925ccd/attachment-0002.html