Does it also encode normal text messages? Because those are the case, here.
== Rene From: Alejandro Guerrieri [mailto:[email protected]] Sent: Friday, 12 November, 2010 14:06 To: Rene Kluwen Cc: Willy Mularto; Kannel Users Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug Can you try the latest revision? We applied a patch yesterday that url-encodes msgdata and udhdata, I guess it should fix this issue as well. Regards, Alex On Fri, Nov 12, 2010 at 1:52 PM, Rene Kluwen <[email protected]> wrote: This patch should solve the issue. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rene Kluwen Sent: Friday, 12 November, 2010 13:45 To: 'Willy Mularto'; 'Kannel Users' Subject: RE: SQLBox INSERT INTO MySQL Bug It's not the ' character that is not escaped. Probably you are getting a '\x00' byte in your delivery receipt. I had the same issue with a client. == Rene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Willy Mularto Sent: Friday, 12 November, 2010 02:00 To: Kannel Users Subject: SQLBox INSERT INTO MySQL Bug I found some errors in the log like this "ERROR: MYSQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id:1127445986 sub:001 dlvrd:001 submit date:1011120752 done date:1011120752 sta' at line 1" I think SQLBox failed to escape the ' character when inserting new row. Is there any patch against this error? Thanks. sangprabv [email protected] http://www.petitiononline.com/froyo/
