I have used the latest SVN to work with Kannel early 2009 CVS version (1 version before 1.4.3 was released). I found it still reproduce my previous error. I think I need to use the same Kannel SVN as well. So I re apply patch from Rene :)
sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Nov 12, 2010, at 9:46 PM, Alejandro Guerrieri wrote: > Sure, let me give you a couple of hints: > > * url-encode msgdata and udhdata, for example: > > udh = %06%05%04%0B%84%23%F0 > msgdata = %1B%06%01%AE%02%05%6A... > > * You'll probably need to set alt_dcs = 1 > > Hope it helps, > > Alex > > On Fri, Nov 12, 2010 at 3:13 PM, Willy Mularto <sangpr...@gmail.com> wrote: > 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 > sangpr...@gmail.com > 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 <rene.klu...@chimit.nl> wrote: >> Does it also encode normal text messages? Because those are the case, here. >> >> >> == Rene >> >> >> From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] >> 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 <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/ >> >> >> >> >> >> >> >> >> > >
