THOLD - missing DB field

[brightm]

Hi, i've followed a THOLD thread to resolve issues i was having with THOLD and pretty much nailed them all except for the following:

CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT emails FROM plugin_notification_lists WHERE id=1"

This happpened after removing THOLD, installing v0.4.9.3 and acquiring the cacti.sql file from the Witness on another thread to re-install the THOLD tables.

Can you help with this?

Thanks.

[cigamit]

acquiring the cacti.sql file from the Witness on another thread to re-install the THOLD tables.

I am not understanding why this was done. If you uninstalled thold, then install the newest version, thold should recreate all its tables.

[brightm]

Agreed but for some reason the tables weren't recreated. I've since installed another plugin (mactrack) to make sure MySQL was behaving itself and creating tables when required and this proved ok. I've also removed and reinstalled THOLD v0.4.9.3 again and am still getting the same error.

To be honest i'm not sure if 'plugin_notifications_list' is a field that THOLD creates or whether it comes from another plugin?

I would create it manually but am not sure how to and what the requirements are for it.

Can you assist with this?

Thanks for your help.

[cigamit]

Code: Select all

CREATE TABLE IF NOT EXISTS `plugin_notification_lists` (
  `id` int(12) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL,
  `description` varchar(512) NOT NULL,
  `emails` varchar(512) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  COMMENT='Table of Notification Lists';

[brightm]

Thank you very much that's sorted out the missing field problem.

Now that it's working i seem to have a bit of a problem with the performance of cacti. I end up with lots of stale processes for php.exe, spine.exe, rrdtool.exe and cmd.exe. The whole thing grinds to a holt but i can't see any obvious errors in the log.

Apache 2.2.21
MySQL 5.5.16
PHP 5.3.8
Windows 2003 - 2 x CPU & 4Gb RAM
Cacti 0.8.7g
Spine 0.8.7e (I can't upgrade this as the majority of hosts report as down on the newer versions)
Plugin Architecture 2.9
THOLD 0.4.9.3
Weathermap 0.9.7a