<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#333333">
Hi, <br>
<br>
We are trying to get working Queue Stats, but it seems we get
stucked. <br>
<br>
Is anyone using this project for to track agent statistics ?<br>
<a href="http://www.asteriskguru.com/tools/queue_stats.php">http://www.asteriskguru.com/tools/queue_stats.php</a><br>
<br>
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.<br>
<br>
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. <br>
<br>
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.<br>
<br>
Beside of this error i see bunch of errors in apache log file.<br>
<br>
<tt>[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<br>
[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<br>
[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<br>
[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<br>
[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<br>
[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<br>
[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<br>
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"<br>
192.168.0.2 - - [29/Sep/2011:14:18:28 +0200] "POST
/public/incoming_general.php HTTP/1.1" 302 497 <a
class="moz-txt-link-rfc2396E"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">"http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming"</a>
"Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20100101
Firefox/6.0.2"<br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
[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:
<a class="moz-txt-link-freetext"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming</a><br>
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 <a class="moz-txt-link-rfc2396E"
href="http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty%21&type=incoming">"http://queue_stats.omicrons.pl/public/error.php?warning=The%20database%20is%20empty!&type=incoming"</a>
"Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20100101
Firefox/6.0.2"<br>
</tt><br>
<br>
Thanks and regards,<br>
Robert<br>
<br>
</body>
</html>