Hi
dlr-url should also be urlencoded. In your example the + sign should also
be urlencode since + is the urlencode value of the space char.
Regards
Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
Visitenos en www.perusms.com
On Wed, Jul 15, 2015 at 2:39 AM, Marcin Matyaszczyk <m.matyaszc...@ogicom.pl
> wrote:
> Hello
>
> Thanks for answer. We urlencode all fields and sms is submitted ok to
> kannel, problem appears when we get dlr (insert query).
>
> Pozdrawiam,
> Marcin Matyaszczyk
> Administrator
>
> Ogicom “Spider” Sp. z o.o. S.K.A., (61-131) Poznan, ul. Abpa Baraniaka
> 88, REGON 634407251, NIP 781-17-20-476, Sad Rejonowy Poznan Nowe Miasto
> i Wilda w Poznaniu, VIII Wydzial Gospodarczy Krajowego Rejestru
> Sadowego, KRS 0000410900, kapital zakladowy: 429 000 PLN.
>
> W dniu 10.07.2015 o 16:20, Alvaro Cornejo pisze:
> > Hi
> >
> > You need to urlenconde your field values when submitting to kannel.
> > "Victoria's" should be "Victoria%27s"
> >
> > Regards
> >
> > Alvaro
> >
> >
> |-----------------------------------------------------------------------------------------------------------------|
> > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
> > celular y Nextel
> > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
> > SMS y GPRS online
> > Visitenos en www.perusms.com <http://www.perusms.com>
> >
> > On Thu, Jul 9, 2015 at 8:00 AM, Marcin Matyaszczyk
> > <m.matyaszc...@ogicom.pl <mailto:m.matyaszc...@ogicom.pl>> wrote:
> >
> > Hello
> >
> > we have a problem with Postgresql DLR storage, when we try to send
> sms
> > with source field containing ' character we've got an error:
> >
> > 2015-04-02 10:18:51 CEST STATEMENT: INSERT INTO "dlr" ("smsc", "ts",
> > "source", "destination", "service", "url", "mask", "boxc", "status")
> > VALUES ('smppxxxx3', '88888888', 'Victoria's', '+48888888888
> > <tel:%2B48888888888>', 'xxxxxx',
> > '
> http://xxxx.domain.pl/dlr2.php?id=110725920&source=XXXXXXX&t=%t&i=%i&d=%d&D=%D&A=%A&F=%F
> ',
> > '31', '', '0');
> >
> > 2015-04-02 10:21:51 CEST ERROR: syntax error at or near "s" at
> > character 147
> >
> > We use kannel 1.5. Can you tell me how we can avoid this problem?
> >
> > regards
> > Marcin Matyaszczyk
> >
> >
>
