Hi,
it should be converted to use prepared statements instead of plain sql string.
Patches are welcome…
Alex
> Am 04.08.2015 um 09:19 schrieb Marcin Matyaszczyk :
>
> Hello
>
> The sms is submited like this:
>
> http://localhost:13013/cgi-bin/sendsms?username=username&password=pass&to=%2B485
Hello
The sms is submited like this:
http://localhost:13013/cgi-bin/sendsms?username=username&password=pass&to=%2B485&text=SMS+test+40&from=Victoria%27s&smsc=smpp1tmobile&dlr-mask=31&priority=0&dlr-url=http%3A%2F%2Fsmsc.host.pl%2Fdlr2.php%3Fid%3D145092731%26source%3Dred%26t%3D%25t%26i
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 :
>
>
> 2015-08-03 18:24 GMT+03:00 Alvaro Cornejo :
>
>> Hi Marcin
>>
>> Seems you are getting the problem due to the ' on text Victoria's. Even
>> though you are urlen
2015-08-03 18:24 GMT+03:00 Alvaro Cornejo :
> 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
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
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
