RRD Cleaner SQL Error

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
LukeC64
Posts: 11
Joined: Mon Nov 03, 2008 7:37 am

RRD Cleaner SQL Error

Post by LukeC64 »

Hi All,
I been using cacti for a little while but just started using RRD Cleaner, but when I do any thing with it I get errors in my cacti log. Update: If I run the query's in phpmyadmin with out quotes they work fine

02/18/2011 03:48:58 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT plugin_rrdclean.id, plugin_rrdclean.name, plugin_rrdclean.last_mod, plugin_rrdclean.size, plugin_rrdclean.name_cache, plugin_rrdclean.local_data_id, plugin_rrdclean.data_template_id, plugin_rrdclean.data_template_name FROM (plugin_rrdclean) WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%') ORDER BY name ASC LIMIT 0,30"
02/18/2011 03:48:58 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT ROUND(SUM(plugin_rrdclean.size),2) FROM plugin_rrdclean WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%')"
02/18/2011 03:48:58 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(plugin_rrdclean.name) FROM plugin_rrdclean WHERE (plugin_rrdclean.name like '%%%%') OR (plugin_rrdclean.name_cache like '%%%%') OR (plugin_rrdclean.data_template_name like '%%%%')"

The plug-in version is 0.41
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests