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;

Reply via email to