Any news on this issue. By the way, inserting into send-sms table url encoded messages is working properly yet. You can see this if you sent a message via
sendsms==>>smsbox==>>sqlbox==>>bearerbox. The message stored in sent-sms table has nothing to do with url encoding. It looks like it is byte encoded. Best regards, Peter Στις 20-11-2010, ημέρα Σαβ, και ώρα 05:28 +0700, ο/η Willy Mularto έγραψε: > Sorry for the late reply, it's midnight here :) Not yet brother, > yesterday I tested with reguler text and found the SQLBox didn't > URL-Encoded the text. I will try to test it out ASAP. > > > > > > > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > > > On Nov 19, 2010, at 6:48 PM, Alejandro Guerrieri wrote: > > > > > It should work fine now, I've tested it :) > > > > > > 2010/11/19 Kenny <ken.bell...@gmail.com> > > > > Alex...that's fantastic. :) > > > > Willy.. have you tested this with wappush? Am going to do > > that presently. > > > > > > > > -- > > Regards > > Kenny > > > > > > > > > > 2010/11/19 Alejandro Guerrieri > > <alejandro.guerri...@gmail.com> > > > > With the latest version, yes. It's mentioned on the > > UPGRADE file: > > > > > > > > ==== > > > > ***** IMPORTANT NOTICE ***** > > > > > > If you're upgrading from a version BEFORE 2010-11-11 > > (0.7.x and > > lower), please note that the format for the msgdata > > and udhdata > > columns is now url-encoded. That probably means that > > if you use > > inserts on send_sms to send MT, YOU WILL NEED TO > > MODIFY YOUR > > CODE TO URLENCODE THE MESSAGES FIRST. > > ==== > > Regards, > > > > > > Alex > > > > > > 2010/11/19 Kenny <ken.bell...@gmail.com> > > > > > > > > > > Alex, Are you saying one has to url-encode > > before passing data into msgdata and > > udhdata? Please confirm. > > > > > > -- > > Regards > > Kenny > > > > > > > > > > 2010/11/19 Alejandro Guerrieri > > <alejandro.guerri...@gmail.com> > > > > > > > > > > Sqlbox now uses url-encode for > > msgdata and udhdata, this shouldn't > > be an issue. > > > > > > > > I'll try to reproduce the error > > locally and let you know what I > > find. > > > > > > Are you using latest sqlbox and > > kannel? > > > > > > Regards, > > > > > > Alex > > > > > > > > > > > > On Fri, Nov 19, 2010 at 11:24 AM, > > Peter <p...@locosms.gr> wrote: > > > > > > Willie. > > > > Thank u, > > the patch is not commited > > I tested with the patch but > > still get > > > > 2010-11-19 12:19:47 [14060] > > [3] DEBUG: > > smsbox_to_bearerbox: sms > > received > > 2010-11-19 12:19:48 [14060] > > [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:1365419169 sub:001 > > dlvrd:001 submit > > date:1011191020 done > > date:1011191020 sta' at line > > 1 > > 2010-11-19 12:19:50 [14060] > > [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:1365419169 sub:001 > > dlvrd:001 submit > > date:1011191120 done > > date:1011191020 sta' at line > > 1 > > > > ... > > > > Alejandro can you comment on > > that? > > > > Is there a way out. > > > > Στις 19-11-2010, ημέρα Παρ, > > και ώρα 17:05 +0700, ο/η > > Willy Mularto έγραψε: > > > > > static Octstr > > > > > *get_string_value_or_return_null(Octstr *str) { static Octstr *nul = NULL; > > > if (str == NULL) { > > > return > > > octstr_create("NULL"); } > > if (octstr_compare(str, octstr_imm("")) == 0) { return > > octstr_create("NULL"); } octstr_replace(str, octstr_imm("\\"), > > octstr_imm("\\\\")); octstr_replace(str, octstr_imm("\'"), > > octstr_imm("\\\'")); if (NULL == nul) { nul = octstr_create(""); > > octstr_append_char(nul, 0x00); } octstr_replace(str, nul, > > octstr_imm("\0")); return octstr_format("\'%S\'", str); } > > > > > > > ____________________________ > > > > > > 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
