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 <[email protected]> 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 > [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/ >> >> >> >> >> >> >> >> > > >
