[asterisk-users] Problem with Queue Stats

[Albert]

Hi,

We are trying to get working Queue Stats, but it seems we get stucked.

Is anyone using this project for to track agent statistics ?
http://www.asteriskguru.com/tools/queue_stats.php

We are managed to install Queue Stats version 0.3 despite of the fact 
that its using Zend framework, which is not compatible with PHP version 
is latest stable Debian.

Anyway, we are facing following problem now, on main page of project I 
am getting : "The database in empty", but its not empty. Access to 
database in ./include/config.inc.php and in ./log/config.inc.php has 
been configured correctly.

If anyone knows how to solve it, please give me a hand or if you know 
other Opensource application which do the same job just advise what I 
can use.

Beside of this error i see bunch of errors in apache log file.

[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined index:  ACCESS in /usr/share/queue_stats/public/error.php on 
line 26
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined variable: queue_select_in in 
/usr/share/queue_stats/public/error.php on line 29
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Warning:  
pg_query(): Query failed: ERROR:  invalid input syntax for integer: 
""\nLINE 12:      aq.access_sid = ''\n                              ^ in 
/usr/share/queue_stats/public/error.php on line 61
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Warning:  
pg_fetch_object() expects parameter 1 to be resource, boolean given in 
/usr/share/queue_stats/public/error.php on line 62
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined index:  ACCESS in /usr/share/queue_stats/public/error.php on 
line 152
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined variable: queue in /usr/share/queue_stats/public/error.php on 
line 157
[Thu Sep 29 14:18:24 2011] [error] [client 192.168.0.2] PHP Warning:  
Invalid argument supplied for foreach() in 
/usr/share/queue_stats/public/error.php on line 157
192.168.0.2 - - [29/Sep/2011:14:18:24 +0200] "GET 
/public/error.php?warning=The%20database%20is%20empty!&type=incoming 
HTTP/1.1" 200 2124 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) 
Gecko/20100101 Firefox/6.0.2"
192.168.0.2 - - [29/Sep/2011:14:18:28 +0200] "POST 
/public/incoming_general.php HTTP/1.1" 302 497 
"http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming" 
"Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20100101 Firefox/6.0.2"
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined index:  ACCESS in /usr/share/queue_stats/public/error.php on 
line 26, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined variable: queue_select_in in 
/usr/share/queue_stats/public/error.php on line 29, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Warning:  
pg_query(): Query failed: ERROR:  invalid input syntax for integer: 
""\nLINE 12:      aq.access_sid = ''\n                              ^ in 
/usr/share/queue_stats/public/error.php on line 61, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Warning:  
pg_fetch_object() expects parameter 1 to be resource, boolean given in 
/usr/share/queue_stats/public/error.php on line 62, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined index:  ACCESS in /usr/share/queue_stats/public/error.php on 
line 152, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Notice:  
Undefined variable: queue in /usr/share/queue_stats/public/error.php on 
line 157, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
[Thu Sep 29 14:18:28 2011] [error] [client 192.168.0.2] PHP Warning:  
Invalid argument supplied for foreach() in 
/usr/share/queue_stats/public/error.php on line 157, referer: 
http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming
192.168.0.2 - - [29/Sep/2011:14:18:28 +0200] "GET 
/public/error.php?warning=The%20database%20is%20empty!&type=incoming 
HTTP/1.1" 200 2124 
"http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming" 
"Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20100101 Firefox/6.0.2"


Thanks and regards,
Robert

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110929/dec30153/attachment.htm>