i tried to install cdr-stats but i when i tried to configure freepbx
import data by using this command
Now log into MySQL with a command like:
after login inside mysql and use asteriskcdrdb when iam trying this command
update cdr SET import_cdr = 0;
i got this error
ERROR 1054 (42S22): Unknown column ‘import_cdr’ in ‘field list’
mysql> DESCRIBE cdr;
±--------------±-------------±-----±----±--------------------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------------------±---------------+
| acctid | bigint(20) | NO | PRI | NULL | auto_increment |
| calldate | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| clid | varchar(80) | NO | | | |
| src | varchar(80) | NO | | | |
| dst | varchar(80) | NO | MUL | | |
| dcontext | varchar(80) | NO | | | |
| channel | varchar(80) | NO | | | |
| dstchannel | varchar(80) | NO | | | |
| lastapp | varchar(80) | NO | | | |
| lastdata | varchar(80) | NO | | | |
| duration | int(11) | NO | | 0 | |
| billsec | int(11) | NO | | 0 | |
| disposition | varchar(45) | NO | | | |
| amaflags | int(11) | NO | | 0 | |
| accountcode | varchar(20) | NO | MUL | | |
| uniqueid | varchar(32) | NO | | | |
| userfield | varchar(255) | NO | | | |
| did | varchar(50) | NO | | | |
| recordingfile | varchar(255) | NO | | | |
| cnum | varchar(40) | NO | | | |
| cnam | varchar(40) | NO | | | |
| outbound_cnum | varchar(40) | NO | | | |
| outbound_cnam | varchar(40) | NO | | | |
| dst_cnam | varchar(40) | NO | | | |
±--------------±-------------±-----±----±--------------------±---------------+
24 rows in set (0.00 sec)
mysql>
the colunmn import_cdr not found
any help