cdr table of asteriskcdrdb database have 18 fields. But asterisk record only 10 fields when i make a call.
calldate is 0000-00-00 00:00:00 for every record. how to fix this. i used asterisk 1.8.10 , mysql 5.5.29-0ubuntu0.12.04.1, ubuntu 12.04 LTS and odbc_adaptive. Pls help me.
-------±---------±--------±------------±---------±------------±-------------±----------±----±--------------+
| calldate | clid | src | dst | dcontext | channel | dstchannel | lastapp | lastdata | duration | billsec | disposition | amaflags | accountcode | uniqueid | userfield | did | recordingfile |
±--------------------±----------------±-----±---------±---------±---------------±-------------------±---------±-----------------------±---------±--------±------------±---------±------------±-------------±----------±----±--------------+
| 0000-00-00 00:00:00 | | | 500 | from | IAX2/3001-1933 | | Playback | demo-abouttotry | 12 | 12 | ANSWERED | 3 | | 1360298819.0 | | | |
| 0000-00-00 00:00:00 | | | 500 | from | IAX2/3001-1741 | | Playback | demo-abouttotry | 12 | 12 | ANSWERED | 3 | | 1360304779.1 | | | |