sql create statement for a missing table plugin_update_info

[doiggl]

Hello,
Q1. Have you got the .sql create statement for a missing table 'plugin_update_info' ,could you post the create statement please ?

I see this in the cacti log:
Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * from plugin_update_info"

Q2.- What package and .sql file creates table plugin_update_info" ?

I have this version of cacti and plugins installed
# rpm -qa | grep -i cacti
cacti-PA-settings-0.5-10.1.noarch
cacti-PA-autom8-0.35-25.1.noarch
cacti-PA-0.8.7i-5.1.noarch
cacti-PA-monitor-1.3.1-16.1.noarch
cacti-PA-hostinfo-0.2-5.1.noarch
cacti-PA-update-0.4-11.1.noarch
cacti-spine-0.8.7i-2.1.x86_64

Thanks Glenn

[gandalf]

From an old thread

Code: Select all

DROP TABLE IF EXISTS `plugin_update_info`;
CREATE TABLE plugin_update_info (
plugin varchar(32) default NULL,
name varchar(32) default NULL,
version varchar(24) default NULL,
author varchar(64) default NULL,
homepage varchar(64) default NULL,
email varchar(64) default NULL,
released varchar(18) default NULL,
changes TEXT NOT NULL
) TYPE=MyISAM; 

But I'm not sure that this is needed in current PIA versions anymore
R.