Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-22 Thread Peter
Any news on this issue. By the way, inserting into send-sms table url encoded messages is working properly yet. You can see this if you sent a message via sendsms==>>smsbox==>>sqlbox==>>bearerbox. The message stored in sent-sms table has nothing to do with url encoding. It looks like it is b

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Willy Mularto
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 G

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Alejandro Guerrieri
It should work fine now, I've tested it :) 2010/11/19 Kenny > Alex...that's fantastic. :) > > Willy.. have you tested this with wappush? Am going to do that presently. > > -- > Regards > Kenny > > > > 2010/11/19 Alejandro Guerrieri > >> With the latest version, yes. It's mentioned on the UPGRAD

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Kenny
Alex...that's fantastic. :) Willy.. have you tested this with wappush? Am going to do that presently. -- Regards Kenny 2010/11/19 Alejandro Guerrieri > With the latest version, yes. It's mentioned on the UPGRADE file: > > > * IMPORTANT NOTICE * > > If you're upgrading from a ver

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Alejandro Guerrieri
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 inser

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Kenny
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 > 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

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Alejandro Guerrieri
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 wrote: > > Willie. > > Thank u, > the patch is n

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Peter
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 v

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Willy Mularto
.. >>>>>> >>>>>> >>>>>> * You'll probably need to set alt_dcs = 1 >>>>>> >>>>>> >>>>>> Hope it helps, >>>>>> >>>>>> >>>>>> Alex

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-19 Thread Peter
> > > > > > >

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-18 Thread Willy Mularto
Alex, Rene >>>> and all Kannel project+addons developers. >>>> >>>> >>>> >>>> >>>> >>>> >>>> sangprabv >>>> sangpr...@gmail.com >>>> http://www.petitiononline.com/froyo/ >>

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-18 Thread Alejandro Guerrieri
12, 2010, at 9:03 PM, Alejandro Guerrieri wrote: > > Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when > reading. > > > It also allows wap pushes to work btw. > > > Regards, > > > Alex > > On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwe

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-18 Thread Alejandro Guerrieri
errieri wrote: > > > Yes, it url-encodes msgdata and udhdata when saving, and url-decodes when > reading. > > > > It also allows wap pushes to work btw. > > > > Regards, > > > > Alex > > On Fri, Nov 12, 2010 at 2:59 PM, Rene Kluwen > wrote: >

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-18 Thread Peter
> > > > > > > > > > > Regards, > > > > > > > > > > > > > > > Alex &g

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-14 Thread Willy Mularto
>> == Rene >> >> >> From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] >> Sent: Friday, 12 November, 2010 14:06 >> To: Rene Kluwen >> Cc: Willy Mularto; Kannel Users >> Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug >> >

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Alejandro Guerrieri
> >> Does it also encode normal text messages? Because those are the case, >> here. >> >> >> == Rene >> >> >> *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] >> *Sent:* Friday, 12 November, 2010 14:06 >> *To:* Rene Kluwen

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Willy Mularto
t messages? Because those are the case, here. > > > == Rene > > > From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] > Sent: Friday, 12 November, 2010 14:06 > To: Rene Kluwen > Cc: Willy Mularto; Kannel Users > Subject: Re: [PATCH] RE: SQLBox INS

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Alejandro Guerrieri
t; > == Rene > > > > *From:* Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] > *Sent:* Friday, 12 November, 2010 14:06 > *To:* Rene Kluwen > *Cc:* Willy Mularto; Kannel Users > *Subject:* Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug > > > > Can you try the

RE: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Rene Kluwen
Does it also encode normal text messages? Because those are the case, here. == Rene From: Alejandro Guerrieri [mailto:alejandro.guerri...@gmail.com] Sent: Friday, 12 November, 2010 14:06 To: Rene Kluwen Cc: Willy Mularto; Kannel Users Subject: Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

Re: [PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Alejandro Guerrieri
From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf > Of Rene Kluwen > Sent: Friday, 12 November, 2010 13:45 > To: 'Willy Mularto'; 'Kannel Users' > Subject: RE: SQLBox INSERT INTO MySQL Bug > > It's not the ' character that is n

[PATCH] RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Rene Kluwen
This patch should solve the issue. -Original Message- From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf Of Rene Kluwen Sent: Friday, 12 November, 2010 13:45 To: 'Willy Mularto'; 'Kannel Users' Subject: RE: SQLBox INSERT INTO MySQL Bug It&#

RE: SQLBox INSERT INTO MySQL Bug

2010-11-12 Thread Rene Kluwen
rto Sent: Friday, 12 November, 2010 02:00 To: Kannel Users Subject: SQLBox INSERT INTO MySQL Bug I found some errors in the log like this "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 '&#

SQLBox INSERT INTO MySQL Bug

2010-11-11 Thread Willy Mularto
I found some errors in the log like this "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:1127445986 sub:001 dlvrd:001 submit date:1011120752 done date:1011120752 sta' at line 1" I think SQ