[solved] Error upgrading from 8.7g to 8.8c

[elwood43]

I upgraded (following documentation guide). All existing graphs work, but I am getting the following error:

03/02/2015 09:56:57 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT 1 AS id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name IN ('snmpagent', 'settings', 'boost', 'dsstats') UNION SELECT pc.id, ph.name, ph.file, ph.function FROM plugin_hooks AS ph LEFT JOIN plugin_config AS pc ON pc.directory=ph.name WHERE ph.status = 1 AND hook = 'poller_bottom' AND ph.name NOT IN ('snmpagent', 'settings', 'boost', 'dsstats') ORDER BY id ASC"

System Info:
Cacti Version: 0.8.8c
Cacti OS: unix
SNMP Version: NET-SNMP version: 5.3.2.2
RRDTool Version: RRDTool 1.2.x

Any help would be appreciated.

Thanks.

[BSOD2600]

Try removing everything from the /cacti/plugin/ folder and try again. also make sure you get the latest version of all the plugins you use.

[elwood43]

Thanks for your response.

I thought the same thing, but the old cacti (8.7g) didn't have plugins and the new 8.8c only contains an index.php (which redirects to home). I have not installed the plugin framework.

The error appears to be related to plugins, but none are in use. Could it be failure to properly upgrade db?

Thanks.

[elwood43]

Solved:

I removed new installation. Copied back the old 8.7g installation and imported previous mysql cacti db. Then installed the 8.8c cacti. This time, it did all the necessary 8.7g -> 8.8c database and other migrations. That step either failed to run or was incomplete previously. After re-upgrade, all graphs and instances are working without error.