Hi, excuse my ignorance but i do not know where the devel archives are in the svn (is it something like .../sqlbox/devel?), where do i find the patch and how to apply it. Is it possible to guide me on that? why this patch was not commited into trunk yet? Best regards
Στις 19-11-2010, ημέρα Παρ, και ώρα 07:34 +0700, ο/η Willy Mularto έγραψε: > Rene has the patch for the issue. Please check the devel archives. > > > > > > > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > > > On Nov 19, 2010, at 1:19 AM, Alejandro Guerrieri wrote: > > > > > Hrm, no, that DLR doesn't even include single quotes, that's an > > artifact from the log. > > > > > > > > > > > > > > On Thu, Nov 18, 2010 at 6:51 PM, Peter <p...@locosms.gr> wrote: > > > > Alejandro, > > I send you the requested dump plus typical log files > > > > ... > > > > > > > > Στις 18-11-2010, ημέρα Πεμ, και ώρα 18:31 +0100, ο/η > > Alejandro Guerrieri έγραψε: > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > ____________________________________________________________ > > > > > > 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 > > > > > > > > > ________________________________________________________________________ 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
