Hello The sms is submited like this:
http://localhost:13013/cgi-bin/sendsms?username=username&password=pass&to=%2B48500000000&text=SMS+test+40&from=Victoria%27s&smsc=smpp1tmobile&dlr-mask=31&priority=0&dlr-url=http%3A%2F%2Fsmsc.hostyyyy.pl%2Fdlr2.php%3Fid%3D145092731%26source%3Dred%26t%3D%25t%26i%3D%25i%26d%3D%25d%26D%3D%25D%26A%3D%25A%26F%3D%25F All fields are urlencoded, problem is with insert query for dlr result (we think that the string source is not escaped properly before insert to db). 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 04.08.2015 o 09:13, Jacek Raczkiewicz pisze: > I think in postgres you need to escape single quote by doubling it: > Victoria's -> Victoria''s > > 2015-08-04 9:08 GMT+02:00 spameden <spame...@gmail.com > <mailto:spame...@gmail.com>>: > > > > 2015-08-03 18:24 GMT+03:00 Alvaro Cornejo <cornejo.alv...@gmail.com > <mailto:cornejo.alv...@gmail.com>>: > > Hi Marcin > > Seems you are getting the problem due to the ' on text > Victoria's. Even though you are urlencoding it, it seems it is > being taken as a field delimiter and not part of the text. I'm > thinking on two options: > > -) Try to escape it with \' or \\' > > -) You might want to replace any ' within any field with ´ or ` > (right/left sided apostrophe) before urlencoding the fields. > > > I think Marcin spot a bug when you're receiving returning DLR data > with ' (apostroph) it won't be escaped / urlencoded properly that's > why there is an error. > Would be nice to reproduce this bug somehow. > > > 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 Mon, Aug 3, 2015 at 9:15 AM, Marcin Matyaszczyk > <m.matyaszc...@ogicom.pl <mailto:m.matyaszc...@ogicom.pl>> wrote: > > Hello > > we have a problem with Postgresql DLR storage which looks > like a bug: > 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 urlencode all fields and sms is submitted ok to kannel, > problem > appears in dlr's insert query only. We use kannel 1.5. > > regards > Marcin Matyaszczyk > > > > >
