Hi You need to urlenconde your field values when submitting to kannel. "Victoria's" should be "Victoria%27s"
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 On Thu, Jul 9, 2015 at 8:00 AM, Marcin Matyaszczyk <m.matyaszc...@ogicom.pl> wrote: > 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 > >