asterisk-cdr-viewer
asterisk-cdr-viewer copied to clipboard
Unknown column 'calldate' in 'where clause' )
What steps will reproduce the problem?
1. In asterisk 11 just search
What is the expected output? What do you see instead?
PDO::errorInfo(): Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column
'calldate' in 'where clause' )
What version of the product are you using? On what operating system?
1.0.4 , Centos 6.5
Please provide any additional information below.
I think that the new CDR Grab to MYSQL Is different , dont have calldate , is
there a way yo make it work with asterisk 11 ?
Original issue reported on code.google.com by [email protected] on 27 Apr 2014 at 12:33
I Don t know if is the right solution but works .
grep -rl calldate asterisk-cdr-viewer/ | xargs sed -i 's/calldate/start/g'
Original comment by [email protected] on 27 Apr 2014 at 12:57
Hello!
Try to look for an alias of "calldate" field in /etc/asterisk/cdr_mysql.conf
Original comment by [email protected] on 29 Apr 2014 at 11:52