Cactiusers.org

I had an amazingly successful upgrade from 6i to 7b, including the new PA and thold plugins.

During the upgrade the DB updates ran without errors and I was able to apply pa.sql without issue.

However, in the cacti log, I'm seeing a new error - the only one in fact.

04/01/2008 04:44:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

I'm not even sure what is non-functional at this point, if anything, based on this error.

Any ideas?

I am having the same problem. I have looked around but did not find anything just some people hacking the setup.php here: http://forums.cacti.net/about25175.html

Already fixed in SVN.

please tell me the SVN address
Thank you

Hello - bit of a noob when it comes to SVN - can I just update one file? If so which one please?

Hi people,
i already did the changes that are specified in svn(revision 4544), but i stiil have the same messages in the log. I have the Cacti8.7b.

The log still have the messages:

01/21/2009 12:40:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "
01/21/2009 12:40:30 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

But i notice that my poller_output table is empty. Is that all right?
Please help me.

Make sure you didn't grab the "trunk" from the SVN, and instead grabbed the latest stable branch. Trunk is undergoing heavy changes and is broken.

I just did the changes that appear in the revision 4544. I visualize the differences and make the change in my code.
I followed the link of "text changed" at http://svn.cacti.net/viewvc?view=rev&revision=4544 --> cacti/branches/0.8.7/poller.php
Is that all right?

Ya, that isn't the piece of code you need. That is a change to Cacti, not to the thold plugin.

Thank you very much for the help. I already foud the solution in the thold forum... http://forums.cacti.net/about25991.html.
It is working ok now.
Bye