Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Feb 15, 2019 11:00 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 82 posts ]  Go to page 1, 2, 3, 4, 5, 6  Next
Author Message
 Post subject: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 8:01 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
ok im running cacti on my windows 7 pc.. for the past few years.. zero issues.. yesterday, my MySQL database got corrupted. I tried a few command lines to fix it to no avail.
so, I thought, ill just download the newest CACTI and upgrade myself.. well, now im in a heap of trouble.
I saved my old DB my old cacti folders (RRA, scripts, plugins, etc)
I had to uninstall everything, and start from scratch.. I copied my rra files in place, my scripts, etc etc. I notice the old plugins no longer work.. in fact, it tells me Not Compatible, Legacy Plugin
I may have missed some info in between versions here, but do the plugins no longer work at all? I have a copy of my old DB and all my files like I said.. any way I can get it all back up and running? been at it a couple days now, to no avail. id appreciate any help.. I can even webex with someone if they are willing to lend me a hand (one man shop here)

Thanks everyone!


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 10:35 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
I just went back and tried to do my upgrade again.. here's my output..

Upgrade Results

Database upgrade completed!


WARNING: One or more of the SQL queries needed to upgraded your Cacti installation has failed. Please see below for more details. Your Cacti MySQL user must have SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE, and DROP permissions. You should try executing the failed queries as "root" to ensure that you do not have a permissions problem.

Version: 1.0.0

[Fail]
CREATE TABLE IF NOT EXISTS `user_auth_group` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
`description` varchar(255) NOT NULL default '',
`graph_settings` varchar(2) DEFAULT NULL,
`login_opts` tinyint(1) NOT NULL DEFAULT '1',
`show_tree` varchar(2) DEFAULT 'on',
`show_list` varchar(2) DEFAULT 'on',
`show_preview` varchar(2) NOT NULL DEFAULT 'on',
`policy_graphs` tinyint(1) unsigned NOT NULL DEFAULT '1',
`policy_trees` tinyint(1) unsigned NOT NULL DEFAULT '1',
`policy_hosts` tinyint(1) unsigned NOT NULL DEFAULT '1',
`policy_graph_templates` tinyint(1) unsigned NOT NULL DEFAULT '1',
`enabled` char(2) NOT NULL DEFAULT 'on',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Table that Contains User Groups';

[Fail]
CREATE TABLE IF NOT EXISTS `user_auth_group_perms` (
`group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`item_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`type` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`group_id`,`item_id`,`type`),
KEY `group_id` (`group_id`,`type`))
ENGINE=InnoDB
COMMENT='Table that Contains User Group Permissions';

[Fail]
CREATE TABLE IF NOT EXISTS `user_auth_group_realm` (
`group_id` int(10) unsigned NOT NULL,
`realm_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`group_id`, `realm_id`),
KEY `group_id` (`group_id`),
KEY `realm_id` (`realm_id`))
ENGINE=InnoDB
COMMENT='Table that Contains User Group Realm Permissions';

[Fail]
CREATE TABLE IF NOT EXISTS `user_auth_group_members` (
`group_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`group_id`, `user_id`),
KEY `group_id` (`group_id`),
KEY `realm_id` (`user_id`))
ENGINE=InnoDB
COMMENT='Table that Contains User Group Members';

[Fail]
CREATE TABLE IF NOT EXISTS `settings_user_group` (
`group_id` smallint(8) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`value` varchar(2048) NOT NULL DEFAULT '',
PRIMARY KEY (`group_id`,`name`))
ENGINE=InnoDB
COMMENT='Stores the Default User Group Graph Settings';

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_stats_daily` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`average` DOUBLE DEFAULT NULL,
`peak` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=InnoDB;

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_stats_hourly` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`average` DOUBLE DEFAULT NULL,
`peak` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=InnoDB;

[Success]
CREATE TABLE IF NOT EXISTS `data_source_stats_hourly_cache` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`time` timestamp NOT NULL default '0000-00-00 00:00:00',
`value` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`time`,`rrd_name`),
KEY `time` USING BTREE (`time`)
) ENGINE=MEMORY;

[Success]
CREATE TABLE IF NOT EXISTS `data_source_stats_hourly_last` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`value` DOUBLE DEFAULT NULL,
`calculated` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=MEMORY;

[Success]
ALTER TABLE `data_source_stats_hourly_last` ADD `calculated`

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_stats_monthly` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`average` DOUBLE DEFAULT NULL,
`peak` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=InnoDB;

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_stats_weekly` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`average` DOUBLE DEFAULT NULL,
`peak` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=InnoDB;

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_stats_yearly` (
`local_data_id` mediumint(8) unsigned NOT NULL,
`rrd_name` varchar(19) NOT NULL,
`average` DOUBLE DEFAULT NULL,
`peak` DOUBLE DEFAULT NULL,
PRIMARY KEY (`local_data_id`,`rrd_name`)
) ENGINE=InnoDB;

[Fail]
CREATE TABLE IF NOT EXISTS `poller_output_boost` (
`local_data_id` mediumint(8) unsigned NOT NULL default '0',
`rrd_name` varchar(19) NOT NULL default '',
`time` timestamp NOT NULL default '0000-00-00 00:00:00',
`output` varchar(512) NOT NULL,
PRIMARY KEY USING BTREE (`local_data_id`,`rrd_name`,`time`)
) ENGINE=InnoDB;

[Success]
CREATE TABLE IF NOT EXISTS `poller_output_boost_processes` (
`sock_int_value` bigint(20) unsigned NOT NULL auto_increment,
`status` varchar(255) default NULL,
PRIMARY KEY (`sock_int_value`))
ENGINE=MEMORY;

[Fail]
CREATE TABLE IF NOT EXISTS `user_domains` (
`domain_id` int(10) unsigned NOT NULL auto_increment,
`domain_name` varchar(20) NOT NULL,
`type` int(10) UNSIGNED NOT NULL DEFAULT '0',
`enabled` char(2) NOT NULL DEFAULT 'on',
`defdomain` tinyint(3) NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`domain_id`))
ENGINE=InnoDB
COMMENT='Table to Hold Login Domains';

[Fail]
CREATE TABLE IF NOT EXISTS `user_domains_ldap` (
`domain_id` int(10) unsigned NOT NULL,
`server` varchar(128) NOT NULL,
`port` int(10) unsigned NOT NULL,
`port_ssl` int(10) unsigned NOT NULL,
`proto_version` tinyint(3) unsigned NOT NULL,
`encryption` tinyint(3) unsigned NOT NULL,
`referrals` tinyint(3) unsigned NOT NULL,
`mode` tinyint(3) unsigned NOT NULL,
`dn` varchar(128) NOT NULL,
`group_require` char(2) NOT NULL,
`group_dn` varchar(128) NOT NULL,
`group_attrib` varchar(128) NOT NULL,
`group_member_type` tinyint(3) unsigned NOT NULL,
`search_base` varchar(128) NOT NULL,
`search_filter` varchar(128) NOT NULL,
`specific_dn` varchar(128) NOT NULL,
`specific_password` varchar(128) NOT NULL,
PRIMARY KEY (`domain_id`))
ENGINE=InnoDB
COMMENT='Table to Hold Login Domains for LDAP';

[Success]
RENAME TABLE `plugin_snmpagent_cache` TO `snmpagent_cache`

[Fail]
CREATE TABLE IF NOT EXISTS `snmpagent_cache` (
`oid` varchar(191) NOT NULL,
`name` varchar(191) NOT NULL,
`mib` varchar(191) NOT NULL,
`type` varchar(255) NOT NULL DEFAULT '',
`otype` varchar(255) NOT NULL DEFAULT '',
`kind` varchar(255) NOT NULL DEFAULT '',
`max-access` varchar(255) NOT NULL DEFAULT 'not-accessible',
`value` varchar(255) NOT NULL DEFAULT '',
`description` varchar(5000) NOT NULL DEFAULT '',
PRIMARY KEY (`oid`),
KEY `name` (`name`),
KEY `mib` (`mib`))
ENGINE=InnoDB
COMMENT='SNMP MIB CACHE';

[Success]
RENAME TABLE `plugin_snmpagent_mibs` TO `snmpagent_mibs`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_mibs` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL DEFAULT '',
`file` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Registered MIB files';

[Success]
RENAME TABLE `plugin_snmpagent_cache_notifications` TO `snmpagent_cache_notifications`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_cache_notifications` (
`name` varchar(191) NOT NULL,
`mib` varchar(255) NOT NULL,
`attribute` varchar(255) NOT NULL,
`sequence_id` smallint(6) NOT NULL,
KEY `name` (`name`))
ENGINE=InnoDB
COMMENT='Notifcations and related attributes';

[Success]
RENAME TABLE `plugin_snmpagent_cache_textual_conventions` TO `snmpagent_cache_textual_conventions`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_cache_textual_conventions` (
`name` varchar(191) NOT NULL,
`mib` varchar(191) NOT NULL,
`type` varchar(255) NOT NULL DEFAULT '',
`description` varchar(5000) NOT NULL DEFAULT '',
KEY `name` (`name`),
KEY `mib` (`mib`))
ENGINE=InnoDB
COMMENT='Textual conventions';

[Success]
RENAME TABLE `plugin_snmpagent_managers` TO `snmpagent_managers`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_managers` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`hostname` varchar(100) NOT NULL,
`description` varchar(255) NOT NULL,
`disabled` char(2) DEFAULT NULL,
`max_log_size` tinyint(1) NOT NULL,
`snmp_version` varchar(255) NOT NULL,
`snmp_community` varchar(255) NOT NULL,
`snmp_username` varchar(255) NOT NULL,
`snmp_auth_password` varchar(255) NOT NULL,
`snmp_auth_protocol` varchar(255) NOT NULL,
`snmp_priv_password` varchar(255) NOT NULL,
`snmp_priv_protocol` varchar(255) NOT NULL,
`snmp_engine_id` varchar(64) NOT NULL DEFAULT '80005d750302FFFFFFFFFF',
`snmp_port` varchar(255) NOT NULL,
`snmp_message_type` tinyint(1) NOT NULL,
`notes` text,
PRIMARY KEY (`id`),
KEY `hostname` (`hostname`))
ENGINE=InnoDB
COMMENT='snmp notification receivers';

[Success]
RENAME TABLE `plugin_snmpagent_managers_notifications` TO `snmpagent_managers_notifications`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_managers_notifications` (
`manager_id` int(8) NOT NULL,
`notification` varchar(190) NOT NULL,
`mib` varchar(191) NOT NULL,
KEY `mib` (`mib`),
KEY `manager_id` (`manager_id`),
KEY `manager_id2` (`manager_id`,`notification`))
ENGINE=InnoDB
COMMENT='snmp notifications to receivers';

[Success]
RENAME TABLE `plugin_snmpagent_notifications_log` TO `snmpagent_notifications_log`

[Success]
CREATE TABLE IF NOT EXISTS `snmpagent_notifications_log` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`time` int(24) NOT NULL,
`severity` tinyint(1) NOT NULL,
`manager_id` int(8) NOT NULL,
`notification` varchar(190) NOT NULL,
`mib` varchar(191) NOT NULL,
`varbinds` varchar(5000) NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `severity` (`severity`),
KEY `manager_id` (`manager_id`),
KEY `manager_id2` (`manager_id`,`notification`))
ENGINE=InnoDB
COMMENT='logs snmp notifications to receivers';

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_purge_temp` (
`id` integer UNSIGNED auto_increment,
`name_cache` varchar(255) NOT NULL default '',
`local_data_id` mediumint(8) unsigned NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`size` integer UNSIGNED NOT NULL default '0',
`last_mod` TIMESTAMP NOT NULL default '0000-00-00 00:00:00',
`in_cacti` tinyint NOT NULL default '0',
`data_template_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY name (`name`),
KEY local_data_id (`local_data_id`),
KEY in_cacti (`in_cacti`),
KEY data_template_id (`data_template_id`))
ENGINE=InnoDB
COMMENT='RRD Cleaner File Repository';

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_purge_action` (
`id` integer UNSIGNED auto_increment,
`name` varchar(128) NOT NULL default '',
`local_data_id` mediumint(8) unsigned NOT NULL default '0',
`action` tinyint(2) NOT NULL default 0,
PRIMARY KEY (`id`),
UNIQUE KEY name (`name`))
ENGINE=InnoDB
COMMENT='RRD Cleaner File Actions';

[Success]
ALTER TABLE `graph_tree` ADD `enabled`

[Success]
ALTER TABLE `graph_tree` ADD `locked`

[Success]
ALTER TABLE `graph_tree` ADD `locked_date`

[Success]
ALTER TABLE `graph_tree` ADD `last_modified`

[Success]
ALTER TABLE `graph_tree` ADD `user_id`

[Success]
ALTER TABLE `graph_tree` ADD `modified_by`

[Success]
ALTER TABLE `graph_tree_items` ADD `parent`

[Success]
ALTER TABLE `graph_tree_items` ADD `position`

[Success]
ALTER TABLE graph_tree_items MODIFY COLUMN id BIGINT UNSIGNED NOT NULL auto_increment

[Success]
ALTER TABLE `graph_tree_items` ADD INDEX parent(parent)

[Success]
DROP TABLE IF EXISTS `user_auth_cache`

[Fail]
CREATE TABLE `user_auth_cache` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`hostname` varchar(64) NOT NULL DEFAULT '',
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`token` varchar(191) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `tokenkey` (`token`),
KEY `hostname` (`hostname`),
KEY `user_id` (`user_id`))
ENGINE=InnoDB
COMMENT='Caches Remember Me Details'

[Success]
ALTER TABLE host
MODIFY COLUMN status_fail_date timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
MODIFY COLUMN status_rec_date timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Success]
ALTER TABLE poller
MODIFY COLUMN last_update timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Success]
ALTER TABLE poller_command
MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Fail]
ALTER TABLE poller_output
MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Success]
ALTER TABLE poller_time
MODIFY COLUMN start_time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
MODIFY COLUMN end_time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Success]
ALTER TABLE user_log
MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'

[Success]
ALTER TABLE `user_auth` ADD `lastchange`

[Success]
ALTER TABLE `user_auth` ADD `lastlogin`

[Success]
ALTER TABLE `user_auth` ADD `password_history`

[Success]
ALTER TABLE `user_auth` ADD `locked`

[Success]
ALTER TABLE `user_auth` ADD `failed_attempts`

[Success]
ALTER TABLE `user_auth` ADD `lastfail`

[Success]
ALTER TABLE `graph_tree_items` DROP `order_key`

[Success]
DELETE FROM plugin_realms WHERE file LIKE 'clog%'

[Success]
DELETE FROM plugin_config WHERE directory='clog'

[Success]
DELETE FROM plugin_hooks WHERE name='clog'

[Success]
ALTER TABLE `user_auth` ADD `email_address`

[Success]
ALTER TABLE `user_auth` ADD `password_change`

[Skipped]
DROP TABLE `poller_output_realtime`

[Fail]
CREATE TABLE poller_output_realtime (
local_data_id mediumint(8) unsigned NOT NULL default '0',
rrd_name varchar(19) NOT NULL default '',
time timestamp NOT NULL default '0000-00-00 00:00:00',
output text NOT NULL,
poller_id varchar(256) NOT NULL default '',
PRIMARY KEY (local_data_id,rrd_name,`time`),
KEY poller_id(poller_id(191)))
ENGINE=InnoDB

[Success]
DROP TABLE `poller_output_rt`

[Success]
DELETE FROM plugin_realms WHERE file LIKE '%graph_image_rt%'

[Success]
DELETE FROM plugin_config WHERE directory='realtime'

[Success]
DELETE FROM plugin_hooks WHERE name='realtime'

[Success]
RENAME TABLE `plugin_nectar` TO `reports`

[Success]
RENAME TABLE `plugin_nectar_items` TO `reports_items`

[Fail]
UPDATE settings SET name=REPLACE(name, 'nectar','reports') WHERE name LIKE '%nectar%'

[Success]
ALTER TABLE `reports` ADD `bcc`

[Success]
ALTER TABLE `reports` ADD `from_name`

[Success]
ALTER TABLE `reports` ADD `user_id`

[Success]
ALTER TABLE `reports` ADD `graph_width`

[Success]
ALTER TABLE `reports` ADD `graph_height`

[Success]
ALTER TABLE `reports` ADD `graph_columns`

[Success]
ALTER TABLE `reports` ADD `thumbnails`

[Success]
ALTER TABLE `reports` ADD `font_size`

[Success]
ALTER TABLE `reports` ADD `alignment`

[Success]
ALTER TABLE `reports` ADD `cformat`

[Success]
ALTER TABLE `reports` ADD `format_file`

[Success]
ALTER TABLE `reports` ADD `graph_linked`

[Success]
ALTER TABLE `reports` ADD `subject`

[Success]
ALTER TABLE `reports_items` ADD `host_template_id`

[Success]
ALTER TABLE `reports_items` ADD `graph_template_id`

[Success]
ALTER TABLE `reports_items` ADD `tree_id`

[Success]
ALTER TABLE `reports_items` ADD `branch_id`

[Success]
ALTER TABLE `reports_items` ADD `tree_cascade`

[Success]
ALTER TABLE `reports_items` ADD `graph_name_regexp`

[Success]
ALTER TABLE `host` ADD `snmp_sysDescr`

[Success]
ALTER TABLE `host` ADD `snmp_sysObjectID`

[Success]
ALTER TABLE `host` ADD `snmp_sysUpTimeInstance`

[Success]
ALTER TABLE `host` ADD `snmp_sysContact`

[Success]
ALTER TABLE `host` ADD `snmp_sysName`

[Success]
ALTER TABLE `host` ADD `snmp_sysLocation`

[Success]
ALTER TABLE `host` ADD `polling_time`

[Success]
INSERT IGNORE INTO user_auth_realm VALUES (18,1)

[Success]
INSERT IGNORE INTO user_auth_realm VALUES (20,1)

[Success]
INSERT IGNORE INTO user_auth_realm VALUES (21,1)

[Success]
ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `t_graph_type_id`

[Success]
ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `graph_type_id`

[Success]
ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `t_cdef_id`

[Success]
ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `cdef_id`

[Success]
ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `t_graph_type_id`

[Success]
ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `graph_type_id`

[Success]
ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `t_cdef_id`

[Success]
ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `cdef_id`

[Fail]
RENAME TABLE `plugin_aggregate_color_template_items` TO `color_template_items`

[Fail]
RENAME TABLE `plugin_aggregate_color_templates` TO `color_templates`

[Fail]
RENAME TABLE `plugin_aggregate_graph_templates` TO `aggregate_graph_templates`

[Fail]
RENAME TABLE `plugin_aggregate_graph_templates_graph` TO `aggregate_graph_templates_graph`

[Fail]
RENAME TABLE `plugin_aggregate_graph_templates_item` TO `aggregate_graph_templates_item`

[Fail]
RENAME TABLE `plugin_aggregate_graphs` TO `aggregate_graphs`

[Fail]
RENAME TABLE `plugin_aggregate_graphs_graph_item` TO `aggregate_graphs_graph_item`

[Fail]
RENAME TABLE `plugin_aggregate_graphs_items` TO `aggregate_graphs_items`

[Success]
DELETE FROM plugin_config WHERE directory='aggregate'

[Success]
DELETE FROM plugin_realms WHERE plugin='aggregate'

[Success]
DELETE FROM plugin_db_changes WHERE plugin='aggregate'

[Success]
DELETE FROM plugin_hooks WHERE name='aggregate'

[Success]
RENAME TABLE `plugin_autom8_graph_rules` TO `automation_graph_rules`

[Success]
RENAME TABLE `plugin_autom8_graph_rule_items` TO `automation_graph_rule_items`

[Success]
RENAME TABLE `plugin_autom8_match_rule_items` TO `automation_match_rule_items`

[Success]
RENAME TABLE `plugin_autom8_tree_rules` TO `automation_tree_rules`

[Success]
RENAME TABLE `plugin_autom8_tree_rule_items` TO `automation_tree_rule_items`

[Success]
DELETE FROM plugin_config WHERE directory='autom8'

[Success]
DELETE FROM plugin_realms WHERE plugin='autom8'

[Success]
DELETE FROM plugin_db_changes WHERE plugin='autom8'

[Success]
DELETE FROM plugin_hooks WHERE name='autom8'

[Fail]
UPDATE settings SET name=REPLACE(name, 'autom8', 'automation') WHERE name LIKE 'autom8%'

[Success]
RENAME TABLE `plugin_discover_hosts` TO `automation_devices`

[Success]
ALTER TABLE `automation_devices` DROP `hash`

[Success]
ALTER TABLE automation_devices
ADD COLUMN id BIGINT unsigned auto_increment FIRST,
ADD COLUMN network_id INT unsigned NOT NULL default '0' AFTER id,
ADD COLUMN snmp_port int(10) unsigned NOT NULL DEFAULT '161' AFTER snmp_version,
ADD COLUMN snmp_engine_id varchar(30) DEFAULT '' AFTER snmp_context,
DROP PRIMARY KEY,
ADD PRIMARY KEY(id),
ADD UNIQUE INDEX ip(ip);
ADD INDEX network_id(network_id),
COMMENT='Table of Discovered Devices'

[Success]
RENAME TABLE `plugin_discover_template` TO `automation_templates`

[Success]
ALTER TABLE automation_templates
CHANGE COLUMN sysdescr sysDescr VARCHAR(255) DEFAULT ''

[Success]
ALTER TABLE `automation_templates` ADD `availability_method`

[Success]
ALTER TABLE `automation_templates` ADD `sysName`

[Success]
ALTER TABLE `automation_templates` ADD `sysOid`

[Success]
ALTER TABLE `automation_templates` ADD `sequence`

[Success]
ALTER TABLE `automation_templates` DROP `tree`

[Success]
ALTER TABLE `automation_templates` DROP `snmp_version`

[Success]
UPDATE automation_templates SET sequence=id

[Success]
CREATE TABLE IF NOT EXISTS `automation_devices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`network_id` int(10) unsigned NOT NULL DEFAULT '0',
`hostname` varchar(100) NOT NULL DEFAULT '',
`ip` varchar(17) NOT NULL DEFAULT '',
`community` varchar(100) NOT NULL DEFAULT '',
`snmp_version` tinyint(1) unsigned NOT NULL DEFAULT '1',
`snmp_port` int(10) unsigned NOT NULL DEFAULT '161',
`snmp_username` varchar(50) DEFAULT NULL,
`snmp_password` varchar(50) DEFAULT NULL,
`snmp_auth_protocol` char(5) DEFAULT '',
`snmp_priv_passphrase` varchar(200) DEFAULT '',
`snmp_priv_protocol` char(6) DEFAULT '',
`snmp_context` varchar(64) DEFAULT '',
`snmp_engine_id` varchar(30) DEFAULT '',
`sysName` varchar(100) NOT NULL DEFAULT '',
`sysLocation` varchar(255) NOT NULL DEFAULT '',
`sysContact` varchar(255) NOT NULL DEFAULT '',
`sysDescr` varchar(255) NOT NULL DEFAULT '',
`sysUptime` int(32) NOT NULL DEFAULT '0',
`os` varchar(64) NOT NULL DEFAULT '',
`snmp` tinyint(4) NOT NULL DEFAULT '0',
`known` tinyint(4) NOT NULL DEFAULT '0',
`up` tinyint(4) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `ip` (`ip`),
KEY `hostname` (`hostname`))
ENGINE=InnoDB
COMMENT='Table of Discovered Devices'

