Displaying 2 results from an estimated 2 matches for "nbcall".
Did you mean:
bcall
2008 Oct 10
1
Asterisk CDR Analyser
...and need some help. I have installed the Asterisk CDR
Analyser Version 2.0.1. It mostly works except for the CDR Report. I
get the following error even though it lists the CDR details.
Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day,
sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-10-01') GROUP BY
substring(calldate,1,10)
MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)
2007 Jul 12
0
No subject
...0pt;font-family:"Arial","sans-serif"'>Database
error:</span></b><span =
style=3D'font-size:10.0pt;font-family:"Arial","sans-serif"'>
Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS =
calltime,
count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=3D
UNIX_TIMESTAMP('2008-10-01') GROUP BY substring(calldate,1,10)<br>
<b>MySQL Error</b>: 1146 (Table 'asterisk.cdr' doesn't =
exist)</span><o:p></o:p></p>
<p class=3DMsoNormal><...