Re: Kannel does not insert the correct timestamp in mysql

[Illimar Reinbusch - Telejazz.com]

Hi

I have timestamp configured as varchar in mysql and everything works 
correctly.

Illimar

I have set Kannel to run with dlr-storage on mysql. What's happening 
is that timestamp is always '0000-00-00 00:00:00'.

The default value of ts field is current_timestamp as it should be.

I was looking at the source code and I think that it happens because 
put an empty string into the insert sql, then mysql translate it to 
the value above.

I'm using Debian (kernel 2.6.18-3-686), Kannel 1.4.1-2 and MySQL 
5.0.32-7etch1

Anybody knows how to solve it ?

Thanks!