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"
SQL errors
Moderators: Developers, Moderators
Re: SQL errors
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.
1) make sure you're using the latest clog
2) if using the latest, report this bug to the clog author.
| Scripts: Monitor processes | RFC1213 MIB | DOCSIS Stats | Dell PowerEdge | Speedfan | APC UPS | DOCSIS CMTS | 3ware | Motorola Canopy |
| Guides: Windows Install | [HOWTO] Debug Windows NTFS permission problems |
| Tools: Windows All-in-one Installer |
Who is online
Users browsing this forum: No registered users and 6 guests