This patch should solve the issue. -----Original Message----- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] 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: users-boun...@kannel.org [mailto:users-boun...@kannel.org] 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 sangpr...@gmail.com http://www.petitiononline.com/froyo/
sqlbox_null.patch
Description: Binary data
