asterisk-cdr-viewer icon indicating copy to clipboard operation
asterisk-cdr-viewer copied to clipboard

Unknown column 'calldate' in 'where clause' )

Open GoogleCodeExporter opened this issue 10 years ago • 2 comments

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

GoogleCodeExporter avatar May 13 '15 15:05 GoogleCodeExporter

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

GoogleCodeExporter avatar May 13 '15 15:05 GoogleCodeExporter

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

GoogleCodeExporter avatar May 13 '15 15:05 GoogleCodeExporter