Will play with it tonight and hope those errors disapear and hopefully no need to use sendsms to send wap push anymore. Many thanks to Alex, Rene and all Kannel project+addons developers.
sangprabv [email protected] http://www.petitiononline.com/froyo/ On Nov 12, 2010, at 9:03 PM, Alejandro Guerrieri wrote: > Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when > reading. > > It also allows wap pushes to work btw. > > Regards, > > Alex > > On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen <[email protected]> wrote: > 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/ > > > > > > > > >
