[asterisk-users] Asterisk CDR Analyser

[Klaverstyn, David C]

Brilliant, many thanks.  It is now working once I changed it to the
correct table name.  Line 232 is correct as well, column 103

-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Sean
Bright
Sent: Friday, 10 October 2008 12:44 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Asterisk CDR Analyser

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
>

_______________________________________________
-- 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