Error in SQL after upgrade

Support questions about the Threshold plugin

Moderators: Developers, Moderators

Post Reply
shahbour
Posts: 16
Joined: Fri Nov 30, 2007 6:35 pm

Error in SQL after upgrade

Post by shahbour »

Hello,

i did upgrade to Cacti 0.8.7 b and all plugins to latest update, after doing so i am getting an error in the log that is keep looping on every second for the whole duration of request.

this is the error i got , and i removed all my Thold and still i got this ,

03/07/2008 09:26:21 AM - 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 "
mrloon
Posts: 14
Joined: Wed May 31, 2006 10:11 pm

Post by mrloon »

A past post I read showed this was resolved in SVN, but I've not seen any notice of any new thold build. Is there one on the way to being released, that will clear up this issue?

Cacti Version 0.8.7b
Plugin Architecture 2.1
Poller Type CMD.php
Server Info Windows NT 5.2
Web Server Microsoft-IIS/6.0
PHP Version 5.2.5
PHP Extensions bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, ISAPI, gd, mysql, snmp, sockets, RRDTool
MySQL Version 5.0.45-community-nt
RRDTool Version 1.2.15

Network Discovery (discovery - v0.8.3)
Cycle Graphs (Cycle Graphs - v0.5)
Documents (docs - v0.1)
Host Info (hostinfo - v0.2)
PHP Network Managing (manage - v0.5.1)
Device Monitoring (monitor - v0.8.2)
Global Plugin Settings (settings - v0.3)
RRD File Cleaner (RRD Cleaner - v0.34)
Syslog Monitoring (syslog - v0.5.2)
Thresholds (thold - v0.3.9)
Network Tools (tools - v0.2)
Update Checker (update - v0.4)
ReportIt (ReportIt - v0.5.1)
Report Creator (reports - v0.3)
Realtime for Cacti (realtime - v0.3)
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests