Aggregation Plugin Problem in CactiEZ v0.6

[GrL]

I've installed and enabled the aggregate plugin (version 0.74, in Cacti version 0.8.7c, with Plugin Architecture version 2.2, all from CactiEZ v0.6, see my screen snapshot PluginManagement.PNG). When I try to aggregate some graphs I get a short question (see my screen snapshot StrangeAggregation.PNG), while the documentation says that I should get a page with many parameters. When I answer "yes", I return to the list of graphs and cannot find the aggregated one. I found the following messages in my log:

03/24/2011 01:08:35 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"INSERT INTO `plugin_aggregate_color_template_items` (`color_template_item_id`, `color_template_id`, `color_id`, `sequence`) VALUES (1, 1, 4, 1), (2, 1, 24, 2), (3, 1, 98, 3), (4, 1, 25, 4), (5, 2, 25, 1), (6, 2, 29, 2), (7, 2, 30, 3), (8, 2, 31, 4), (9, 2, 33, 5), (10, 2, 35, 6), (11, 2, 41, 7), (12, 2, 9, , (13, 3, 15, 1), (14, 3, 31, 2), (15, 3, 28, 3), (16, 3, 8, 4), (17, 3, 34, 5), (18, 3, 33, 6), (19, 3, 35, 7), (20, 3, 41, , (21, 3, 36, 9), (22, 3, 42, 10), (23, 3, 44, 11), (24, 3, 48, 12), (25, 3, 9, 13), (26, 3, 49, 14), (27, 3, 51, 15), (28, 3, 52, 16), (29, 4, 76, 1), (30, 4, 84, 2), (31, 4, 89, 3), (32, 4, 17, 4), (33, 4, 86, 5), (34, 4, 88, 6), (35, 4, 90, 7), (36, 4, 94, , (37, 4, 96, 9), (38, 4, 93, 10), (39, 4, 91, 11), (40, 4, 22, 12), (41, 4, 12, 13), (42, 4, 95, 14), (43, 4, 6, 15), (44, 4, 92, 16);'
03/24/2011 01:08:35 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"INSERT INTO `plugin_aggregate_color_templates` (`color_template_id`, `name`) VALUES (1, 'Yellow: light -> dark, 4 colors'), (2, 'Red: light yellow > dark red, 8 colors'), (3, 'Red: light -> dark, 16 colors'), (4, 'Green: dark -> light, 16 colors');'

Thank you if you help me aggregate.

[gandalf]

The error shown in the middle graph is related to a different plugin that was loaded first and does not handle hooks well. This is a known bug of those plugins, not AGGREGATE. There's a workaround when loading AGGREGATE first. As you are running a very old software, you may need to edit include/global.php (or was it config.php?) and put AGGREGATE first in the list of plugins.
R.

[GrL]

The error shown in the middle graph is related to a different plugin that was loaded first and does not handle hooks well. This is a known bug of those plugins, not AGGREGATE. There's a workaround when loading AGGREGATE first. As you are running a very old software, you may need to edit include/global.php (or was it config.php?) and put AGGREGATE first in the list of plugins.
R.

Thank you for your answer! I use aggregate plugin version 0.74, Cacti version 0.8.7c, Plugin Architecture version 2.2. I don't think this software is too old but I tried to add the line

$plugins[] = 'aggregate';

after "$plugins = array();" in global.php. I rebooted the machine. After that, everything was the same except I did not see new SQL errors. I have deleted the added line because it had not helped.

Is there a workaround for my versions of software (aggregate plugin version 0.74, Cacti version 0.8.7c, Plugin Architecture version 2.2)?

If there is a problem in another plugin, then I am ready to disable or uninstall any other plugin to make the aggregate plugin work.

[GrL]

The error shown in the middle graph is related to a different plugin that was loaded first and does not handle hooks well. This is a known bug of those plugins, not AGGREGATE. There's a workaround when loading AGGREGATE first. As you are running a very old software, you may need to edit include/global.php (or was it config.php?) and put AGGREGATE first in the list of plugins.
R.

I have found on http://forums.cacti.net/viewtopic.php?f=14&t=42232 that the bug plugin is thold (Thresholds). When I disable Thresholds, I can create aggregates. Thank you for your answer!

[gandalf]

There's no need to disable THOLD. Only move AGGREGATE to a position BEFORE THOLD is loaded. That would be enough to solve
R.

[GrL]

There's no need to disable THOLD. Only move AGGREGATE to a position BEFORE THOLD is loaded. That would be enough to solve
R.

Dear Reinhard,

can you instruct me how to do this or where to read an instruction?

[gandalf]

Goto plugin management.
Click on the column named "Load order".
Use arrows to change load sequence
R.