Error SQL

cyrill · Posted: Mon Feb 25, 2008 1:45 am Post subject: Error SQL

HEllo ! I've the following error

cyrill · Posted: Fri Feb 29, 2008 1:50 am Post subject:

I've always this errror...

cyrill · Posted: Tue Mar 04, 2008 1:39 am Post subject:

please I need help. It's a serious error and I can't keep it

cyrill · Posted: Thu Mar 13, 2008 1:35 am Post subject:

I always this error

airwalk · Posted: Fri Mar 14, 2008 5:20 am Post subject:

Hi, I get the same error as well. If I downgrade from 0.3.9 to 0.3.8 then it goes away. Has anything been changed in DB in 0.3.9? thold.sql appears to be the same for both versions.

killshoot · Joined: 26 Mar 2008 Posts: 34

I also have the same error on a fresh install (cacti 0.87 / PA 2.1 / thold 3.9 )

03/26/2008 10:40:13 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 "

Vins · Joined: 12 Sep 2006 Posts: 43

Same problem descripted in this thread

http://forums.cacti.net/about25175.html

with a workaround wich only skips the red line on the log file...

TheWitness · Posted: Tue Apr 08, 2008 7:04 pm Post subject:

Definitely t-hold related. You need to hook up with Jimmy.

TheWitness

bookweb · Joined: 14 Apr 2008 Posts: 7

is this fixed by now?
i have the same problem on my cacti 0.8.7b

thanks
christian

gthe · Cacti User Joined: 29 Jul 2006 Posts: 94 Location: RU

To disable this error occuring I change thold/setup.php:197
before:

cyrill · Posted: Wed Jul 09, 2008 12:51 am Post subject:

hello ! I've always the problem... It is fixed ?

kasimong · Posted: Wed Jul 30, 2008 2:24 am Post subject:

me too

07/30/2008 09:10:38 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 "

TheWitness · Posted: Wed Jul 30, 2008 5:04 am Post subject:

Two posts up for the fix.

Regards,

TheWitness

zorrosam · Cacti User Joined: 03 May 2007 Posts: 153 Location: Italy

sorry,

when i apply the new line of the codes cacti die.

why?

The lines that i add are :

$rra_ids = ((strlen(trim($rra_ids)) > 0) ? "AND " . $rra_ids : "");

$thold_items = db_fetch_assoc("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 != '' $rra_ids");

any info is appreciate

sam

gthe · Cacti User Joined: 29 Jul 2006 Posts: 94 Location: RU