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', '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

Reply via email to