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