Cycle plugin issue/bug? Cacti logs full of SQL error.

[gred]

Hi Gurus,

I need some help here. My Cacti logs are full of SQL error and I have spent a few hours on it but couldnt find the issue. I only know that "cycle" plugin has caused the issue.

I started playing around with cycle plugin today, by selecting and changing the refresh frequency, columns, number of graphs per page, Tree view cycle etc. These are basic settings in cycle plugin tab. However, after playing this cycle plugin, my Cacti logs started showing the below errors. I remember I did encounter some issue with the cycle graphs where it didnt refresh properly sometimes.

I uinstalled the plugin, removed the plugin, etc, but the errors are still showing up. Then, I deleted and removed all the cycle plugin files in /var/www/cacti/plugins/cycle (I also removed the dir).
This solved the problem....the errors stop coming up in log. I waited 30 mins and everything was okay. I then reinstalled the plugin cycle and enable it (basically unzip tar the .gz file) and enable in cacti gui. Right after this I started seeing the below errors again...I believe there was some settings that are saved somewhere and is polling something eveyr 5 seconds? possibly my initial cycle refresh timer? How can I reset this and permanently clear this?

Confused...as errors disappeared when I removed "cycle" folder but returned when I installed it.

02/16/2012 10:17:28 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gl.id<177 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 8"
02/16/2012 10:17:28 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gtg.title_cache RLIKE '' ORDER BY gl.id ASC LIMIT 0, 8"
02/16/2012 10:17:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gl.id<177 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 8"
02/16/2012 10:17:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gtg.title_cache RLIKE '' ORDER BY gl.id ASC LIMIT 0, 8"
02/16/2012 10:17:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gl.id<177 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 8"
02/16/2012 10:17:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gtg.title_cache RLIKE '' ORDER BY gl.id ASC LIMIT 0, 8"
02/16/2012 10:17:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gl.id<177 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 8"
02/16/2012 10:17:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gtg.title_cache RLIKE '' ORDER BY gl.id ASC LIMIT 0, 8"
02/16/2012 10:17:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gl.id<177 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 8"
02/16/2012 10:17:03 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT gl.id, gtg.title_cache FROM graph_local AS gl INNER JOIN graph_templates_graph AS gtg ON (gtg.local_graph_id=gl.id) WHERE gtg.title_cache RLIKE '' ORDER BY gl.id ASC LIMIT 0, 8"

[prospero63]

Anyone find a resolution to this? I'm having the same issue on a fresh install.