[Success]
CREATE TABLE IF NOT EXISTS `automation_ips` (
`ip_address` varchar(20) NOT NULL DEFAULT '',
`hostname` varchar(250) DEFAULT NULL,
`network_id` int(10) unsigned DEFAULT NULL,
`pid` int(10) unsigned DEFAULT NULL,
`status` int(10) unsigned DEFAULT NULL,
`thread` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`ip_address`),
KEY `pid` (`pid`))
ENGINE=MEMORY
COMMENT='List of discoverable ip addresses used for scanning'

[Fail]
CREATE TABLE IF NOT EXISTS `automation_networks` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`poller_id` int(10) unsigned DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The name for this network',
`subnet_range` varchar(255) NOT NULL DEFAULT '' COMMENT 'Defined subnet ranges for discovery',
`dns_servers` varchar(128) NOT NULL DEFAULT '' COMMENT 'DNS Servers to use for name resolution',
`enabled` char(2) DEFAULT '',
`snmp_id` int(10) unsigned DEFAULT NULL,
`enable_netbios` char(2) DEFAULT '',
`add_to_cacti` char(2) DEFAULT '',
`total_ips` int(10) unsigned DEFAULT '0',
`up_hosts` int(10) unsigned NOT NULL DEFAULT '0',
`snmp_hosts` int(10) unsigned NOT NULL DEFAULT '0',
`ping_method` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The ping method (ICMP:TCP:UDP)',
`ping_port` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'For TCP:UDP the port to ping',
`ping_timeout` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The ping timeout in seconds',
`ping_retries` int(10) unsigned DEFAULT '0',
`sched_type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Schedule type: manual or automatic',
`threads` int(10) unsigned DEFAULT '1',
`run_limit` int(10) unsigned NULL DEFAULT '0' COMMENT 'The maximum runtime for the discovery',
`start_at` varchar(20) DEFAULT NULL,
`next_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`recur_every` int(10) unsigned DEFAULT '1',
`day_of_week` varchar(45) DEFAULT NULL COMMENT 'The days of week to run in crontab format',
`month` varchar(45) DEFAULT NULL COMMENT 'The months to run in crontab format',
`day_of_month` varchar(45) DEFAULT NULL COMMENT 'The days of month to run in crontab format',
`monthly_week` varchar(45) DEFAULT NULL,
`monthly_day` varchar(45) DEFAULT NULL,
`last_runtime` double NOT NULL DEFAULT '0' COMMENT 'The last runtime for discovery',
`last_started` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the discovery last started',
`last_status` varchar(128) NOT NULL DEFAULT '' COMMENT 'The last exit message if any',
`rerun_data_queries` char(2) DEFAULT NULL COMMENT 'Rerun data queries or not for existing hosts',
PRIMARY KEY (`id`),
KEY `poller_id` (`poller_id`))
ENGINE=InnoDB
COMMENT='Stores scanning subnet definitions'

[Success]
CREATE TABLE IF NOT EXISTS `automation_processes` (
`pid` int(8) unsigned NOT NULL,
`poller_id` int(10) unsigned DEFAULT '0',
`network_id` int(10) unsigned NOT NULL DEFAULT '0',
`task` varchar(20) NULL DEFAULT '',
`status` varchar(20) DEFAULT NULL,
`command` varchar(20) DEFAULT NULL,
`up_hosts` int(10) unsigned DEFAULT '0',
`snmp_hosts` int(10) unsigned DEFAULT '0',
`heartbeat` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`pid`, `network_id`))
ENGINE=MEMORY
COMMENT='Table tracking active poller processes'

[Fail]
CREATE TABLE IF NOT EXISTS `automation_snmp` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Group of SNMP Option Sets'

[Fail]
CREATE TABLE IF NOT EXISTS `automation_snmp_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`snmp_id` int(10) unsigned NOT NULL DEFAULT '0',
`sequence` int(10) unsigned NOT NULL DEFAULT '0',
`snmp_version` varchar(100) NOT NULL DEFAULT '',
`snmp_readstring` varchar(100) NOT NULL,
`snmp_port` int(10) NOT NULL DEFAULT '161',
`snmp_timeout` int(10) unsigned NOT NULL DEFAULT '500',
`snmp_retries` tinyint(11) unsigned NOT NULL DEFAULT '3',
`max_oids` int(12) unsigned DEFAULT '10',
`snmp_username` varchar(50) DEFAULT NULL,
`snmp_password` varchar(50) DEFAULT NULL,
`snmp_auth_protocol` char(5) DEFAULT '',
`snmp_priv_passphrase` varchar(200) DEFAULT '',
`snmp_priv_protocol` char(6) DEFAULT '',
`snmp_context` varchar(64) DEFAULT '',
PRIMARY KEY (`id`,`snmp_id`))
ENGINE=InnoDB
COMMENT='Set of SNMP Options'

[Success]
CREATE TABLE IF NOT EXISTS `automation_templates` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`host_template` int(8) NOT NULL DEFAULT '0',
`availability_method` int(10) unsigned DEFAULT '2',
`sysDescr` varchar(255) NULL DEFAULT '',
`sysName` varchar(255) NULL DEFAULT '',
`sysOid` varchar(60) NULL DEFAULT '',
`sequence` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Templates of SNMP Sys variables used for automation'

[Success]
DELETE FROM plugin_config WHERE directory='discovery'

[Success]
DELETE FROM plugin_realms WHERE plugin='discovery'

[Success]
DELETE FROM plugin_db_changes WHERE plugin='discovery'

[Success]
DELETE FROM plugin_hooks WHERE name='discovery'

[Success]
UPDATE automation_match_rule_items SET field=REPLACE(field, 'host_template.', 'ht.')

[Success]
UPDATE automation_match_rule_items SET field=REPLACE(field, 'host.', 'h.')

[Success]
UPDATE automation_match_rule_items SET field=REPLACE(field, 'graph_templates.', 'gt.')

[Success]
UPDATE automation_match_rule_items SET field=REPLACE(field, 'graph_templates_graph.', 'gtg.')

[Success]
INSERT IGNORE INTO user_auth_realm (user_id, realm_id) VALUES (1, 23)

[Success]
ALTER TABLE `colors` ADD UNIQUE INDEX hex(hex)

[Success]
ALTER TABLE `colors` ADD `name`

[Success]
ALTER TABLE `colors` ADD `read_only`

[Fail]
ALTER TABLE settings MODIFY COLUMN value varchar(2048) NOT NULL default ''

[Success]
ALTER TABLE settings_graphs MODIFY COLUMN value varchar(2048) NOT NULL default ''

[Success]
ALTER TABLE user_auth MODIFY COLUMN password varchar(2048) NOT NULL default ''

[Success]
RENAME TABLE `settings_graphs` TO `settings_user`

[Success]
ALTER TABLE `user_auth` ADD `reset_perms`

[Success]
ALTER TABLE `graph_templates_item` ADD `vdef_id`

[Success]
ALTER TABLE `graph_templates_item` ADD `line_width`

[Success]
ALTER TABLE `graph_templates_item` ADD `dashes`

[Success]
ALTER TABLE `graph_templates_item` ADD `dash_offset`

[Success]
ALTER TABLE `graph_templates_item` ADD `shift`

[Success]
ALTER TABLE `graph_templates_item` ADD `textalign`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_alt_y_grid`

