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 <rene.klu...@chimit.nl> wrote: > 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/ > > > > > > > >
