Issue of DLR - URL with opensmppbox kannel
Tolga Ulas <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.user |
|---|---|
| Message-ID | <CACoCBG-Tu64bSa3ABXK8qVPQYSVqh3EBZ+NYGix3AqHQuQy6xA@mail.gmail.com> |
I think url field should be varchar since it will store a urlencoded string so that smsbox will summon it by populating with its variables. > Hello Rene, Firstly thanks for your response. The length of my url field in dlr table is bigint(20) so I think this is enough. and the dlr table is empty as it fails to insert message due to the error above I believe. My dlr table structure CREATE TABLE `dlr` ( `id` bigint(20) UNSIGNED NOT NULL, `smsc` varchar(10) NOT NULL, `ts` varchar(40) NOT NULL, `destination` varchar(20) NOT NULL, `source` varchar(20) NOT NULL, `service` varchar(20) NOT NULL, `url` bigint(20) NOT NULL, `mask` int(11) NOT NULL, `status` int(11) NOT NULL, `boxc` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;