[Success]
ALTER TABLE `graph_templates_graph` ADD `alt_y_grid`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_right_axis`

[Success]
ALTER TABLE `graph_templates_graph` ADD `right_axis`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_right_axis_label`

[Success]
ALTER TABLE `graph_templates_graph` ADD `right_axis_label`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_right_axis_format`

[Success]
ALTER TABLE `graph_templates_graph` ADD `right_axis_format`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_right_axis_formatter`

[Success]
ALTER TABLE `graph_templates_graph` ADD `right_axis_formatter`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_left_axis_formatter`

[Success]
ALTER TABLE `graph_templates_graph` ADD `left_axis_formatter`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_no_gridfit`

[Success]
ALTER TABLE `graph_templates_graph` ADD `no_gridfit`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_unit_length`

[Success]
ALTER TABLE `graph_templates_graph` ADD `unit_length`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_tab_width`

[Success]
ALTER TABLE `graph_templates_graph` ADD `tab_width`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_dynamic_labels`

[Success]
ALTER TABLE `graph_templates_graph` ADD `dynamic_labels`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_force_rules_legend`

[Success]
ALTER TABLE `graph_templates_graph` ADD `force_rules_legend`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_legend_position`

[Success]
ALTER TABLE `graph_templates_graph` ADD `legend_position`

[Success]
ALTER TABLE `graph_templates_graph` ADD `t_legend_direction`

[Success]
ALTER TABLE `graph_templates_graph` ADD `legend_direction`

[Success]
REPLACE INTO `user_auth_realm` VALUES (19,1);

[Success]
REPLACE INTO `user_auth_realm` VALUES (22,1);

[Fail]
REPLACE INTO `vdef` VALUES (1, 'e06ed529238448773038601afb3cf278', 'Maximum');

[Fail]
REPLACE INTO `vdef` VALUES (2, 'e4872dda82092393d6459c831a50dc3b', 'Minimum');

[Fail]
REPLACE INTO `vdef` VALUES (3, '5ce1061a46bb62f36840c80412d2e629', 'Average');

[Fail]
REPLACE INTO `vdef` VALUES (4, '06bd3cbe802da6a0745ea5ba93af554a', 'Last (Current)');

[Fail]
REPLACE INTO `vdef` VALUES (5, '631c1b9086f3979d6dcf5c7a6946f104', 'First');

[Fail]
REPLACE INTO `vdef` VALUES (6, '6b5335843630b66f858ce6b7c61fc493', 'Total: Current Data Source');

[Fail]
REPLACE INTO `vdef` VALUES (7, 'c80d12b0f030af3574da68b28826cd39', '95th Percentage: Current Data Source');

[Fail]
REPLACE INTO `vdef_items` VALUES (1, '88d33bf9271ac2bdf490cf1784a342c1', 1, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (2, 'a307afab0c9b1779580039e3f7c4f6e5', 1, 2, 1, '1');

[Fail]
REPLACE INTO `vdef_items` VALUES (3, '0945a96068bb57c80bfbd726cf1afa02', 2, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (4, '95a8df2eac60a89e8a8ca3ea3d019c44', 2, 2, 1, '2');

[Fail]
REPLACE INTO `vdef_items` VALUES (5, 'cc2e1c47ec0b4f02eb13708cf6dac585', 3, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (6, 'a2fd796335b87d9ba54af6a855689507', 3, 2, 1, '3');

[Fail]
REPLACE INTO `vdef_items` VALUES (7, 'a1d7974ee6018083a2053e0d0f7cb901', 4, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (8, '26fccba1c215439616bc1b83637ae7f3', 4, 2, 1, '5');

[Fail]
REPLACE INTO `vdef_items` VALUES (9, 'a8993b265f4c5398f4a47c44b5b37a07', 5, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (10, '5a380d469d611719057c3695ce1e4eee', 5, 2, 1, '6');

[Fail]
REPLACE INTO `vdef_items` VALUES (11, '65cfe546b17175fad41fcca98c057feb', 6, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (12, 'f330b5633c3517d7c62762cef091cc9e', 6, 2, 1, '7');

[Fail]
REPLACE INTO `vdef_items` VALUES (13, 'f1bf2ecf54ca0565cf39c9c3f7e5394b', 7, 1, 4, 'CURRENT_DATA_SOURCE');

[Fail]
REPLACE INTO `vdef_items` VALUES (14, '11a26f18feba3919be3af426670cba95', 7, 2, 6, '95');

[Fail]
REPLACE INTO `vdef_items` VALUES (15, 'e7ae90275bc1efada07c19ca3472d9db', 7, 3, 1, '8');

[Success]
ALTER TABLE `data_template_data` ADD `t_data_source_profile_id`

[Success]
ALTER TABLE `data_template_data` ADD `data_source_profile_id`

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_profiles` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`hash` varchar(32) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`step` int(10) unsigned NOT NULL DEFAULT '300',
`heartbeat` int(10) unsigned NOT NULL DEFAULT '600',
`x_files_factor` double DEFAULT '0.5',
`default` char(2) DEFAULT '',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Stores Data Source Profiles'

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_profiles_cf` (
`data_source_profile_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`consolidation_function_id` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`data_source_profile_id`,`consolidation_function_id`),
KEY `data_source_profile_id` (`data_source_profile_id`))
ENGINE=InnoDB
COMMENT='Maps the Data Source Profile Consolidation Functions'

[Fail]
CREATE TABLE IF NOT EXISTS `data_source_profiles_rra` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`data_source_profile_id` mediumint(8) unsigned not null default '0',
`name` varchar(255) NOT NULL DEFAULT '',
`steps` int(10) unsigned DEFAULT '1',
`rows` int(10) unsigned NOT NULL DEFAULT '700',
PRIMARY KEY (`id`),
KEY `data_source_profile_id` (`data_source_profile_id`))
ENGINE=InnoDB
COMMENT='Stores RRA Definitions for Data Source Profiles'

[Fail]
INSERT INTO data_source_profiles_rra
(`data_source_profile_id`, `name`, `steps`, `rows`)
SELECT ''0'' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=1

[Fail]
REPLACE INTO data_source_profiles_cf
(data_source_profile_id, consolidation_function_id)
SELECT ''0'' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=1

[Fail]
INSERT INTO data_source_profiles_rra
(`data_source_profile_id`, `name`, `steps`, `rows`)
SELECT ''0'' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=2

[Fail]
REPLACE INTO data_source_profiles_cf
(data_source_profile_id, consolidation_function_id)
SELECT ''0'' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=2

[Fail]
INSERT INTO data_source_profiles_rra
(`data_source_profile_id`, `name`, `steps`, `rows`)
SELECT ''0'' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=3

[Fail]
REPLACE INTO data_source_profiles_cf
(data_source_profile_id, consolidation_function_id)
SELECT ''0'' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=3

[Fail]
INSERT INTO data_source_profiles_rra
(`data_source_profile_id`, `name`, `steps`, `rows`)
SELECT ''0'' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=4

[Fail]
REPLACE INTO data_source_profiles_cf
(data_source_profile_id, consolidation_function_id)
SELECT ''0'' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=4

[Success]
UPDATE data_template_data
SET data_source_profile_id='0'
WHERE data_template_data.id IN(
SELECT data_template_data_id
FROM (
SELECT data_template_data_id, GROUP_CONCAT(rra_id) AS pattern
FROM data_template_data_rra
GROUP BY data_template_data_id
HAVING pattern='1,2,3,4'
) AS rs);

[Success]
DROP TABLE `rra`

[Success]
DROP TABLE `rra_cf`

[Success]
DROP TABLE `data_template_data_rra`

[Success]
ALTER TABLE `data_template_data` DROP `t_rra_id`

[Success]
ALTER TABLE `automation_tree_rule_items` DROP `rra_id`

[Success]
ALTER TABLE `automation_tree_rules` DROP `rra_id`

[Success]
ALTER TABLE `graph_tree_items` DROP `rra_id`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_alt_y_grid`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `alt_y_grid`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_label`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_label`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_format`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_format`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_formatter`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_formatter`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_left_axis_formatter`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `left_axis_formatter`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_no_gridfit`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `no_gridfit`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_unit_length`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `unit_length`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_tab_width`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `tab_width`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_dynamic_labels`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `dynamic_labels`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_force_rules_legend`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `force_rules_legend`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_legend_position`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `legend_position`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `t_legend_direction`

[Fail]
ALTER TABLE `aggregate_graph_templates_graph` ADD `legend_direction`

[Success]
ALTER TABLE `cdef` ADD `system`

[Success]
UPDATE cdef SET system=1 WHERE name LIKE '\_%'

[Success]
ALTER TABLE data_local DROP INDEX data_template_id

[Success]
ALTER TABLE `data_local` ADD INDEX data_template_id(data_template_id)

[Success]
ALTER TABLE data_local DROP INDEX snmp_query_id

[Success]
ALTER TABLE `data_local` ADD INDEX snmp_query_id(snmp_query_id)

[Success]
ALTER TABLE poller
MODIFY COLUMN last_update TIMESTAMP NOT NULL default '0000-00-00'

[Fail]
CREATE TABLE IF NOT EXISTS poller_resource_cache (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
resource_type varchar(20) DEFAULT NULL,
md5sum varchar(32) DEFAULT NULL,
path varchar(191) DEFAULT NULL,
update_time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
contents longblob,
PRIMARY KEY (id),
UNIQUE KEY path (path))
ENGINE=InnoDB
COMMENT='Caches all scripts, resources files, and plugins'

[Success]
ALTER TABLE `host` ADD `poller_id`

[Success]
ALTER TABLE `host` ADD INDEX poller_id(poller_id)

[Fail]
CREATE TABLE IF NOT EXISTS `external_links` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sortorder` int(11) NOT NULL DEFAULT '0',
`enabled` char(2) DEFAULT 'on',
`contentfile` varchar(255) NOT NULL DEFAULT '',
`title` varchar(20) NOT NULL DEFAULT '',
`style` varchar(10) NOT NULL DEFAULT '',
`extendedstyle` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Stores External Link Information'

[Fail]
CREATE TABLE IF NOT EXISTS `sites` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`address1` varchar(100) DEFAULT '',
`address2` varchar(100) DEFAULT '',
`city` varchar(50) DEFAULT '',
`state` varchar(20) DEFAULT NULL,
`postal_code` varchar(20) DEFAULT '',
`country` varchar(30) DEFAULT '',
`timezone` varchar(40) DEFAULT '',
`latitude` decimal(13,10) NOT NULL DEFAULT '0.0000000000',
`longitude` decimal(13,10) NOT NULL DEFAULT '0.0000000000',
`alternate_id` varchar(30) DEFAULT '',
`notes` varchar(1024),
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `city` (`city`),
KEY `state` (`state`),
KEY `postal_code` (`postal_code`),
KEY `country` (`country`),
KEY `alternate_id` (`alternate_id`))
ENGINE=InnoDB
COMMENT='Contains information about customer sites';

[Success]
ALTER TABLE `host` ADD `site_id`

[Success]
ALTER TABLE host MODIFY COLUMN poller_id mediumint(8) unsigned default '1'

[Success]
ALTER TABLE `host` ADD INDEX site_id(site_id)

[Success]
DROP TABLE `poller`

[Fail]
CREATE TABLE `poller` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`disabled` char(2) DEFAULT '',
`name` varchar(30) DEFAULT NULL,
`notes` varchar(1024) DEFAULT '',
`status` int(10) unsigned NOT NULL DEFAULT '0',
`hostname` varchar(250) NOT NULL DEFAULT '',
`dbdefault` varchar(20) NOT NULL DEFAULT 'cacti',
`dbhost` varchar(64) NOT NULL DEFAULT '',
`dbuser` varchar(20) NOT NULL DEFAULT '',
`dbpass` varchar(64) NOT NULL DEFAULT '',
`dbport` int(10) unsigned DEFAULT '3306',
`dbssl` char(3) DEFAULT '',
`total_time` double DEFAULT '0',
`snmp` mediumint(8) unsigned DEFAULT '0',
`script` mediumint(8) unsigned DEFAULT '0',
`server` mediumint(8) unsigned DEFAULT '0',
`last_update` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_status` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`))
ENGINE=InnoDB
COMMENT='Pollers for Cacti'

[Fail]
INSERT INTO poller (id, name, hostname) VALUES (1, "Main Poller", "PSBENIT-CJF")

[Fail]
UPDATE automation_networks SET poller_id=1 WHERE poller_id=0

[Success]
UPDATE automation_processes SET poller_id=1 WHERE poller_id=0

[Success]
UPDATE host SET poller_id=1 WHERE poller_id=0

[Success]
UPDATE poller_command SET poller_id=1 WHERE poller_id=0

[Success]
UPDATE poller_item SET poller_id=1 WHERE poller_id=0

[Fail]
UPDATE poller_output_realtime SET poller_id=1 WHERE poller_id=0

[Success]
UPDATE poller_time SET poller_id=1 WHERE poller_id=0

[Fail]
ALTER TABLE sessions MODIFY COLUMN data MEDIUMBLOB

[Success]
ALTER TABLE `host` ADD `snmp_engine_id`

[Success]
ALTER TABLE `poller_item` ADD `snmp_engine_id`

[Fail]
ALTER TABLE `automation_snmp_items` ADD `snmp_engine_id`

[Success]
ALTER TABLE host MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE host MODIFY COLUMN site_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE `host` ADD `last_updated`

[Success]
ALTER TABLE `host` ADD INDEX last_updated(last_updated)

[Success]
ALTER TABLE `host_snmp_cache` ADD `last_updated`

[Success]
ALTER TABLE `host_snmp_cache` ADD INDEX last_updated(last_updated)

[Success]
ALTER TABLE `poller_item` ADD `last_updated`

[Success]
ALTER TABLE `poller_item` ADD INDEX last_updated(last_updated)

[Success]
ALTER TABLE `poller_command` ADD `last_updated`

[Success]
ALTER TABLE `poller_command` ADD INDEX last_updated(last_updated)

[Fail]
ALTER TABLE automation_networks MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE automation_processes MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE poller_command MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE poller_item MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE poller_time MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"

[Success]
ALTER TABLE `graph_local` ADD `snmp_query_graph_id`

[Success]
ALTER TABLE `graph_local` ADD INDEX snmp_query_graph_id(snmp_query_graph_id)

[Success]
UPDATE graph_local AS gl
INNER JOIN (
SELECT DISTINCT local_graph_id, task_item_id
FROM graph_templates_item
) AS gti
ON gl.id=gti.local_graph_id
INNER JOIN data_template_rrd AS dtr
ON gti.task_item_id=dtr.id
INNER JOIN data_template_data AS dtd
ON dtr.local_data_id=dtd.local_data_id
INNER JOIN data_input_fields AS dif
ON dif.data_input_id=dtd.data_input_id
INNER JOIN data_input_data AS did
ON did.data_template_data_id=dtd.id
AND did.data_input_field_id=dif.id
INNER JOIN snmp_query_graph_rrd AS sqgr
ON sqgr.snmp_query_graph_id=did.value
SET gl.snmp_query_graph_id=did.value
WHERE input_output='in'
AND type_code='output_type'
AND gl.snmp_query_id>0

[Success]
ALTER TABLE `graph_tree` ADD `sequence`

[Success]
Disabling monitor version 1.3 as it is not compatible with Cacti 1.1.29

[Success]
Disabling cycle version 2.3 as it is not compatible with Cacti 1.1.29

[Success]
Disabling settings version 0.72 as it is not compatible with Cacti 1.1.29

[Success]
Disabling thold version 0.5 as it is not compatible with Cacti 1.1.29

[Success]
Disabling intropage version 0.7 as it is not compatible with Cacti 1.1.29

[Success]
Disabling snmpagent version 0.2.2 as it is not compatible with Cacti 1.1.29

[Success]
Disabling usersettings version 0.1 as it is not compatible with Cacti 1.1.29

[Success]
Disabling ipsubnet version .4f as it is not compatible with Cacti 1.1.29

[Success]
Disabling nectar version 0.35a as it is not compatible with Cacti 1.1.29

[Success]
Disabling autom8thold version 1.0.0 as it is not compatible with Cacti 1.1.29

[Fail]
CREATE TABLE IF NOT EXISTS `poller_data_template_field_mappings` (
`data_template_id` int(10) unsigned NOT NULL DEFAULT '0',
`data_name` varchar(40) NOT NULL DEFAULT '',
`data_source_names` varchar(125) NOT NULL DEFAULT '',
`last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`data_template_id`,`data_name`,`data_source_names`))
ENGINE=InnoDB
COMMENT='Tracks mapping of Data Templates to their Data Source Names'

[Fail]
INSERT IGNORE INTO poller_data_template_field_mappings
SELECT dtr.data_template_id, dif.data_name, GROUP_CONCAT(dtr.data_source_name ORDER BY dtr.data_source_name) AS data_source_names, NOW()
FROM data_template_rrd AS dtr
INNER JOIN data_input_fields AS dif
ON dtr.data_input_field_id = dif.id
WHERE dtr.local_data_id=0
GROUP BY dtr.data_template_id, dif.data_name

[Success]
ALTER TABLE host_snmp_cache MODIFY COLUMN field_value varchar(512) DEFAULT NULL

[Success]
UPDATE graph_templates_graph SET t_auto_scale_opts='' WHERE t_auto_scale_opts IS NULL

[Success]
UPDATE graph_templates_graph SET t_auto_scale_opts='' WHERE t_auto_scale_opts='0'

[Success]
UPDATE graph_templates_graph SET t_auto_scale_log='' WHERE t_auto_scale_log IS NULL

[Success]
UPDATE graph_templates_graph SET t_auto_scale_log='' WHERE t_auto_scale_log='0'

[Success]
UPDATE graph_templates_graph SET t_scale_log_units='' WHERE t_scale_log_units IS NULL

[Success]
UPDATE graph_templates_graph SET t_scale_log_units='' WHERE t_scale_log_units='0'

[Success]
UPDATE graph_templates_graph SET t_auto_scale_rigid='' WHERE t_auto_scale_rigid IS NULL

[Success]
UPDATE graph_templates_graph SET t_auto_scale_rigid='' WHERE t_auto_scale_rigid='0'

[Success]
UPDATE graph_templates_graph SET t_auto_padding='' WHERE t_auto_padding IS NULL

[Success]
UPDATE graph_templates_graph SET t_auto_padding='' WHERE t_auto_padding='0'

[Success]
UPDATE graph_templates_graph SET t_base_value='' WHERE t_base_value IS NULL

[Success]
UPDATE graph_templates_graph SET t_base_value='' WHERE t_base_value='0'

[Success]
UPDATE graph_templates_graph SET t_grouping='' WHERE t_grouping IS NULL

[Success]
UPDATE graph_templates_graph SET t_grouping='' WHERE t_grouping='0'

[Success]
UPDATE graph_templates_graph SET t_unit_value='' WHERE t_unit_value IS NULL

[Success]
UPDATE graph_templates_graph SET t_unit_value='' WHERE t_unit_value='0'

[Success]
UPDATE graph_templates_graph SET t_unit_exponent_value='' WHERE t_unit_exponent_value IS NULL

[Success]
UPDATE graph_templates_graph SET t_unit_exponent_value='' WHERE t_unit_exponent_value='0'

[Success]
UPDATE graph_templates_graph SET t_alt_y_grid='' WHERE t_alt_y_grid IS NULL

[Success]
UPDATE graph_templates_graph SET t_alt_y_grid='' WHERE t_alt_y_grid='0'

[Success]
UPDATE graph_templates_graph SET t_right_axis='' WHERE t_right_axis IS NULL

[Success]
UPDATE graph_templates_graph SET t_right_axis='' WHERE t_right_axis='0'

[Success]
UPDATE graph_templates_graph SET t_right_axis_label='' WHERE t_right_axis_label IS NULL

[Success]
UPDATE graph_templates_graph SET t_right_axis_label='' WHERE t_right_axis_label='0'

[Success]
UPDATE graph_templates_graph SET t_right_axis_format='' WHERE t_right_axis_format IS NULL

[Success]
UPDATE graph_templates_graph SET t_right_axis_format='' WHERE t_right_axis_format='0'

[Success]
UPDATE graph_templates_graph SET t_right_axis_formatter='' WHERE t_right_axis_formatter IS NULL

[Success]
UPDATE graph_templates_graph SET t_right_axis_formatter='' WHERE t_right_axis_formatter='0'

[Success]
UPDATE graph_templates_graph SET t_left_axis_formatter='' WHERE t_left_axis_formatter IS NULL

