no host in the list

[GoogleCodeExporter]

Hello,

I have download logzilla 3.0beta7.
On the main HTML page, no hosts in the list.
I use sql query logging for debugging:

12:24:54.3819 - /logs/includes/ajax/json.hostgrid.php - SELECT name,value
FROM settings
12:24:54.3827 - SELECT COUNT(DISTINCT host) FROM logs WHERE 1=1
12:24:54.383 - SELECT DISTINCT(host) FROM logs WHERE 1=1 ORDER BY host desc
LIMIT 0 , 10

with mysql the result of query is  :
SELECT COUNT(DISTINCT host) FROM logs WHERE 1=1
+----------------------+
| COUNT(DISTINCT host) |
+----------------------+
|                    2 |
+----------------------+
1 row in set (0.00 sec)
SELECT DISTINCT(host) FROM logs WHERE 1=1 ORDER BY host desc LIMIT 0 , 10;
+------------------------+
| host                   |
+------------------------+
| supervision6           |
| supervision5.gie-sv.fr |
+------------------------+
2 rows in set (0.00 sec)

Where is the problem.

Philippe

Original issue reported on code.google.com by philippe...@cti-paysloire.cnamts.fr on 25 Jan 2010 at 11:27

[GoogleCodeExporter]

Hi,
Can you please move this support request to http://logzilla.info so that others 
may
benefit from it later? (it's too difficult to track issues here).

Original comment by cdu...@gmail.com on 25 Jan 2010 at 2:56

• Changed state: Accepted