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