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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users