Problem with Queue Stats

Home » Asterisk Users » Problem with Queue Stats
Asterisk Users No Comments

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