[Success]
UPDATE graph_templates_graph SET t_left_axis_formatter='' WHERE t_left_axis_formatter='0'

[Success]
UPDATE graph_templates_graph SET t_no_gridfit='' WHERE t_no_gridfit IS NULL

[Success]
UPDATE graph_templates_graph SET t_no_gridfit='' WHERE t_no_gridfit='0'

[Success]
UPDATE graph_templates_graph SET t_unit_length='' WHERE t_unit_length IS NULL

[Success]
UPDATE graph_templates_graph SET t_unit_length='' WHERE t_unit_length='0'

[Success]
UPDATE graph_templates_graph SET t_tab_width='' WHERE t_tab_width IS NULL

[Success]
UPDATE graph_templates_graph SET t_tab_width='' WHERE t_tab_width='0'

[Success]
UPDATE graph_templates_graph SET t_dynamic_labels='' WHERE t_dynamic_labels IS NULL

[Success]
UPDATE graph_templates_graph SET t_dynamic_labels='' WHERE t_dynamic_labels='0'

[Success]
UPDATE graph_templates_graph SET t_force_rules_legend='' WHERE t_force_rules_legend IS NULL

[Success]
UPDATE graph_templates_graph SET t_force_rules_legend='' WHERE t_force_rules_legend='0'

[Success]
UPDATE graph_templates_graph SET t_legend_position='' WHERE t_legend_position IS NULL

[Success]
UPDATE graph_templates_graph SET t_legend_position='' WHERE t_legend_position='0'

[Success]
UPDATE graph_templates_graph SET t_legend_direction='' WHERE t_legend_direction IS NULL

[Success]
UPDATE graph_templates_graph SET t_legend_direction='' WHERE t_legend_direction='0'

[Success]
UPDATE graph_templates_graph SET t_image_format_id='' WHERE t_image_format_id IS NULL

[Success]
UPDATE graph_templates_graph SET t_image_format_id='' WHERE t_image_format_id='0'

[Success]
UPDATE graph_templates_graph SET t_title='' WHERE t_title IS NULL

[Success]
UPDATE graph_templates_graph SET t_title='' WHERE t_title='0'

[Success]
UPDATE graph_templates_graph SET t_height='' WHERE t_height IS NULL

[Success]
UPDATE graph_templates_graph SET t_height='' WHERE t_height='0'

[Success]
UPDATE graph_templates_graph SET t_width='' WHERE t_width IS NULL

[Success]
UPDATE graph_templates_graph SET t_width='' WHERE t_width='0'

[Success]
UPDATE graph_templates_graph SET t_upper_limit='' WHERE t_upper_limit IS NULL

[Success]
UPDATE graph_templates_graph SET t_upper_limit='' WHERE t_upper_limit='0'

[Success]
UPDATE graph_templates_graph SET t_lower_limit='' WHERE t_lower_limit IS NULL

[Success]
UPDATE graph_templates_graph SET t_lower_limit='' WHERE t_lower_limit='0'

[Success]
UPDATE graph_templates_graph SET t_vertical_label='' WHERE t_vertical_label IS NULL

[Success]
UPDATE graph_templates_graph SET t_vertical_label='' WHERE t_vertical_label='0'

[Success]
UPDATE graph_templates_graph SET t_slope_mode='' WHERE t_slope_mode IS NULL

[Success]
UPDATE graph_templates_graph SET t_slope_mode='' WHERE t_slope_mode='0'

[Success]
UPDATE graph_templates_graph SET t_auto_scale='' WHERE t_auto_scale IS NULL

[Success]
UPDATE graph_templates_graph SET t_auto_scale='' WHERE t_auto_scale='0'

[Success]
UPDATE graph_templates_graph SET unit_value='' WHERE unit_value='on'

[Success]
ALTER TABLE `data_local` ADD INDEX snmp_index(snmp_index(191))

[Success]
ALTER TABLE graph_local DROP INDEX snmp_index

[Success]
ALTER TABLE `graph_local` ADD INDEX snmp_index(snmp_index(191))


Version: 1.0.4

[Fail]
ALTER TABLE poller_output_boost DROP PRIMARY KEY, ADD PRIMARY KEY(`local_data_id`, `time`, `rrd_name`) USING BTREE


Version: 1.0.5

[Success]
ALTER TABLE host_snmp_cache MODIFY COLUMN snmp_index varchar(191) NOT NULL default ""

[Success]
ALTER TABLE poller_command MODIFY COLUMN command varchar(191) NOT NULL default ""

[Fail]
ALTER TABLE poller_data_template_field_mappings MODIFY COLUMN data_source_names varchar(191) NOT NULL default ""

[Success]
ALTER TABLE snmpagent_managers_notifications MODIFY COLUMN notification varchar(180) NOT NULL

[Success]
ALTER TABLE snmpagent_notifications_log MODIFY COLUMN notification varchar(180) NOT NULL

[Success]
ALTER TABLE poller_reindex DROP PRIMARY KEY, ADD PRIMARY KEY (host_id, data_query_id)

[Fail]
UPDATE data_template_data SET data_source_profile_id = WHERE data_source_profile_id = 0

[Success]
ALTER TABLE automation_devices MODIFY COLUMN snmp_engine_id VARCHAR(64) DEFAULT ""

[Fail]
ALTER TABLE automation_snmp_items MODIFY COLUMN snmp_engine_id VARCHAR(64) DEFAULT ""

[Success]
ALTER TABLE host MODIFY COLUMN snmp_engine_id VARCHAR(64) DEFAULT ""

[Success]
ALTER TABLE poller_item MODIFY COLUMN snmp_engine_id VARCHAR(64) DEFAULT ""

[Fail]
ALTER TABLE snmpagent_managers MODIFY COLUMN snmp_engine_id VARCHAR(64) DEFAULT ""

[Success]
ALTER TABLE host ADD COLUMN external_id VARCHAR(40) DEFAULT NULL AFTER notes

[Success]
ALTER TABLE host ADD INDEX external_id (external_id)


Version: 1.1.2

[Success]
ALTER TABLE `graph_templates_item`
DROP INDEX `local_graph_id`,
ADD INDEX `local_graph_id_sequence` (`local_graph_id`, `sequence`)

[Success]
ALTER TABLE `graph_tree_items`
DROP INDEX `parent`,
ADD INDEX `parent_position` (`parent`, `position`)

[Success]
ALTER TABLE `graph_template_input_defs`
COMMENT = 'Stores the relationship for what graph items are associated';

[Success]
ALTER TABLE `graph_tree` ADD INDEX `sequence` (`sequence`)

[Success]
UPDATE graph_templates_item SET hash="" WHERE local_graph_id>0


Version: 1.1.4

[Success]
ALTER TABLE `cdef` ADD INDEX (`hash`)

[Success]
ALTER TABLE `cdef_items`
DROP INDEX `cdef_id`,
ADD INDEX `cdef_id_sequence` (`cdef_id`, `sequence`)

[Success]
ALTER TABLE `data_input_fields`
DROP INDEX `type_code`,
ADD INDEX `type_code_data_input_id` (`type_code`, `data_input_id`)

[Fail]
ALTER TABLE `snmpagent_cache`
DROP INDEX `mib`,
ADD INDEX `mib_name` (`mib`, `name`)

[Success]
ALTER TABLE `host` ADD INDEX (`hostname`)

[Success]
ALTER TABLE `snmpagent_managers_notifications`
DROP INDEX `manager_id`,
DROP INDEX `manager_id2`,
ADD INDEX `manager_id_notification` (`manager_id`,`notification`)

[Success]
ALTER TABLE `snmpagent_notifications_log`
DROP INDEX `manager_id`,
DROP INDEX `manager_id2`,
ADD INDEX `manager_id_notification` (`manager_id`,`notification`)

[Success]
ALTER TABLE `user_log` DROP INDEX `username`

[Fail]
ALTER TABLE `vdef` ADD INDEX `hash` (`hash`)

[Success]
ALTER TABLE `graph_templates_item` ADD INDEX `lgi_gti` (`local_graph_id`, `graph_template_id`)

[Success]
ALTER TABLE `poller_item` ADD INDEX `poller_id_host_id` (`poller_id`, `host_id`)

[Fail]
ALTER TABLE `automation_networks` ADD COLUMN `site_id` INT UNSIGNED DEFAULT "1" AFTER `poller_id`

[Success]
ALTER TABLE `graph_tree_items`
ADD COLUMN `site_id` INT UNSIGNED DEFAULT "0" AFTER `host_id`,
ADD INDEX `site_id` (`site_id`)

[Success]
ALTER TABLE `graph_tree_items`
ADD COLUMN `graph_regex` VARCHAR(60) DEFAULT "" AFTER `sort_children_type`,
ADD COLUMN `host_regex` VARCHAR(60) DEFAULT "" AFTER `graph_regex`


Version: 1.1.6

[Success]
ALTER TABLE `data_input`
MODIFY COLUMN `input_string` varchar(512) default NULL

[Success]
ALTER TABLE `data_input`
ADD KEY `name_type_id` (`name`(171), `type_id`)

[Success]
ALTER TABLE `snmp_query_graph`
ADD KEY `graph_template_id_name` (`graph_template_id`, `name`)

[Success]
ALTER TABLE `graph_templates`
ADD `multiple` CHAR(2) NOT NULL DEFAULT '' AFTER `name`,
ADD KEY `multiple_name` (`multiple`, `name`(171))

[Success]
UPDATE graph_templates
SET multiple = 'on'
WHERE hash = '010b90500e1fc6a05abfd542940584d0'

[Fail]
ALTER TABLE poller_output
MODIFY COLUMN output VARCHAR(512) NOT NULL default '',
ENGINE=MEMORY

[Success]
ALTER TABLE `graph_templates_gprint`
ADD KEY `name` (`name`)

[Fail]
ALTER TABLE `data_source_profiles`
ADD KEY `name` (`name`(171))

[Success]
ALTER TABLE `cdef`
ADD KEY `name` (`name`(171))

[Fail]
ALTER TABLE `vdef`
ADD KEY `name` (`name`(171))

[Fail]
ALTER TABLE `poller`
ADD KEY `name` (`name`)

[Success]
ALTER TABLE `host_template`
ADD KEY `name` (`name`)

[Success]
ALTER TABLE `data_template`
ADD KEY `name` (`name`)

[Success]
ALTER TABLE `automation_tree_rules`
ADD KEY `name` (`name`(171))

