Error SQL

cyrill · Post by **cyrill** » Mon Feb 25, 2008 1:45 am

HEllo ! I've the following error

02/25/2008 07:50:15 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 "

A red error is never nice...

please help me

cyrill · Post by **cyrill** » Fri Feb 29, 2008 1:50 am

I've always this errror...

cyrill · Post by **cyrill** » Tue Mar 04, 2008 1:39 am

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

cyrill · Post by **cyrill** » Thu Mar 13, 2008 1:35 am

I always this error

airwalk · Post by **airwalk** » Fri Mar 14, 2008 5:20 am

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 · Post by **killshoot** » Wed Mar 26, 2008 4:50 am

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 · Post by **Vins** » Fri Mar 28, 2008 4:42 am

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...

Post by **TheWitness** » Tue Apr 08, 2008 7:04 pm

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

TheWitness

bookweb · Post by **bookweb** » Thu Apr 17, 2008 3:13 am

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

thanks
christian

gthe · Post by **gthe** » Wed Apr 23, 2008 9:48 am

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

Code: Select all

			$rrd_update_array_reindexed[$item['local_data_id']] = $item['times'][key($item['times'])];
			$x++;
		}
	}

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

After:

Code: Select all

			$rrd_update_array_reindexed[$item['local_data_id']] = $item['times'][key($item['times'])];
			$x++;
		}
	}
	$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");

cyrill · Post by **cyrill** » Wed Jul 09, 2008 12:51 am

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

kasimong · Post by **kasimong** » Wed Jul 30, 2008 2:24 am

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 "

Post by **TheWitness** » Wed Jul 30, 2008 5:04 am

Two posts up for the fix.

Regards,

TheWitness

zorrosam · Post by **zorrosam** » Fri Sep 26, 2008 6:11 am

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 · Post by **gthe** » Fri Sep 26, 2008 6:14 am

Code: Select all

'' $rra_ids");

but not

Code: Select all

" $rra_ids");

Cacti

Error SQL

Error SQL

problem applying the patch

Who is online