SQL errors

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Locked
bonj87
Cacti User
Posts: 92
Joined: Fri Mar 26, 2010 7:42 am

SQL errors

Post by bonj87 »

ok i upgraded my cacti to the latest release.. also downloaded the latest version of spine for this release.
when polling, im not getting data in the graphs when i use spine (i tried going back to my old version of spine.. same error)..
i can only get data using cmd.php.. and sometimes that fails..
but.. im my CLOG, im getting a ton of these..
ideas?

02/02/2012 11:04:14 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1489"
02/02/2012 11:04:14 AM - 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<1489 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 1"
02/02/2012 11:04:14 AM - 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, 1"
02/02/2012 11:04:08 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1489"
02/02/2012 11:04:08 AM - 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<1489 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 1"
02/02/2012 11:04:08 AM - 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, 1"
02/02/2012 11:04:02 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1489"
02/02/2012 11:04:02 AM - 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<1489 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 1"
02/02/2012 11:04:02 AM - 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, 1"
02/02/2012 11:03:56 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1489"
02/02/2012 11:03:56 AM - 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<1489 AND gtg.title_cache RLIKE '' ORDER BY id DESC LIMIT 0, 1"
02/02/2012 11:03:56 AM - 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, 1"
02/02/2012 11:03:53 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1909"
02/02/2012 11:03:53 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1909"
02/02/2012 11:03:53 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT COUNT(DISTINCT(data_input_data.data_template_data_id)) FROM data_template_rrd, graph_templates_item, data_template_data, data_input_data WHERE data_template_rrd.data_template_id=41 AND data_template_rrd.id=graph_templates_item.task_item_id AND data_template_data.local_data_id=data_template_rrd.local_data_id AND data_input_data.data_template_data_id=data_template_data.id AND data_input_data.data_input_field_id=14 AND data_input_data.value= AND graph_templates_item.local_graph_id=1909"
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Re: SQL errors

Post by BSOD2600 »

Stop creating multiple posts for related issues. Go back to your thread from yesterday.

1) make sure you're using the latest clog
2) if using the latest, report this bug to the clog author.
Locked

Who is online

Users browsing this forum: No registered users and 6 guests