graph render error after upgrade to 0.8.7c

[KPbIC]

hi all

after upgrade to 0.8.7c from 0.8.7b my graphs not correct render (pic1 in attach)

graph templates is correct, database too (pic2 and 3 in attach).

how i can repaire my graphs ?

[gandalf]

What is worrying you? The gap at the start of the graph?
Reinhard

[KPbIC]

GPRINT string on graph not comply with graph template.

do how on upper graph (see attach), must be how on lower graph

[gandalf]

Ok, now I see. Please upgrade to 087d and retry. This is not a known problem, but part of the graphing code was changed.
If problem persists, please post exported graph template
Reinhard

[KPbIC]

update

graph not change

graph template in attach

and graph properties

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title=" a3410-c6503 - Traffic - Gi2/28 - GigabitEthernet2/28" \
--rigid \
--base=1000 \
--height=120 \
--width=700 \
--alt-autoscale \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:8: \
--font AXIS:6: \
--font LEGEND:8: \
--font UNIT:6: \
DEF:a="/usr/local/cacti/rra/a3410-c6503_traffic_in_38641.rrd":traffic_in:AVERAGE \
DEF:b="/usr/local/cacti/rra/a3410-c6503_traffic_in_38641.rrd":traffic_out:AVERAGE \
DEF:c="/usr/local/cacti/rra/a3410-c6503_traffic_in_38641.rrd":IntSpeed:AVERAGE \
DEF:d="/usr/local/cacti/rra/a3410-c6503_traffic_in_38641.rrd":AdminStatus:AVERAGE \
DEF:e="/usr/local/cacti/rra/a3410-c6503_traffic_in_38641.rrd":OperStatus:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefd=b,8,*,-1,* \
CDEF:cdeff=b,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf%s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf%s\n" \
AREA:cdefd#002A97FF:"Outbound" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:cdeff:MAX:"Maximum\:%8.2lf%s\n" \
GPRINT:cdeff:LAST:"Current\:%8.2lf%s" \
GPRINT:cdeff:AVERAGE:"Average\:%8.2lf%s" \
GPRINT:c:LAST:"Interface Speed\: %8.0lf" \
GPRINT:d:LAST:" AdminStatus\:%8.0lf" \
GPRINT:e:LAST:" OperStatus\:%8.0lf"

[KPbIC]

any ideas ?

[KPbIC]

any ideas ?

[gandalf]

hi all

after upgrade to 0.8.7c from 0.8.7b my graphs not correct render (pic1 in attach)

graph templates is correct, database too (pic2 and 3 in attach).

how i can repaire my graphs ?

Now I've got it! Unfortunaetly, the Graph Template display is WRONG!
Please repeat your SQL but use "ORDER BY sequence ASC" and you'll see!
So my recommendation for a workaround is to re-order the graph template items until the graph displays correctly.
I'll check the ORDER statement on graph template display!
R.

[gandalf]

Current 087e shows in graph_templates.php

Code: Select all

function item() {
	global $colors, $consolidation_functions, $graph_item_types;

	/* ================= input validation ================= */
	input_validate_input_number(get_request_var("id"));
	/* ==================================================== */

	if (empty($_GET["id"])) {
		$template_item_list = array();

		$header_label = "[new]";
	}else{
		$template_item_list = db_fetch_assoc("select
			graph_templates_item.id,
			graph_templates_item.text_format,
			graph_templates_item.value,
			graph_templates_item.hard_return,
			graph_templates_item.graph_type_id,
			graph_templates_item.consolidation_function_id,
			CONCAT_WS(' - ',data_template_data.name,data_template_rrd.data_source_name) as data_source_name,
			cdef.name as cdef_name,
			colors.hex
			from graph_templates_item
			left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id)
			left join data_local on (data_template_rrd.local_data_id=data_local.id)
			left join data_template_data on (data_local.id=data_template_data.local_data_id)
			left join cdef on (cdef_id=cdef.id)
			left join colors on (color_id=colors.id)
			where graph_templates_item.graph_template_id=" . $_GET["id"] . "
			and graph_templates_item.local_graph_id=0
			order by graph_templates_item.sequence");

This shows, that the sequence is taken into account. So I see no need for a fix anymore.
R.