[Success]
ALTER TABLE `automation_graph_rules`
ADD KEY `name` (`name`(171))

[Success]
ALTER TABLE `graph_tree`
ADD KEY `name` (`name`(171))

[Success]
ALTER TABLE `snmp_query_graph`
ADD KEY `snmp_query_id_name` (`snmp_query_id`, `name`)

[Fail]
REPLACE INTO settings (name, value) VALUES ('max_display_rows', '1000')


Version: 1.1.7

[Fail]
ALTER TABLE poller_data_template_field_mappings
MODIFY COLUMN data_name VARCHAR(40) NOT NULL default ""


Version: 1.1.11

[Fail]
ALTER TABLE poller_data_template_field_mappings
MODIFY COLUMN data_name VARCHAR(40) NOT NULL DEFAULT "",
MODIFY COLUMN data_source_names VARCHAR(125) NOT NULL DEFAULT ""

[Fail]
DELETE FROM settings WHERE name LIKE "md5%_plugins"

[Fail]
DELETE FROM poller_resource_cache WHERE path LIKE "plugins/%"


Version: 1.1.14

[Fail]
ALTER TABLE automation_networks
MODIFY COLUMN subnet_range VARCHAR(1024) NOT NULL DEFAULT ""


Version: 1.1.17

[Success]
UPDATE user_auth SET realm=3 WHERE realm=1

[Fail]
ALTER TABLE data_source_profiles_rra
ADD COLUMN timespan int(10) unsigned NOT NULL DEFAULT "0"


Version: 1.1.20

[Success]
ALTER TABLE snmpagent_cache
MODIFY COLUMN `oid` VARCHAR(50) NOT NULL,
MODIFY COLUMN `name` VARCHAR(50) NOT NULL,
MODIFY COLUMN `mib` VARCHAR(50) NOT NULL,
MODIFY COLUMN `type` VARCHAR(50) NOT NULL,
MODIFY COLUMN `otype` VARCHAR(50) NOT NULL,
MODIFY COLUMN `kind` VARCHAR(50) NOT NULL,
MODIFY COLUMN `max-access` VARCHAR(50) NOT NULL

[Success]
ALTER TABLE snmpagent_mibs
MODIFY COLUMN `name` VARCHAR(50) NOT NULL DEFAULT ""

[Success]
ALTER TABLE snmpagent_cache_notifications
MODIFY COLUMN `name` VARCHAR(50) NOT NULL,
MODIFY COLUMN `mib` VARCHAR(50) NOT NULL,
MODIFY COLUMN `attribute` VARCHAR(50) NOT NULL,
ADD PRIMARY KEY (`name`,`mib`,`attribute`,`sequence_id`)

[Success]
ALTER TABLE snmpagent_cache_textual_conventions
MODIFY COLUMN name VARCHAR(50) NOT NULL,
MODIFY COLUMN mib VARCHAR(50) NOT NULL,
MODIFY COLUMN type VARCHAR(50) NOT NULL,
ADD PRIMARY KEY (`name`,`mib`,`type`)

[Success]
ALTER TABLE snmpagent_managers_notifications
MODIFY COLUMN `notification` VARCHAR(50) NOT NULL,
MODIFY COLUMN `mib` VARCHAR(50) NOT NULL,
ADD PRIMARY KEY (`manager_id`,`notification`,`mib`)


Version: 1.1.26

[Success]
ALTER TABLE `host` ADD KEY `status` (`status`);

[Fail]
ALTER TABLE `user_auth_cache` ADD KEY `last_update` (`last_update`);

[Fail]
ALTER TABLE `poller_output_realtime` ADD KEY `time` (`time`);

[Success]
ALTER TABLE `poller_time` ADD KEY `poller_id_end_time` (`poller_id`, `end_time`);

[Success]
ALTER TABLE `poller_item`
DROP KEY `rrd_next_step`,
ADD KEY `poller_id_rrd_next_step` (`poller_id`, `rrd_next_step`);


Version: 1.1.28

[Fail]
ALTER TABLE `poller` ADD INDEX `disabled` (`disabled`);

[Success]
ALTER TABLE `host`
DROP INDEX `poller_id` ,
ADD INDEX `poller_id_disabled` (`poller_id`, `disabled`);

[Success]
ALTER TABLE `poller_item`
DROP INDEX `local_data_id`,
ADD INDEX `poller_id_action` (`poller_id`, `action`);


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 11:07 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
In MySQL can you do the following command and post the output:

Code:
SHOW TABLES;

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 11:42 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
here is the output
after the upgrade screen completes.. I go to login.. cacti is just a blank white screen.


automation_devices
automation_graph_rule_items
automation_graph_rules
automation_ips
automation_match_rule_items
automation_processes
automation_templates
automation_tree_rule_items
automation_tree_rules
cdef
cdef_items
colors
data_input
data_input_data
data_input_fields
data_local
data_source_stats_hourly_cache
data_source_stats_hourly_last
data_template
data_template_data
data_template_rrd
graph_local
graph_template_input
graph_template_input_defs
graph_templates
graph_templates_gprint
graph_templates_graph
graph_templates_item
graph_tree
graph_tree_items
host
host_graph
host_snmp_cache
host_snmp_query
host_template
host_template_graph
host_template_snmp_query
manage_admin_link
manage_alerts
manage_groups
manage_host
manage_poller_output
manage_process
manage_services
manage_sites
manage_tcp
manage_templates
manage_uptime_method
plugin_autom8_thold_rule_items
plugin_autom8_thold_rules
plugin_config
plugin_db_changes
plugin_hooks
plugin_notification_lists
plugin_realms
plugin_thold_contacts
plugin_thold_host_failed
plugin_thold_log
plugin_thold_template_contact
plugin_thold_threshold_contact
plugin_usersettings
poller_command
poller_item
poller_output
poller_output_boost_processes
poller_reindex
poller_time
reports
reports_items
settings
settings_tree
settings_user
snmp_query
snmp_query_graph
snmp_query_graph_rrd
snmp_query_graph_rrd_sv
snmp_query_graph_sv
snmpagent_cache
snmpagent_cache_notifications
snmpagent_cache_textual_conventions
snmpagent_managers
snmpagent_managers_notifications
snmpagent_mibs
snmpagent_notifications_log
thold_data
thold_template
user_auth
user_auth_perms
user_auth_realm
user_log
version


Top
 Profile  
 
 Post subject: Re: cacti DB failed, upgrade lost everything
PostPosted: Thu Jan 04, 2018 4:16 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
Does your cacti db user have access to create tables in that database? IF not, that will be the issue.

I've done a comparison and you are missing quite a few tables, and also seem to have a couple of tables I haven't seen before manage_*

Code:
# diff mine.lst his.lst
1,6d0
< aggregate_graph_templates
< aggregate_graph_templates_graph
< aggregate_graph_templates_item
< aggregate_graphs
< aggregate_graphs_graph_item
< aggregate_graphs_items
12d5
< automation_networks
14,15d6
< automation_snmp
< automation_snmp_items
21,22d20
< color_template_items
< color_templates
28,34d25
< data_source_profiles
< data_source_profiles_cf
< data_source_profiles_rra
< data_source_purge_action
< data_source_purge_temp
< data_source_stats_daily
< data_source_stats_hourly
37,39d27
< data_source_stats_monthly
< data_source_stats_weekly
< data_source_stats_yearly
43c31,43
< external_links
59a60,72
> manage_admin_link
> manage_alerts
> manage_groups
> manage_host
> manage_poller_output
> manage_process
> manage_services
> manage_sites
> manage_tcp
> manage_templates
> manage_uptime_method
> plugin_autom8_thold_rule_items
> plugin_autom8_thold_rules
62a76
> plugin_notification_lists
64c78,83
< poller
---
> plugin_thold_contacts
> plugin_thold_host_failed
> plugin_thold_log
> plugin_thold_template_contact
> plugin_thold_threshold_contact
> plugin_usersettings
66d84
< poller_data_template_field_mappings
69d86
< poller_output_boost
71d87
< poller_output_realtime
73d88
< poller_resource_cache
77d91
< sessions
81,82d94
< settings_user_group
< sites
94a107,108
> thold_data
> thold_template
96,100d109
< user_auth_cache
< user_auth_group
< user_auth_group_members
< user_auth_group_perms
< user_auth_group_realm
103,104d111
< user_domains
< user_domains_ldap
106,107d112
< vdef
< vdef_items


My recommedation would be to run php cli/upgrade_database.php --forcever=0.9 after checking the sql users permissions and see if that corrects things for you. You may get other failures because a lot of the alter table statements seem to have worked for those that did exist.

One other thing, are you using MariaDB or MySQL?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 5:38 pm 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
mysql


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 5:53 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
Have you tried running the upgrade script at the command line as suggested?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Thu Jan 04, 2018 5:57 pm 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
not yet.. ill do it later when I VPN in or tomorrow morning.


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 7:28 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
I ran that command.. got this back
Cannot load Zend OPcache - it was already loaded
Invalid Cacti version 0.9, cannot upgrade to 1.1.29


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 8:21 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
Ah, yeah it's checking for a valid version against it's internal hash table. Try using 0.8.8h instead. That was the latest version pre-1.x so should apply all 1.x updates.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 11:36 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
did that, updated to
Cannot load Zend OPcache - it was already loaded
Upgrading to 0.8.1
Upgrading to 0.8.2
Upgrading to 0.8.2a
Upgrading to 0.8.3

