# Asterisk cdr cannot record CDR data

**URL:** <https://community.asterisk.org/t/asterisk-cdr-cannot-record-cdr-data/41859>\
**Category:** Asterisk Support\
**Created:** [February 12, 2013, 3:43pm UTC](https://community.asterisk.org/t/asterisk-cdr-cannot-record-cdr-data/41859 "2013-02-12T15:43:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![peacevisor](https://avatars.discourse-cdn.com/v4/letter/p/4af34b/32.png) [@peacevisor](https://community.asterisk.org/u/peacevisor)\
**Post date:** [February 12, 2013, 3:43pm UTC](https://community.asterisk.org/t/asterisk-cdr-cannot-record-cdr-data/41859/1 "2013-02-12T15:43:50Z")

</div>

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 | | | |
