question about postgresql dlr storage

Marcin Matyaszczyk <[email protected]>
Newsgroups gmane.comp.mobile.kannel.devel
Message-ID <[email protected]>
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', '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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.