asterisk users - Oct 2008 - Asterisk CDR Analyser

Hi All,

 

I'm stuck 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)

That query appears in call-log.php around line 232.

On Thu, Oct 9, 2008 at 10:20 PM, Klaverstyn, David C
<David.Klaverstyn at intergraph.com> wrote:
> Hi All,
>
>
>
> I'm stuck 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)
>
>
>
> From memory there is a file that needs to be modified that is hard coded to
> use the table asterisk.cdr but I can't find it anywhere.
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>