Dear Alejandro,
Thanks for your reply. I checked my database settings, msgdata and udhdata
are already defined as blob and text. Would other field types matter? I have
included the create table script below. Please help check against yours.
CREATE TABLE `sent_sms` (
`sql_id` bigint(20) NOT NULL auto_increment,
`momt` enum('MO','MT') default NULL,
`sender` varchar(20) default NULL,
`receiver` varchar(20) default NULL,
`udhdata` blob,
`msgdata` text,
`time` bigint(20) default NULL,
`smsc_id` varchar(255) default NULL,
`service` varchar(255) default NULL,
`account` varchar(255) default NULL,
`id` bigint(20) default NULL,
`sms_type` bigint(20) default NULL,
`mclass` bigint(20) default NULL,
`mwi` bigint(20) default NULL,
`coding` bigint(20) default NULL,
`compress` bigint(20) default NULL,
`validity` bigint(20) default NULL,
`deferred` bigint(20) default NULL,
`dlr_mask` bigint(20) default NULL,
`dlr_url` varchar(255) default NULL,
`pid` bigint(20) default NULL,
`alt_dcs` bigint(20) default NULL,
`rpi` bigint(20) default NULL,
`charset` varchar(255) default NULL,
`boxc_id` varchar(255) default NULL,
`binfo` varchar(255) default NULL,
PRIMARY KEY (`sql_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Thanks & regards,
Coco
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alejandro Ramirez
Sent: Wednesday, March 08, 2006 12:12 AM
To: [EMAIL PROTECTED]
Cc: [email protected]
Subject: Re: sqlbox does not log WAP Push traffic
Coco,
In my particular case i found out that what was happening is that
i UPGRADED from previous SQLBOX version... so the msgdata, and udhdata
fields
existed already in table as varchar(255), and when installing from CVS
head i did not create from scratch the table. So i just had to change
the type of this fields into blob and text. Now all the msgs get logged!
Hope this helps,
Alejandro Ramirez
Coco King wrote:
>Hi,
>
>I tried download the latest CVS, problem still persist. Any one can help?
>
>Many thanks,
>
>Coco
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
>Of Alejandro Ramirez
>Sent: Monday, January 23, 2006 10:38 PM
>To: [EMAIL PROTECTED]
>Cc: [email protected]
>Subject: Re: sqlbox does not log WAP Push traffic
>
>Coco,
>
> I've read somewhere that the problem was that the UDH was
>being saved into a type of field that was not correct for the size (or
>type) of the UDH in a wap push. It was suppoused to be fixed, but i
>built from CVS last week and also found the same problem. Maybe Rene can
>help us out?
>
>
>Greetings
>
>Alejandro
>
>
>Coco King wrote:
>
>
>
>>Anyone knows why sqlbox is not logging WAP Push traffic? Is it a design
>>problem or bug? Or something wrong in my setup?
>>
>>Thanks for your help in advance.
>>
>>Coco
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Tired of spam? Yahoo! Mail has the best spam protection around
>>http://mail.yahoo.com
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
