SQL syntax errors after upgrade to 0.8.7b

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
jflanda
Posts: 2
Joined: Thu Aug 07, 2008 7:18 am

SQL syntax errors after upgrade to 0.8.7b

Post by jflanda »

I get this errors after upgrading to last cacti version:

Code: Select all

08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=  limit 0,1"
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select  graph_local.host_id,  graph_local.snmp_query_id,  graph_local.snmp_index,  graph_templates_graph.title_cache,  graph_templates_graph.vertical_label,  graph_templates_graph.slope_mode,  graph_templates_graph.auto_scale,  graph_templates_graph.auto_scale_opts,  graph_templates_graph.auto_scale_log,  graph_templates_graph.scale_log_units,  graph_templates_graph.auto_scale_rigid,  graph_templates_graph.auto_padding,  graph_templates_graph.base_value,  graph_templates_graph.upper_limit,  graph_templates_graph.lower_limit,  graph_templates_graph.height,  graph_templates_graph.width,  graph_templates_graph.image_format_id,  graph_templates_graph.unit_value,  graph_templates_graph.unit_exponent_value,  graph_templates_graph.export  from (graph_templates_graph,graph_local)  where graph_local.id=graph_templates_graph.local_graph_id  and graph_templates_graph.local_graph_id="
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select  graph_templates_item.id as graph_templates_item_id,  graph_templates_item.cdef_id,  graph_templates_item.text_format,  graph_templates_item.value,  graph_templates_item.hard_return,  graph_templates_item.consolidation_function_id,  graph_templates_item.graph_type_id,  graph_templates_gprint.gprint_text,  colors.hex,  graph_templates_item.alpha,  data_template_rrd.id as data_template_rrd_id,  data_template_rrd.local_data_id,  data_template_rrd.rrd_minimum,  data_template_rrd.rrd_maximum,  data_template_rrd.data_source_name,  data_template_rrd.local_data_template_rrd_id  from graph_templates_item  left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)  left join colors on (graph_templates_item.color_id=colors.id)  left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id)  where graph_templates_item.local_graph_id=  order by graph_templates_item.sequence"
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=  limit 0,1"
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select  graph_local.host_id,  graph_local.snmp_query_id,  graph_local.snmp_index,  graph_templates_graph.title_cache,  graph_templates_graph.vertical_label,  graph_templates_graph.slope_mode,  graph_templates_graph.auto_scale,  graph_templates_graph.auto_scale_opts,  graph_templates_graph.auto_scale_log,  graph_templates_graph.scale_log_units,  graph_templates_graph.auto_scale_rigid,  graph_templates_graph.auto_padding,  graph_templates_graph.base_value,  graph_templates_graph.upper_limit,  graph_templates_graph.lower_limit,  graph_templates_graph.height,  graph_templates_graph.width,  graph_templates_graph.image_format_id,  graph_templates_graph.unit_value,  graph_templates_graph.unit_exponent_value,  graph_templates_graph.export  from (graph_templates_graph,graph_local)  where graph_local.id=graph_templates_graph.local_graph_id  and graph_templates_graph.local_graph_id="
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select  graph_templates_item.id as graph_templates_item_id,  graph_templates_item.cdef_id,  graph_templates_item.text_format,  graph_templates_item.value,  graph_templates_item.hard_return,  graph_templates_item.consolidation_function_id,  graph_templates_item.graph_type_id,  graph_templates_gprint.gprint_text,  colors.hex,  graph_templates_item.alpha,  data_template_rrd.id as data_template_rrd_id,  data_template_rrd.local_data_id,  data_template_rrd.rrd_minimum,  data_template_rrd.rrd_maximum,  data_template_rrd.data_source_name,  data_template_rrd.local_data_template_rrd_id  from graph_templates_item  left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)  left join colors on (graph_templates_item.color_id=colors.id)  left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id)  where graph_templates_item.local_graph_id=  order by graph_templates_item.sequence"
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select  data_template_data.rrd_step  from (data_template_data,data_template_rrd,graph_templates_item)  where graph_templates_item.task_item_id=data_template_rrd.id  and data_template_rrd.local_data_id=data_template_data.local_data_id  and graph_templates_item.local_graph_id=  limit 0,1"
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select  graph_local.host_id,  graph_local.snmp_query_id,  graph_local.snmp_index,  graph_templates_graph.title_cache,  graph_templates_graph.vertical_label,  graph_templates_graph.slope_mode,  graph_templates_graph.auto_scale,  graph_templates_graph.auto_scale_opts,  graph_templates_graph.auto_scale_log,  graph_templates_graph.scale_log_units,  graph_templates_graph.auto_scale_rigid,  graph_templates_graph.auto_padding,  graph_templates_graph.base_value,  graph_templates_graph.upper_limit,  graph_templates_graph.lower_limit,  graph_templates_graph.height,  graph_templates_graph.width,  graph_templates_graph.image_format_id,  graph_templates_graph.unit_value,  graph_templates_graph.unit_exponent_value,  graph_templates_graph.export  from (graph_templates_graph,graph_local)  where graph_local.id=graph_templates_graph.local_graph_id  and graph_templates_graph.local_graph_id="
08/07/2008 02:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select  graph_templates_item.id as graph_templates_item_id,  graph_templates_item.cdef_id,  graph_templates_item.text_format,  graph_templates_item.value,  graph_templates_item.hard_return,  graph_templates_item.consolidation_function_id,  graph_templates_item.graph_type_id,  graph_templates_gprint.gprint_text,  colors.hex,  graph_templates_item.alpha,  data_template_rrd.id as data_template_rrd_id,  data_template_rrd.local_data_id,  data_template_rrd.rrd_minimum,  data_template_rrd.rrd_maximum,  data_template_rrd.data_source_name,  data_template_rrd.local_data_template_rrd_id  from graph_templates_item  left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)  left join colors on (graph_templates_item.color_id=colors.id)  left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id)  where graph_templates_item.local_graph_id=  order by graph_templates_item.sequence"
My cacti info:
Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - Cactid v
Server Info - Linux 2.6.18-92.1.6.el5
Web Server - Apache/2.2.3 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, dbase, ldap, mbstring, mcrypt, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, rrdtool
MySQL - 5.0.45
RRDTool - 1.2.27
SNMP - 5.3.1
Plugins
  • Global Plugin Settings (settings - v0.5)
    Thresholds (thold - v0.3.9)
    Device Monitoring (monitor - v0.8.2)
    Host Info (hostinfo - v0.2)
    Network Tools (tools - v0.3)
    Update Checker (update - v0.4)

Any idea?

Thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests