upgraded but can't create graphs now

[ashfieldm]

I recently upgraded to the latest version of cacti and am trying to add some new graphs for a device. When I try it I get:

"This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information"

When I run in debug mode, I get a whole bunch of data returned, but it ends with:
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'


Any help would be greatly appreciated.

Thanks

[ashfieldm]

Still having this problem. I cannot create any new graphs. Even a simple generic switch doens't work, even though I'm already graphing other switches of same make/model.

Any help is apreciated.

Thanks

[gandalf]

I recently upgraded to the latest version of cacti and am trying to add some new graphs for a device. When I try it I get:

"This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information"

When I run in debug mode, I get a whole bunch of data returned, but it ends with:
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'


Any help would be greatly appreciated.

Thanks

The upper part is required. The lower part of the debug is of no use
Reinhard

[gandalf]

The issue is solved now.
The root cause is the use of the CAST operation with mysql. CAST is not supported. From mysql.com:

CAST() and CONVERT() are available as of MySQL 4.0.2.

A workaround is to revert a recent patch in graphs_new.php
Search for CAST to find

Code: Select all

$sql_order = "ORDER BY CAST(snmp_index AS unsigned)";

Replace by

Code: Select all

$sql_order = "ORDER BY snmp_index";

. Of course, this will bring problems when using large snmp indices.
Recommendation is to update mysql. Please be aware, that mysql 3.x is way old and not supported any more!
Reinhard