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 > > > > >
