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