Unknown column 'calldate' in 'where clause' )

GoogleCodeExporter commented 9 years ago

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 kachopat...@gmail.com on 27 Apr 2014 at 12:33

GoogleCodeExporter commented 9 years ago

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 kachopat...@gmail.com on 27 Apr 2014 at 12:57

GoogleCodeExporter commented 9 years ago

Hello! 
Try to look for an alias of "calldate" field in /etc/asterisk/cdr_mysql.conf

Original comment by vushte...@gmail.com on 29 Apr 2014 at 11:52

g613 / asterisk-cdr-viewer

Unknown column 'calldate' in 'where clause' ) #22