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
