It's probably an issue with single quotes on dlr text. Can you provide a full pdu dump for the DLR?
Regards, Alex On Thu, Nov 18, 2010 at 6:21 PM, Peter <p...@locosms.gr> wrote: > Dear friends, > > I found that in the last patch still reproduces > > 2010-11-18 18:29:01 [10182] [3] DEBUG: smsbox_to_bearerbox: sms received > 2010-11-18 18:29:01 [10182] [4] 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:1219071490 sub:001 dlvrd:001 submit > date:1011181629 done date:1011181629 sta' at line 1 > 2010-11-18 18:29:09 [10182] [4] 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:1219071490 sub:001 dlvrd:001 submit > date:1011181729 done date:1011181629 sta' at line 1 > > Can you verify that this is a problem of null (or something else?). > > In this case dlrs are received by our application using > smssend ==>> smsbox ==>>sqlbox==>>bearer box > > but records are not inserted in mysql sent-sms table. > > Please check. > Best regards > Peter Kontopoulos > > Στις 14-11-2010, ημέρα Κυρ, και ώρα 19:45 +0700, ο/η Willy Mularto έγραψε: > > 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/ > > > > > > > > > > > > > > > > > > > > > ------------------------------ > > > *Dr. Peter Kontopoulos* > CTO > > *LOCOTEL SA* > 2, Parnassou St. > 10561 Athens, GREECE > *T:* +30 210 3258 350 *F:* +30 210 3258 359 > www.locotel.gr & www.locosms.gr > ------------------------------ > > > Email Disclaimer > The information in this email is confidential and is intended solely for > the addressee(s). If you have received this transmission in error, and you > are not an intended recipient, be aware that any disclosure, copying, > distribution or use of this transmission or its contents is prohibited. > Furthermore, you are kindly requested to send us back the original message > at the address portmas...@locotel.gr, and delete the message from your > system immediately. > Internet communications are not secure and therefore LOCOTEL SA does not > accept legal responsibility for the contents of this message and for any > damage whatsoever that is caused by viruses being passed. Any views or > opinions presented are solely those of the author and do not necessarily > represent those of LOCOTEL SA. > Thank you, > LOCOTEL SA > *Think Before you Print* >