still get a blank white screen when logging into cacti..
I even reverted my db back to my old one, ran this command again.. when I loaded the cacti page, it wanted to do the upgrade.. so,ok.. did that.. same results as before.
sucks that I lost my entire cacti setup.. 2.5 years of graphing and setup.. gone


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 11:39 am 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
I changed the line again.. I missed your command by 2 digits.. dummy me..
now it says
Cannot load Zend OPcache - it was already loaded
Upgrading to 1.0.0
Upgrading to 1.0.1 no actions
Upgrading to 1.0.2 no actions
Upgrading to 1.0.3 no actions
Upgrading to 1.0.4
Upgrading to 1.0.5
Upgrading to 1.0.6 no actions
Upgrading to 1.1.0 no actions
Upgrading to 1.1.1 no actions
Upgrading to 1.1.2
Upgrading to 1.1.3 no actions
Upgrading to 1.1.4
Upgrading to 1.1.5 no actions
Upgrading to 1.1.6
Upgrading to 1.1.7
Upgrading to 1.1.8
Upgrading to 1.1.9 no actions
Upgrading to 1.1.10 no actions
Upgrading to 1.1.11
Upgrading to 1.1.12 no actions
Upgrading to 1.1.13 no actions
Upgrading to 1.1.14
Upgrading to 1.1.15 no actions
Upgrading to 1.1.16 no actions
Upgrading to 1.1.17
Upgrading to 1.1.18 no actions
Upgrading to 1.1.19 no actions
Upgrading to 1.1.20
Upgrading to 1.1.21 no actions
Upgrading to 1.1.22 no actions
Upgrading to 1.1.23 no actions
Upgrading to 1.1.24 no actions
Upgrading to 1.1.25 no actions
Upgrading to 1.1.26
Upgrading to 1.1.27 no actions
Upgrading to 1.1.28
Upgrading to 1.1.29 no actions

still a white screen when logging in.


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 12:49 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2054
OK, so lets retrace our steps and see if anything has changed. Can you do the SHOW TABLES; again and see if the missing tables are now present? Can you also see if your cacti.log or apache's error.log have any information about a problem?

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 1:00 pm 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
show tables
automation_devices
automation_graph_rule_items
automation_graph_rules
automation_ips
automation_match_rule_items
automation_processes
automation_templates
automation_tree_rule_items
automation_tree_rules
cdef
cdef_items
colors
data_input
data_input_data
data_input_fields
data_local
data_source_stats_hourly_cache
data_source_stats_hourly_last
data_template
data_template_data
data_template_data_rra
data_template_rrd
graph_local
graph_template_input
graph_template_input_defs
graph_templates
graph_templates_gprint
graph_templates_graph
graph_templates_item
graph_tree
graph_tree_items
host
host_graph
host_snmp_cache
host_snmp_query
host_template
host_template_graph
host_template_snmp_query
manage_admin_link
manage_alerts
manage_groups
manage_host
manage_poller_output
manage_process
manage_services
manage_sites
manage_tcp
manage_templates
manage_uptime_method
plugin_autom8_graph_rule_items
plugin_autom8_graph_rules
plugin_autom8_match_rule_items
plugin_autom8_thold_rule_items
plugin_autom8_thold_rules
plugin_autom8_tree_rule_items
plugin_autom8_tree_rules
plugin_config
plugin_db_changes
plugin_discover_hosts
plugin_discover_template
plugin_hooks
plugin_nectar
plugin_nectar_items
plugin_notification_lists
plugin_realms
plugin_snmpagent_cache
plugin_snmpagent_cache_notifications
plugin_snmpagent_cache_textual_conventions
plugin_snmpagent_managers
plugin_snmpagent_managers_notifications
plugin_snmpagent_mibs
plugin_snmpagent_notifications_log
plugin_thold_contacts
plugin_thold_host_failed
plugin_thold_log
plugin_thold_template_contact
plugin_thold_threshold_contact
plugin_usersettings
poller
poller_command
poller_item
poller_output
poller_output_boost_processes
poller_output_rt
poller_reindex
poller_time
reports
reports_items
rra
rra_cf
settings
settings_graphs
settings_tree
settings_user
snmp_query
snmp_query_graph
snmp_query_graph_rrd
snmp_query_graph_rrd_sv
snmp_query_graph_sv
snmpagent_cache
snmpagent_cache_notifications
snmpagent_cache_textual_conventions
snmpagent_managers
snmpagent_managers_notifications
snmpagent_mibs
snmpagent_notifications_log
thold_data
thold_template
user_auth
user_auth_perms
user_auth_realm
user_log
version

my cacti log file is growing.. its 145 mb now.. keeps growing by itself.


Top
 Profile  
 
 Post subject: Re: cacti DB failed, updgrade lost everything
PostPosted: Fri Jan 05, 2018 1:03 pm 
Offline
Cacti User

Joined: Tue Aug 26, 2014 2:58 pm
Posts: 58
manged to kill the log and create a new one.. here it is..

01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 64 include)(C:\inetpub\wwwroot\cacti\include\global.php: 327 include_once)(C:\inetpub\wwwroot\cacti\include\global_form.php: 401 db_fetch_cell)(C:\inetpub\wwwroot\cacti\lib\database.php: 233 db_fetch_cell_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 280 cacti_debug_backtrace)
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 136 poller_enabled_check)(C:\inetpub\wwwroot\cacti\poller.php: 639 db_fetch_cell_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 280 cacti_debug_backtrace)
01/05/2018 10:02:33 - DBCALL ERROR: A DB Exec Failed!, Error:145, SQL:'REPLACE INTO settings (name, value) VALUES (?, ?)'
01/05/2018 10:02:33 - CMDPHP ERROR: A DB Exec Failed!, Error: Table '.\cacti\settings' is marked as crashed and should be repaired
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 252 db_execute_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 208 cacti_debug_backtrace)
01/05/2018 10:02:33 - DBCALL ERROR: SQL Assoc Failed!, Error:1054, SQL:'SELECT SQL_NO_CACHE id FROM host WHERE poller_id = ? AND disabled="" ORDER BY id'
01/05/2018 10:02:33 - DBCALL ERROR: SQL Assoc Failed!, Error: Unknown column 'poller_id' in 'where clause'
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 272 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:33 - DBCALL ERROR: A DB Exec Failed!, Error:1054, SQL:'INSERT INTO poller (id, snmp, script, server, last_status, status) VALUES (?, ?, ?, ?, NOW(), 1) ON DUPLICATE KEY UPDATE snmp=VALUES(snmp), script=VALUES(script), server=VALUES(server), last_status=VALUES(last_status), status=VALUES(status)'
01/05/2018 10:02:33 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'snmp' in 'field list'
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 304 db_execute_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 208 cacti_debug_backtrace)
01/05/2018 10:02:33 - DBCALL ERROR: A DB Exec Failed!, Error:145, SQL:'REPLACE INTO settings (name, value) VALUES ('path_webroot','c:/inetpub/wwwroot/cacti')'
01/05/2018 10:02:33 - CMDPHP ERROR: A DB Exec Failed!, Error: Table '.\cacti\settings' is marked as crashed and should be repaired
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 323 db_execute)(C:\inetpub\wwwroot\cacti\lib\database.php: 135 db_execute_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 208 cacti_debug_backtrace)
01/05/2018 10:02:33 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT SQL_NO_CACHE local_data_id, rrd_name FROM poller_output AS po LEFT JOIN data_local AS dl ON po.local_data_id=dl.id LEFT JOIN host AS h ON dl.host_id=h.id WHERE h.poller_id = ? OR h.id IS NULL LIMIT 20'
01/05/2018 10:02:33 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:33 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 352 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:34 - DBCALL ERROR: A DB Exec Failed!, Error:145, SQL:'REPLACE INTO settings (name, value) VALUES ('date', NOW())'
01/05/2018 10:02:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Table '.\cacti\settings' is marked as crashed and should be repaired
01/05/2018 10:02:34 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 498 db_execute)(C:\inetpub\wwwroot\cacti\lib\database.php: 135 db_execute_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 208 cacti_debug_backtrace)
01/05/2018 10:02:34 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:34 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:34 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:34 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:34 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:34 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:35 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:35 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:35 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:35 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:35 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:35 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:36 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:36 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:36 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:36 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:36 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:36 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:37 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:37 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:37 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:37 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:37 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:37 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:38 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:38 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:38 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:38 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:38 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:38 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:39 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:39 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:39 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:39 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:39 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:39 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:40 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:40 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:40 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:40 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:40 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:40 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:41 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:41 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:41 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:41 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:41 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:41 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:42 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:42 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:42 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:42 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:42 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:42 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:43 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:43 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:43 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:43 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:43 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:43 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:44 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:44 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:44 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:44 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:44 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:44 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:45 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:45 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:45 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:45 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:45 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:45 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:46 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:46 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:46 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:46 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:46 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:46 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:47 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:47 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:47 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:47 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:47 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:47 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:48 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:48 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:48 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:48 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:48 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:48 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:49 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:49 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:49 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:49 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:49 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:49 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:50 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:50 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:50 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:50 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:50 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:50 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:51 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:51 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:51 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:51 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:51 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:51 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:52 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:52 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:52 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:52 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:52 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:52 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:53 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:53 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:53 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:53 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:53 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:53 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:54 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:54 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:54 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:54 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:54 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:54 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:55 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:55 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:55 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:55 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:55 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:55 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:56 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:56 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:56 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:56 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:56 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:56 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:57 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:57 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:57 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:57 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:57 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:57 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:58 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:58 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:58 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:58 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:58 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:58 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:59 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:02:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:02:59 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:02:59 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:02:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:02:59 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:03:00 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:03:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:03:00 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:03:00 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:03:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:03:00 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:03:01 - DBCALL ERROR: SQL Assoc Failed!, Error:145, SQL:'SELECT po.output, po.time, UNIX_TIMESTAMP(po.time) as unix_time, po.local_data_id, dl.data_template_id, pi.rrd_path, pi.rrd_name, pi.rrd_num FROM poller_output AS po INNER JOIN poller_item AS pi ON po.local_data_id=pi.local_data_id AND po.rrd_name=pi.rrd_name INNER JOIN data_local AS dl ON dl.id=po.local_data_id ORDER BY po.local_data_id LIMIT 40000'
01/05/2018 10:03:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Table '.\cacti\poller_output' is marked as crashed and should be repaired
01/05/2018 10:03:01 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 384 db_fetch_assoc)(C:\inetpub\wwwroot\cacti\lib\database.php: 360 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)
01/05/2018 10:03:01 - DBCALL ERROR: SQL Assoc Failed!, Error:1146, SQL:'SELECT SQL_NO_CACHE CONCAT(data_template_id, "_", data_name) AS keyname, data_source_names AS data_source_name FROM poller_data_template_field_mappings'
01/05/2018 10:03:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Table 'cacti.poller_data_template_field_mappings' doesn't exist
01/05/2018 10:03:01 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\poller.php: 539 process_poller_output)(C:\inetpub\wwwroot\cacti\lib\poller.php: 388 db_fetch_assoc_prepared)(C:\inetpub\wwwroot\cacti\lib\database.php: 401 cacti_debug_backtrace)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 82 posts ]  Go to page 1, 2, 3, 4, 5, 6  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group