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