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