[Asterisk-Users] Graphical Interface to display Asterisk CDR /php

Chris HARIGA contact at techselesta.com
Tue Mar 23 22:07:10 MST 2004


Hi,

I get this ...

Database error: Invalid SQL: SELECT calldate, channel, src, clid,
lastapp, lastdata, dst, dst, disposition, duration FROM cdr ORDER BY
calldate DESC LIMIT 0,25
MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)
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('2004-03-01') GROUP BY
substring(calldate,1,10)
MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)
Database error: Invalid SQL: SELECT count(*) FROM cdr WHERE
UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2004-03-01')
MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)
Database error: next_record called with no query pending.
MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)

And I have the database and the table on my mysql :(

Best regards,

Chris HARIGA


-----Original Message-----
From: asterisk-users-admin at lists.digium.com
[mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Areski
Sent: Wednesday, March 24, 2004 1:35 PM
To: Asterisk-Users Mailing-list
Subject: Re: [Asterisk-Users] Graphical Interface to display Asterisk
CDR /php

I made an Update, now don't need register_globals on anymore...

By the way, I fix some bugs, cause it was not possible to choose
criteria and then browse the result page by page... now it's work fine
:)


So, better to make an update of your version
http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_2.tar.gz

http://www.areski.net/asterisk-stat-v1/about.php



Sorry about all this changes...
Regards, 
Areski


On Wed, 2004-03-24 at 16:42, Ryan Thrash wrote:
> Does register_globals need to be on to work with this? And if so, any 
> chance that will be turned off in the (hopefully near) future?
> 
> Thanks, Ryan
> 
> On Mar 24, 2004, at 9:09 AM, Areski wrote:
> 
> > I just finished an other version, all my apologies, cause I made it
for
> > mysql then I ve done the change to support postgresql and forget to
> > re-test again... not really professional at all ;)
> > <snip>
> > http://www.areski.net/asterisk-stat-v1/about.php
> >
> > Download :
> > http://www.areski.net/asterisk-stat-v1/asterisk-stat-v1_1.tar.gz
> >
> > If you have still some problems, share them with me !
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users





More information about the asterisk-users mailing list