Can't Assosiate Data Queries -> Success [0 Items, 0 Rows]

[pakdekge]

Dear All,

I am using Cacti version 0.8.7g and installed in Centos 5.6
Previously no problem with instalation and graph.
I can graph > 50 devices (Linux Server and Generic Switch) successfully.
But now i have problem, when i will add new graph for all host, the host is can't success Assosiate Data Queries.
I will try to verbose query but is same.
When in verbose queries, data from snmp can be detected, but the status still remains Success [0 Items, 0 Rows]
In bellow i attach the picture to describe it.

Please help.
Thanks before.

[noname]

"Reload Data Query" button (= green circle icon) does not help?

[pakdekge]

solved after repair table from sql

[gandalf]

good to know
R.

[tata_tulen]

Hi,

I had the same problem with 0.8.7h on Debian 5.0, the MySQL repair didn't help.
It seemed to be problem only with new-added data queries - the old-ones didn't suffer from this behavior.

In cacti.log there were some SQL errors and I have run the following SQL command to sole this issue:

ALTER TABLE `host_snmp_cache` ADD `present` INT NOT NULL ;

I suspect the dsstats plugin of that behavior.

Hope this helps...