fN3hK9dG

1Error
2
3Your Cacti Server v1.2.2 has been installed/updated with errors
4Database Upgrade - Version 1.0.0
5
6The following table lists the status of each upgrade performed on the database
7	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';	[Success]
8	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';	[Success]
9	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';	[Success]
10	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';	[Success]
11	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';	[Success]
12	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;	[Success]
13	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]
14	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]
15	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]
16	ALTER TABLE `data_source_stats_hourly_last` ADD `calculated`	[Success]
17	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;	[Success]
18	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;	[Success]
19	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;	[Success]
20	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]
21	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;	[Success]
22	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';	[Success]
23	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]
24	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]
25	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]
26	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]
27	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]
28	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]
29	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]
30	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';	[Success]
31	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';	[Success]
32	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]
33	ALTER TABLE `graph_tree` ADD `enabled`	[Success]
34	ALTER TABLE `graph_tree` ADD `locked`	[Success]
35	ALTER TABLE `graph_tree` ADD `locked_date`	[Success]
36	ALTER TABLE `graph_tree` ADD `last_modified`	[Success]
37	ALTER TABLE `graph_tree` ADD `user_id`	[Success]
38	ALTER TABLE `graph_tree` ADD `modified_by`	[Success]
39	ALTER TABLE `graph_tree_items` ADD `parent`	[Success]
40	ALTER TABLE `graph_tree_items` ADD `position`	[Success]
41	ALTER TABLE graph_tree_items MODIFY COLUMN id BIGINT UNSIGNED NOT NULL auto_increment	[Success]
42	ALTER TABLE `graph_tree_items` ADD INDEX parent(parent)	[Success]
43	ALTER TABLE `graph_tree_items` ADD INDEX parent(parent)	[Success]
44	DROP TABLE `user_auth_cache`	[Skipped]
45	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]
46	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]
47	ALTER TABLE poller MODIFY COLUMN last_update timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'	[Success]
48	ALTER TABLE poller_command MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'	[Success]
49	ALTER TABLE poller_output MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'	[Success]
50	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]
51	ALTER TABLE user_log MODIFY COLUMN time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'	[Success]
52	ALTER TABLE `user_auth` ADD `lastchange`	[Success]
53	ALTER TABLE `user_auth` ADD `lastlogin`	[Success]
54	ALTER TABLE `user_auth` ADD `password_history`	[Success]
55	ALTER TABLE `user_auth` ADD `locked`	[Success]
56	ALTER TABLE `user_auth` ADD `failed_attempts`	[Success]
57	ALTER TABLE `user_auth` ADD `lastfail`	[Success]
58	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=1	[Success]
59	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=9	[Success]
60	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=13	[Success]
61	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=10	[Success]
62	UPDATE graph_tree_items SET parent=0, position=3 WHERE id=11	[Success]
63	UPDATE graph_tree_items SET parent=0, position=4 WHERE id=12	[Success]
64	UPDATE graph_tree_items SET parent=0, position=5 WHERE id=38	[Success]
65	UPDATE graph_tree_items SET parent=0, position=6 WHERE id=40	[Success]
66	UPDATE graph_tree_items SET parent=0, position=7 WHERE id=47	[Success]
67	UPDATE graph_tree_items SET parent=0, position=8 WHERE id=80	[Success]
68	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=2	[Success]
69	UPDATE graph_tree_items SET parent=15, position=1 WHERE id=19	[Success]
70	UPDATE graph_tree_items SET parent=15, position=2 WHERE id=18	[Success]
71	UPDATE graph_tree_items SET parent=15, position=3 WHERE id=22	[Success]
72	UPDATE graph_tree_items SET parent=15, position=4 WHERE id=21	[Success]
73	UPDATE graph_tree_items SET parent=15, position=5 WHERE id=17	[Success]
74	UPDATE graph_tree_items SET parent=15, position=6 WHERE id=20	[Success]
75	UPDATE graph_tree_items SET parent=15, position=7 WHERE id=16	[Success]
76	UPDATE graph_tree_items SET parent=81, position=1 WHERE id=86	[Success]
77	UPDATE graph_tree_items SET parent=81, position=2 WHERE id=85	[Success]
78	UPDATE graph_tree_items SET parent=81, position=3 WHERE id=88	[Success]
79	UPDATE graph_tree_items SET parent=81, position=4 WHERE id=87	[Success]
80	UPDATE graph_tree_items SET parent=81, position=5 WHERE id=94	[Success]
81	UPDATE graph_tree_items SET parent=81, position=6 WHERE id=93	[Success]
82	UPDATE graph_tree_items SET parent=81, position=7 WHERE id=96	[Success]
83	UPDATE graph_tree_items SET parent=81, position=8 WHERE id=95	[Success]
84	UPDATE graph_tree_items SET parent=81, position=9 WHERE id=144	[Success]
85	UPDATE graph_tree_items SET parent=81, position=10 WHERE id=145	[Success]
86	UPDATE graph_tree_items SET parent=81, position=11 WHERE id=146	[Success]
87	UPDATE graph_tree_items SET parent=150, position=1 WHERE id=154	[Success]
88	UPDATE graph_tree_items SET parent=150, position=2 WHERE id=153	[Success]
89	UPDATE graph_tree_items SET parent=150, position=3 WHERE id=152	[Success]
90	UPDATE graph_tree_items SET parent=151, position=1 WHERE id=156	[Success]
91	UPDATE graph_tree_items SET parent=151, position=2 WHERE id=155	[Success]
92	UPDATE graph_tree_items SET parent=151, position=3 WHERE id=157	[Success]
93	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=15	[Success]
94	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=81	[Success]
95	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=150	[Success]
96	UPDATE graph_tree_items SET parent=0, position=3 WHERE id=151	[Success]
97	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=3	[Success]
98	UPDATE graph_tree_items SET parent=31, position=1 WHERE id=35	[Success]
99	UPDATE graph_tree_items SET parent=31, position=2 WHERE id=36	[Success]
100	UPDATE graph_tree_items SET parent=31, position=3 WHERE id=37	[Success]
101	UPDATE graph_tree_items SET parent=89, position=1 WHERE id=91	[Success]
102	UPDATE graph_tree_items SET parent=89, position=2 WHERE id=92	[Success]
103	UPDATE graph_tree_items SET parent=89, position=3 WHERE id=143	[Success]
104	UPDATE graph_tree_items SET parent=142, position=1 WHERE id=147	[Success]
105	UPDATE graph_tree_items SET parent=142, position=2 WHERE id=149	[Success]
106	UPDATE graph_tree_items SET parent=142, position=3 WHERE id=148	[Success]
107	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=31	[Success]
108	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=89	[Success]
109	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=142	[Success]
110	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=4	[Success]
111	UPDATE graph_tree_items SET parent=65, position=1 WHERE id=66	[Success]
112	UPDATE graph_tree_items SET parent=65, position=2 WHERE id=67	[Success]
113	UPDATE graph_tree_items SET parent=65, position=3 WHERE id=131	[Success]
114	UPDATE graph_tree_items SET parent=68, position=1 WHERE id=72	[Success]
115	UPDATE graph_tree_items SET parent=68, position=2 WHERE id=73	[Success]
116	UPDATE graph_tree_items SET parent=69, position=1 WHERE id=76	[Success]
117	UPDATE graph_tree_items SET parent=69, position=2 WHERE id=77	[Success]
118	UPDATE graph_tree_items SET parent=70, position=1 WHERE id=132	[Success]
119	UPDATE graph_tree_items SET parent=70, position=2 WHERE id=133	[Success]
120	UPDATE graph_tree_items SET parent=71, position=1 WHERE id=74	[Success]
121	UPDATE graph_tree_items SET parent=71, position=2 WHERE id=75	[Success]
122	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=65	[Success]
123	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=68	[Success]
124	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=69	[Success]
125	UPDATE graph_tree_items SET parent=0, position=3 WHERE id=70	[Success]
126	UPDATE graph_tree_items SET parent=0, position=4 WHERE id=71	[Success]
127	UPDATE graph_tree_items SET parent=0, position=5 WHERE id=113	[Success]
128	UPDATE graph_tree_items SET parent=0, position=6 WHERE id=118	[Success]
129	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=5	[Success]
130	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=48	[Success]
131	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=49	[Success]
132	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=56	[Success]
133	UPDATE graph_tree_items SET parent=0, position=3 WHERE id=57	[Success]
134	UPDATE graph_tree_items SET parent=0, position=4 WHERE id=117	[Success]
135	UPDATE graph_tree_items SET parent=0, position=5 WHERE id=121	[Success]
136	UPDATE graph_tree_items SET parent=0, position=6 WHERE id=122	[Success]
137	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=6	[Success]
138	UPDATE graph_tree_items SET parent=126, position=1 WHERE id=127	[Success]
139	UPDATE graph_tree_items SET parent=126, position=2 WHERE id=128	[Success]
140	UPDATE graph_tree_items SET parent=126, position=3 WHERE id=129	[Success]
141	UPDATE graph_tree_items SET parent=126, position=4 WHERE id=130	[Success]
142	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=61	[Success]
143	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=60	[Success]
144	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=125	[Success]
145	UPDATE graph_tree_items SET parent=0, position=3 WHERE id=126	[Success]
146	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=7	[Success]
147	UPDATE graph_tree_items SET parent=97, position=1 WHERE id=100	[Success]
148	UPDATE graph_tree_items SET parent=97, position=2 WHERE id=101	[Success]
149	UPDATE graph_tree_items SET parent=97, position=3 WHERE id=102	[Success]
150	UPDATE graph_tree_items SET parent=98, position=1 WHERE id=103	[Success]
151	UPDATE graph_tree_items SET parent=98, position=2 WHERE id=104	[Success]
152	UPDATE graph_tree_items SET parent=98, position=3 WHERE id=105	[Success]
153	UPDATE graph_tree_items SET parent=98, position=4 WHERE id=106	[Success]
154	UPDATE graph_tree_items SET parent=99, position=1 WHERE id=107	[Success]
155	UPDATE graph_tree_items SET parent=99, position=2 WHERE id=108	[Success]
156	UPDATE graph_tree_items SET parent=99, position=3 WHERE id=109	[Success]
157	UPDATE graph_tree_items SET parent=99, position=4 WHERE id=110	[Success]
158	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=97	[Success]
159	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=98	[Success]
160	UPDATE graph_tree_items SET parent=0, position=2 WHERE id=99	[Success]
161	UPDATE graph_tree_items SET position=0 WHERE graph_tree_id=8	[Success]
162	UPDATE graph_tree_items SET parent=0, position=0 WHERE id=123	[Success]
163	UPDATE graph_tree_items SET parent=0, position=1 WHERE id=124	[Success]
164	ALTER TABLE `graph_tree_items` DROP `order_key`	[Success]
165	DELETE FROM plugin_realms WHERE file LIKE 'clog%'	[Success]
166	DELETE FROM plugin_config WHERE directory='clog'	[Success]
167	DELETE FROM plugin_hooks WHERE name='clog'	[Success]
168	ALTER TABLE `user_auth` ADD `email_address`	[Success]
169	ALTER TABLE `user_auth` ADD `password_change`	[Success]
170	DROP TABLE `poller_output_realtime`	[Skipped]
171	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]
172	DROP TABLE `poller_output_rt`	[Success]
173	DELETE FROM plugin_realms WHERE file LIKE '%graph_image_rt%'	[Success]
174	DELETE FROM plugin_config WHERE directory='realtime'	[Success]
175	DELETE FROM plugin_hooks WHERE name='realtime'	[Success]
176	CREATE TABLE IF NOT EXISTS `reports` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `cformat` char(2) NOT NULL DEFAULT '', `format_file` varchar(255) NOT NULL DEFAULT '', `font_size` smallint(2) unsigned NOT NULL DEFAULT '0', `alignment` smallint(2) unsigned NOT NULL DEFAULT '0', `graph_linked` char(2) NOT NULL DEFAULT '', `intrvl` smallint(2) unsigned NOT NULL DEFAULT '0', `count` smallint(2) unsigned NOT NULL DEFAULT '0', `offset` int(12) unsigned NOT NULL DEFAULT '0', `mailtime` bigint(20) unsigned NOT NULL DEFAULT '0', `subject` varchar(64) NOT NULL DEFAULT '', `from_name` varchar(40) NOT NULL, `from_email` text NOT NULL, `email` text NOT NULL, `bcc` text NOT NULL, `attachment_type` smallint(2) unsigned NOT NULL DEFAULT '1', `graph_height` smallint(2) unsigned NOT NULL DEFAULT '0', `graph_width` smallint(2) unsigned NOT NULL DEFAULT '0', `graph_columns` smallint(2) unsigned NOT NULL DEFAULT '0', `thumbnails` char(2) NOT NULL DEFAULT '', `lastsent` bigint(20) unsigned NOT NULL DEFAULT '0', `enabled` char(2) DEFAULT '', PRIMARY KEY (`id`), KEY `mailtime` (`mailtime`)) ENGINE=InnoDB COMMENT='Cacri Reporting Reports'	[Success]
177	CREATE TABLE IF NOT EXISTS `reports_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `report_id` int(10) unsigned NOT NULL DEFAULT '0', `item_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `tree_id` int(10) unsigned NOT NULL DEFAULT '0', `branch_id` int(10) unsigned NOT NULL DEFAULT '0', `tree_cascade` char(2) NOT NULL DEFAULT '', `graph_name_regexp` varchar(128) NOT NULL DEFAULT '', `host_template_id` int(10) unsigned NOT NULL DEFAULT '0', `host_id` int(10) unsigned NOT NULL DEFAULT '0', `graph_template_id` int(10) unsigned NOT NULL DEFAULT '0', `local_graph_id` int(10) unsigned NOT NULL DEFAULT '0', `timespan` int(10) unsigned NOT NULL DEFAULT '0', `align` tinyint(1) unsigned NOT NULL DEFAULT '1', `item_text` text NOT NULL, `font_size` smallint(2) unsigned NOT NULL DEFAULT '10', `sequence` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `report_id` (`report_id`)) ENGINE=InnoDB COMMENT='Cacti Reporting Items'	[Success]
178	ALTER TABLE `host` ADD `snmp_sysDescr`	[Success]
179	ALTER TABLE `host` ADD `snmp_sysObjectID`	[Success]
180	ALTER TABLE `host` ADD `snmp_sysUpTimeInstance`	[Success]
181	ALTER TABLE `host` ADD `snmp_sysContact`	[Success]
182	ALTER TABLE `host` ADD `snmp_sysName`	[Success]
183	ALTER TABLE `host` ADD `snmp_sysLocation`	[Success]
184	ALTER TABLE `host` ADD `polling_time`	[Success]
185	INSERT IGNORE INTO user_auth_realm VALUES (18,1)	[Success]
186	INSERT IGNORE INTO user_auth_realm VALUES (20,1)	[Success]
187	INSERT IGNORE INTO user_auth_realm VALUES (21,1)	[Success]
188	INSERT IGNORE INTO `plugin_aggregate_color_templates` (`color_template_id`, `name`) VALUES (1, 'Yellow: light -> dark, 4 colors'), (2, 'Red: light yellow > dark red, 8 colors'), (3, 'Red: light -> dark, 16 colors'), (4, 'Green: dark -> light, 16 colors');	[Success]
189	INSERT IGNORE INTO `plugin_aggregate_color_template_items` (`color_template_item_id`, `color_template_id`, `color_id`, `sequence`) VALUES (1, 1, 4, 1), (2, 1, 24, 2), (3, 1, 98, 3), (4, 1, 25, 4), (5, 2, 25, 1), (6, 2, 29, 2), (7, 2, 30, 3), (8, 2, 31, 4), (9, 2, 33, 5), (10, 2, 35, 6), (11, 2, 41, 7), (12, 2, 9, 8), (13, 3, 15, 1), (14, 3, 31, 2), (15, 3, 28, 3), (16, 3, 8, 4), (17, 3, 34, 5), (18, 3, 33, 6), (19, 3, 35, 7), (20, 3, 41, 8), (21, 3, 36, 9), (22, 3, 42, 10), (23, 3, 44, 11), (24, 3, 48, 12), (25, 3, 9, 13), (26, 3, 49, 14), (27, 3, 51, 15), (28, 3, 52, 16), (29, 4, 76, 1), (30, 4, 84, 2), (31, 4, 89, 3), (32, 4, 17, 4), (33, 4, 86, 5), (34, 4, 88, 6), (35, 4, 90, 7), (36, 4, 94, 8), (37, 4, 96, 9), (38, 4, 93, 10), (39, 4, 91, 11), (40, 4, 22, 12), (41, 4, 12, 13), (42, 4, 95, 14), (43, 4, 6, 15), (44, 4, 92, 16);	[Success]
190	ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `t_graph_type_id`	[Success]
191	ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `graph_type_id`	[Success]
192	ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `t_cdef_id`	[Success]
193	ALTER TABLE `plugin_aggregate_graphs_graph_item` ADD `cdef_id`	[Success]
194	ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `t_graph_type_id`	[Success]
195	ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `graph_type_id`	[Success]
196	ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `t_cdef_id`	[Success]
197	ALTER TABLE `plugin_aggregate_graph_templates_item` ADD `cdef_id`	[Success]
198	RENAME TABLE `plugin_aggregate_color_template_items` TO `color_template_items`	[Success]
199	RENAME TABLE `plugin_aggregate_color_templates` TO `color_templates`	[Success]
200	RENAME TABLE `plugin_aggregate_graph_templates` TO `aggregate_graph_templates`	[Success]
201	RENAME TABLE `plugin_aggregate_graph_templates_graph` TO `aggregate_graph_templates_graph`	[Success]
202	RENAME TABLE `plugin_aggregate_graph_templates_item` TO `aggregate_graph_templates_item`	[Success]
203	RENAME TABLE `plugin_aggregate_graphs` TO `aggregate_graphs`	[Success]
204	RENAME TABLE `plugin_aggregate_graphs_graph_item` TO `aggregate_graphs_graph_item`	[Success]
205	RENAME TABLE `plugin_aggregate_graphs_items` TO `aggregate_graphs_items`	[Success]
206	DELETE FROM plugin_config WHERE directory='aggregate'	[Success]
207	DELETE FROM plugin_realms WHERE plugin='aggregate'	[Success]
208	DELETE FROM plugin_db_changes WHERE plugin='aggregate'	[Success]
209	DELETE FROM plugin_hooks WHERE name='aggregate'	[Success]
210	UPDATE plugin_autom8_tree_rule_items SET field=REPLACE(field, 'host_template.', 'ht.')	[Success]
211	UPDATE plugin_autom8_tree_rule_items SET field=REPLACE(field, 'host.', 'h.')	[Success]
212	UPDATE plugin_autom8_tree_rule_items SET field=REPLACE(field, 'graph_templates.', 'gt.')	[Success]
213	UPDATE plugin_autom8_tree_rule_items SET field=REPLACE(field, 'graph_templates_graph.', 'gtg.')	[Success]
214	DROP TABLE IF EXISTS automation_graph_rules	[Success]
215	RENAME TABLE `plugin_autom8_graph_rules` TO `automation_graph_rules`	[Success]
216	DROP TABLE IF EXISTS automation_graph_rule_items	[Success]
217	RENAME TABLE `plugin_autom8_graph_rule_items` TO `automation_graph_rule_items`	[Success]
218	DROP TABLE IF EXISTS automation_match_rule_items	[Success]
219	RENAME TABLE `plugin_autom8_match_rule_items` TO `automation_match_rule_items`	[Success]
220	DROP TABLE IF EXISTS automation_tree_rules	[Success]
221	RENAME TABLE `plugin_autom8_tree_rules` TO `automation_tree_rules`	[Success]
222	DROP TABLE IF EXISTS automation_tree_rule_items	[Success]
223	RENAME TABLE `plugin_autom8_tree_rule_items` TO `automation_tree_rule_items`	[Success]
224	UPDATE IGNORE user_auth_realm SET realm_id=23 WHERE realm_id=113	[Success]
225	DELETE FROM user_auth_realm WHERE realm_id=113	[Success]
226	DELETE FROM plugin_config WHERE directory='autom8'	[Success]
227	DELETE FROM plugin_realms WHERE plugin='autom8'	[Success]
228	DELETE FROM plugin_db_changes WHERE plugin='autom8'	[Success]
229	DELETE FROM plugin_hooks WHERE name='autom8'	[Success]
230	UPDATE settings SET name=REPLACE(name, 'autom8', 'automation') WHERE name LIKE 'autom8%'	[Fail]
231	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]
232	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'	[Success]
233	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]
234	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'	[Success]
235	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'	[Success]
236	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]
237	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]
238	DELETE FROM plugin_config WHERE directory='discovery'	[Success]
239	DELETE FROM plugin_realms WHERE plugin='discovery'	[Success]
240	DELETE FROM plugin_db_changes WHERE plugin='discovery'	[Success]
241	DELETE FROM plugin_hooks WHERE name='discovery'	[Success]
242	UPDATE automation_match_rule_items SET field=REPLACE(field, 'host_template.', 'ht.')	[Success]
243	UPDATE automation_match_rule_items SET field=REPLACE(field, 'host.', 'h.')	[Success]
244	UPDATE automation_match_rule_items SET field=REPLACE(field, 'graph_templates.', 'gt.')	[Success]
245	UPDATE automation_match_rule_items SET field=REPLACE(field, 'graph_templates_graph.', 'gtg.')	[Success]
246	INSERT IGNORE INTO user_auth_realm (user_id, realm_id) VALUES (1, 23)	[Success]
247	ALTER TABLE `colors` ADD UNIQUE INDEX hex(hex)	[Success]
248	ALTER TABLE `colors` ADD UNIQUE INDEX hex(hex)	[Success]
249	ALTER TABLE `colors` ADD `name`	[Success]
250	ALTER TABLE `colors` ADD `read_only`	[Success]
251	ALTER TABLE settings MODIFY COLUMN value varchar(2048) NOT NULL default ''	[Success]
252	ALTER TABLE settings_graphs MODIFY COLUMN value varchar(2048) NOT NULL default ''	[Success]
253	ALTER TABLE user_auth MODIFY COLUMN password varchar(2048) NOT NULL default ''	[Success]
254	RENAME TABLE `settings_graphs` TO `settings_user`	[Success]
255	ALTER TABLE `user_auth` ADD `reset_perms`	[Success]
256	ALTER TABLE `graph_templates_item` ADD `vdef_id`	[Success]
257	ALTER TABLE `graph_templates_item` ADD `line_width`	[Success]
258	ALTER TABLE `graph_templates_item` ADD `dashes`	[Success]
259	ALTER TABLE `graph_templates_item` ADD `dash_offset`	[Success]
260	ALTER TABLE `graph_templates_item` ADD `shift`	[Success]
261	ALTER TABLE `graph_templates_item` ADD `textalign`	[Success]
262	ALTER TABLE `graph_templates_graph` ADD `t_alt_y_grid`	[Success]
263	ALTER TABLE `graph_templates_graph` ADD `alt_y_grid`	[Success]
264	ALTER TABLE `graph_templates_graph` ADD `t_right_axis`	[Success]
265	ALTER TABLE `graph_templates_graph` ADD `right_axis`	[Success]
266	ALTER TABLE `graph_templates_graph` ADD `t_right_axis_label`	[Success]
267	ALTER TABLE `graph_templates_graph` ADD `right_axis_label`	[Success]
268	ALTER TABLE `graph_templates_graph` ADD `t_right_axis_format`	[Success]
269	ALTER TABLE `graph_templates_graph` ADD `right_axis_format`	[Success]
270	ALTER TABLE `graph_templates_graph` ADD `t_right_axis_formatter`	[Success]
271	ALTER TABLE `graph_templates_graph` ADD `right_axis_formatter`	[Success]
272	ALTER TABLE `graph_templates_graph` ADD `t_left_axis_formatter`	[Success]
273	ALTER TABLE `graph_templates_graph` ADD `left_axis_formatter`	[Success]
274	ALTER TABLE `graph_templates_graph` ADD `t_no_gridfit`	[Success]
275	ALTER TABLE `graph_templates_graph` ADD `no_gridfit`	[Success]
276	ALTER TABLE `graph_templates_graph` ADD `t_unit_length`	[Success]
277	ALTER TABLE `graph_templates_graph` ADD `unit_length`	[Success]
278	ALTER TABLE `graph_templates_graph` ADD `t_tab_width`	[Success]
279	ALTER TABLE `graph_templates_graph` ADD `tab_width`	[Success]
280	ALTER TABLE `graph_templates_graph` ADD `t_dynamic_labels`	[Success]
281	ALTER TABLE `graph_templates_graph` ADD `dynamic_labels`	[Success]
282	ALTER TABLE `graph_templates_graph` ADD `t_force_rules_legend`	[Success]
283	ALTER TABLE `graph_templates_graph` ADD `force_rules_legend`	[Success]
284	ALTER TABLE `graph_templates_graph` ADD `t_legend_position`	[Success]
285	ALTER TABLE `graph_templates_graph` ADD `legend_position`	[Success]
286	ALTER TABLE `graph_templates_graph` ADD `t_legend_direction`	[Success]
287	ALTER TABLE `graph_templates_graph` ADD `legend_direction`	[Success]
288	REPLACE INTO `user_auth_realm` VALUES (19,1);	[Success]
289	REPLACE INTO `user_auth_realm` VALUES (22,1);	[Success]
290	REPLACE INTO `vdef` VALUES (1, 'e06ed529238448773038601afb3cf278', 'Maximum');	[Success]
291	REPLACE INTO `vdef` VALUES (2, 'e4872dda82092393d6459c831a50dc3b', 'Minimum');	[Success]
292	REPLACE INTO `vdef` VALUES (3, '5ce1061a46bb62f36840c80412d2e629', 'Average');	[Success]
293	REPLACE INTO `vdef` VALUES (4, '06bd3cbe802da6a0745ea5ba93af554a', 'Last (Current)');	[Success]
294	REPLACE INTO `vdef` VALUES (5, '631c1b9086f3979d6dcf5c7a6946f104', 'First');	[Success]
295	REPLACE INTO `vdef` VALUES (6, '6b5335843630b66f858ce6b7c61fc493', 'Total: Current Data Source');	[Success]
296	REPLACE INTO `vdef` VALUES (7, 'c80d12b0f030af3574da68b28826cd39', '95th Percentage: Current Data Source');	[Success]
297	REPLACE INTO `vdef_items` VALUES (1, '88d33bf9271ac2bdf490cf1784a342c1', 1, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
298	REPLACE INTO `vdef_items` VALUES (2, 'a307afab0c9b1779580039e3f7c4f6e5', 1, 2, 1, '1');	[Success]
299	REPLACE INTO `vdef_items` VALUES (3, '0945a96068bb57c80bfbd726cf1afa02', 2, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
300	REPLACE INTO `vdef_items` VALUES (4, '95a8df2eac60a89e8a8ca3ea3d019c44', 2, 2, 1, '2');	[Success]
301	REPLACE INTO `vdef_items` VALUES (5, 'cc2e1c47ec0b4f02eb13708cf6dac585', 3, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
302	REPLACE INTO `vdef_items` VALUES (6, 'a2fd796335b87d9ba54af6a855689507', 3, 2, 1, '3');	[Success]
303	REPLACE INTO `vdef_items` VALUES (7, 'a1d7974ee6018083a2053e0d0f7cb901', 4, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
304	REPLACE INTO `vdef_items` VALUES (8, '26fccba1c215439616bc1b83637ae7f3', 4, 2, 1, '5');	[Success]
305	REPLACE INTO `vdef_items` VALUES (9, 'a8993b265f4c5398f4a47c44b5b37a07', 5, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
306	REPLACE INTO `vdef_items` VALUES (10, '5a380d469d611719057c3695ce1e4eee', 5, 2, 1, '6');	[Success]
307	REPLACE INTO `vdef_items` VALUES (11, '65cfe546b17175fad41fcca98c057feb', 6, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
308	REPLACE INTO `vdef_items` VALUES (12, 'f330b5633c3517d7c62762cef091cc9e', 6, 2, 1, '7');	[Success]
309	REPLACE INTO `vdef_items` VALUES (13, 'f1bf2ecf54ca0565cf39c9c3f7e5394b', 7, 1, 4, 'CURRENT_DATA_SOURCE');	[Success]
310	REPLACE INTO `vdef_items` VALUES (14, '11a26f18feba3919be3af426670cba95', 7, 2, 6, '95');	[Success]
311	REPLACE INTO `vdef_items` VALUES (15, 'e7ae90275bc1efada07c19ca3472d9db', 7, 3, 1, '8');	[Success]
312	ALTER TABLE `data_template_data` ADD `t_data_source_profile_id`	[Success]
313	ALTER TABLE `data_template_data` ADD `data_source_profile_id`	[Success]
314	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'	[Success]
315	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'	[Success]
316	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'	[Success]
317	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '1' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=1	[Success]
318	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '1' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=1	[Success]
319	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '1' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=2	[Success]
320	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '1' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=2	[Success]
321	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '1' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=3	[Success]
322	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '1' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=3	[Success]
323	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '1' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=4	[Success]
324	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '1' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=4	[Success]
325	UPDATE data_template_data SET data_source_profile_id=1 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]
326	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '2' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=1	[Success]
327	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '2' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=1	[Success]
328	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '2' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=2	[Success]
329	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '2' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=2	[Success]
330	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '2' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=3	[Success]
331	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '2' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=3	[Success]
332	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '2' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=4	[Success]
333	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '2' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=4	[Success]
334	INSERT INTO data_source_profiles_rra (`data_source_profile_id`, `name`, `steps`, `rows`) SELECT '2' AS `data_source_profile_id`, `name`, `steps`, `rows` FROM `rra` WHERE `id`=5	[Success]
335	REPLACE INTO data_source_profiles_cf (data_source_profile_id, consolidation_function_id) SELECT '2' AS data_source_profile_id, consolidation_function_id FROM rra_cf WHERE rra_id=5	[Success]
336	UPDATE data_template_data SET data_source_profile_id=2 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,5' ) AS rs);	[Success]
337	DROP TABLE `rra`	[Success]
338	DROP TABLE `rra_cf`	[Success]
339	DROP TABLE `data_template_data_rra`	[Success]
340	ALTER TABLE `data_template_data` DROP `t_rra_id`	[Success]
341	ALTER TABLE `automation_tree_rule_items` DROP `rra_id`	[Success]
342	ALTER TABLE `automation_tree_rules` DROP `rra_id`	[Success]
343	ALTER TABLE `graph_tree_items` DROP `rra_id`	[Success]
344	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_alt_y_grid`	[Success]
345	ALTER TABLE `aggregate_graph_templates_graph` ADD `alt_y_grid`	[Success]
346	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis`	[Success]
347	ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis`	[Success]
348	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_label`	[Success]
349	ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_label`	[Success]
350	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_format`	[Success]
351	ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_format`	[Success]
352	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_right_axis_formatter`	[Success]
353	ALTER TABLE `aggregate_graph_templates_graph` ADD `right_axis_formatter`	[Success]
354	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_left_axis_formatter`	[Success]
355	ALTER TABLE `aggregate_graph_templates_graph` ADD `left_axis_formatter`	[Success]
356	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_no_gridfit`	[Success]
357	ALTER TABLE `aggregate_graph_templates_graph` ADD `no_gridfit`	[Success]
358	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_unit_length`	[Success]
359	ALTER TABLE `aggregate_graph_templates_graph` ADD `unit_length`	[Success]
360	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_tab_width`	[Success]
361	ALTER TABLE `aggregate_graph_templates_graph` ADD `tab_width`	[Success]
362	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_dynamic_labels`	[Success]
363	ALTER TABLE `aggregate_graph_templates_graph` ADD `dynamic_labels`	[Success]
364	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_force_rules_legend`	[Success]
365	ALTER TABLE `aggregate_graph_templates_graph` ADD `force_rules_legend`	[Success]
366	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_legend_position`	[Success]
367	ALTER TABLE `aggregate_graph_templates_graph` ADD `legend_position`	[Success]
368	ALTER TABLE `aggregate_graph_templates_graph` ADD `t_legend_direction`	[Success]
369	ALTER TABLE `aggregate_graph_templates_graph` ADD `legend_direction`	[Success]
370	ALTER TABLE `cdef` ADD `system`	[Success]
371	UPDATE cdef SET system=1 WHERE name LIKE '\_%'	[Success]
372	ALTER TABLE `data_local` ADD INDEX data_template_id(data_template_id)	[Skipped]
373	ALTER TABLE `data_local` ADD INDEX snmp_query_id(snmp_query_id)	[Skipped]
374	ALTER TABLE poller MODIFY COLUMN last_update TIMESTAMP NOT NULL default '0000-00-00'	[Success]
375	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]
376	ALTER TABLE `host` ADD `poller_id`	[Success]
377	ALTER TABLE `host` ADD INDEX poller_id(poller_id)	[Success]
378	ALTER TABLE `host` ADD INDEX poller_id(poller_id)	[Success]
379	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'	[Success]
380	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]
381	ALTER TABLE `host` ADD `site_id`	[Success]
382	ALTER TABLE host MODIFY COLUMN poller_id mediumint(8) unsigned default '1'	[Success]
383	ALTER TABLE `host` ADD INDEX site_id(site_id)	[Success]
384	ALTER TABLE `host` ADD INDEX site_id(site_id)	[Success]
385	DROP TABLE `poller`	[Success]
386	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'	[Success]
387	INSERT INTO poller (id, name, hostname) VALUES (1, "Main Poller", "cacti")	[Success]
388	UPDATE automation_networks SET poller_id=1 WHERE poller_id=0	[Success]
389	UPDATE automation_processes SET poller_id=1 WHERE poller_id=0	[Success]
390	UPDATE host SET poller_id=1 WHERE poller_id=0	[Success]
391	UPDATE poller_command SET poller_id=1 WHERE poller_id=0	[Success]
392	UPDATE poller_item SET poller_id=1 WHERE poller_id=0	[Success]
393	UPDATE poller_output_realtime SET poller_id=1 WHERE poller_id=0	[Success]
394	UPDATE poller_time SET poller_id=1 WHERE poller_id=0	[Success]
395	ALTER TABLE sessions MODIFY COLUMN data MEDIUMBLOB	[Success]
396	ALTER TABLE `host` ADD `snmp_engine_id`	[Success]
397	ALTER TABLE `poller_item` ADD `snmp_engine_id`	[Success]
398	ALTER TABLE `automation_snmp_items` ADD `snmp_engine_id`	[Success]
399	ALTER TABLE host MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
400	ALTER TABLE host MODIFY COLUMN site_id int(10) unsigned DEFAULT "1"	[Success]
401	ALTER TABLE `host` ADD `last_updated`	[Success]
402	ALTER TABLE `host` ADD INDEX last_updated(last_updated)	[Success]
403	ALTER TABLE `host` ADD INDEX last_updated(last_updated)	[Success]
404	ALTER TABLE `host_snmp_cache` ADD `last_updated`	[Success]
405	ALTER TABLE `host_snmp_cache` ADD INDEX last_updated(last_updated)	[Success]
406	ALTER TABLE `host_snmp_cache` ADD INDEX last_updated(last_updated)	[Success]
407	ALTER TABLE `poller_item` ADD `last_updated`	[Success]
408	ALTER TABLE `poller_item` ADD INDEX last_updated(last_updated)	[Success]
409	ALTER TABLE `poller_item` ADD INDEX last_updated(last_updated)	[Success]
410	ALTER TABLE `poller_command` ADD `last_updated`	[Success]
411	ALTER TABLE `poller_command` ADD INDEX last_updated(last_updated)	[Success]
412	ALTER TABLE `poller_command` ADD INDEX last_updated(last_updated)	[Success]
413	ALTER TABLE automation_networks MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
414	ALTER TABLE automation_processes MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
415	ALTER TABLE poller_command MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
416	ALTER TABLE poller_item MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
417	ALTER TABLE poller_time MODIFY COLUMN poller_id int(10) unsigned DEFAULT "1"	[Success]
418	ALTER TABLE `graph_local` ADD `snmp_query_graph_id`	[Success]
419	ALTER TABLE `graph_local` ADD INDEX snmp_query_graph_id(snmp_query_graph_id)	[Success]
420	ALTER TABLE `graph_local` ADD INDEX snmp_query_graph_id(snmp_query_graph_id)	[Success]
421	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]
422	ALTER TABLE `graph_tree` ADD `sequence`	[Success]
423	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
424	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
425	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
426	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
427	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
428	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
429	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
430	UPDATE graph_tree SET sequence = ? WHERE id = ?	[Success]
431	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'	[Success]
432	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]
433	ALTER TABLE host_snmp_cache MODIFY COLUMN field_value varchar(512) DEFAULT NULL	[Success]
434	UPDATE graph_templates_graph SET t_auto_scale_opts='' WHERE t_auto_scale_opts IS NULL	[Success]
435	UPDATE graph_templates_graph SET t_auto_scale_opts='' WHERE t_auto_scale_opts='0'	[Success]
436	UPDATE graph_templates_graph SET t_auto_scale_log='' WHERE t_auto_scale_log IS NULL	[Success]
437	UPDATE graph_templates_graph SET t_auto_scale_log='' WHERE t_auto_scale_log='0'	[Success]
438	UPDATE graph_templates_graph SET t_scale_log_units='' WHERE t_scale_log_units IS NULL	[Success]
439	UPDATE graph_templates_graph SET t_scale_log_units='' WHERE t_scale_log_units='0'	[Success]
440	UPDATE graph_templates_graph SET t_auto_scale_rigid='' WHERE t_auto_scale_rigid IS NULL	[Success]
441	UPDATE graph_templates_graph SET t_auto_scale_rigid='' WHERE t_auto_scale_rigid='0'	[Success]
442	UPDATE graph_templates_graph SET t_auto_padding='' WHERE t_auto_padding IS NULL	[Success]
443	UPDATE graph_templates_graph SET t_auto_padding='' WHERE t_auto_padding='0'	[Success]
444	UPDATE graph_templates_graph SET t_base_value='' WHERE t_base_value IS NULL	[Success]
445	UPDATE graph_templates_graph SET t_base_value='' WHERE t_base_value='0'	[Success]
446	UPDATE graph_templates_graph SET t_grouping='' WHERE t_grouping IS NULL	[Success]
447	UPDATE graph_templates_graph SET t_grouping='' WHERE t_grouping='0'	[Success]
448	UPDATE graph_templates_graph SET t_unit_value='' WHERE t_unit_value IS NULL	[Success]
449	UPDATE graph_templates_graph SET t_unit_value='' WHERE t_unit_value='0'	[Success]
450	UPDATE graph_templates_graph SET t_unit_exponent_value='' WHERE t_unit_exponent_value IS NULL	[Success]
451	UPDATE graph_templates_graph SET t_unit_exponent_value='' WHERE t_unit_exponent_value='0'	[Success]
452	UPDATE graph_templates_graph SET t_alt_y_grid='' WHERE t_alt_y_grid IS NULL	[Success]
453	UPDATE graph_templates_graph SET t_alt_y_grid='' WHERE t_alt_y_grid='0'	[Success]
454	UPDATE graph_templates_graph SET t_right_axis='' WHERE t_right_axis IS NULL	[Success]
455	UPDATE graph_templates_graph SET t_right_axis='' WHERE t_right_axis='0'	[Success]
456	UPDATE graph_templates_graph SET t_right_axis_label='' WHERE t_right_axis_label IS NULL	[Success]
457	UPDATE graph_templates_graph SET t_right_axis_label='' WHERE t_right_axis_label='0'	[Success]
458	UPDATE graph_templates_graph SET t_right_axis_format='' WHERE t_right_axis_format IS NULL	[Success]
459	UPDATE graph_templates_graph SET t_right_axis_format='' WHERE t_right_axis_format='0'	[Success]
460	UPDATE graph_templates_graph SET t_right_axis_formatter='' WHERE t_right_axis_formatter IS NULL	[Success]
461	UPDATE graph_templates_graph SET t_right_axis_formatter='' WHERE t_right_axis_formatter='0'	[Success]
462	UPDATE graph_templates_graph SET t_left_axis_formatter='' WHERE t_left_axis_formatter IS NULL	[Success]
463	UPDATE graph_templates_graph SET t_left_axis_formatter='' WHERE t_left_axis_formatter='0'	[Success]
464	UPDATE graph_templates_graph SET t_no_gridfit='' WHERE t_no_gridfit IS NULL	[Success]
465	UPDATE graph_templates_graph SET t_no_gridfit='' WHERE t_no_gridfit='0'	[Success]
466	UPDATE graph_templates_graph SET t_unit_length='' WHERE t_unit_length IS NULL	[Success]
467	UPDATE graph_templates_graph SET t_unit_length='' WHERE t_unit_length='0'	[Success]
468	UPDATE graph_templates_graph SET t_tab_width='' WHERE t_tab_width IS NULL	[Success]
469	UPDATE graph_templates_graph SET t_tab_width='' WHERE t_tab_width='0'	[Success]
470	UPDATE graph_templates_graph SET t_dynamic_labels='' WHERE t_dynamic_labels IS NULL	[Success]
471	UPDATE graph_templates_graph SET t_dynamic_labels='' WHERE t_dynamic_labels='0'	[Success]
472	UPDATE graph_templates_graph SET t_force_rules_legend='' WHERE t_force_rules_legend IS NULL	[Success]
473	UPDATE graph_templates_graph SET t_force_rules_legend='' WHERE t_force_rules_legend='0'	[Success]
474	UPDATE graph_templates_graph SET t_legend_position='' WHERE t_legend_position IS NULL	[Success]
475	UPDATE graph_templates_graph SET t_legend_position='' WHERE t_legend_position='0'	[Success]
476	UPDATE graph_templates_graph SET t_legend_direction='' WHERE t_legend_direction IS NULL	[Success]
477	UPDATE graph_templates_graph SET t_legend_direction='' WHERE t_legend_direction='0'	[Success]
478	UPDATE graph_templates_graph SET t_image_format_id='' WHERE t_image_format_id IS NULL	[Success]
479	UPDATE graph_templates_graph SET t_image_format_id='' WHERE t_image_format_id='0'	[Success]
480	UPDATE graph_templates_graph SET t_title='' WHERE t_title IS NULL	[Success]
481	UPDATE graph_templates_graph SET t_title='' WHERE t_title='0'	[Success]
482	UPDATE graph_templates_graph SET t_height='' WHERE t_height IS NULL	[Success]
483	UPDATE graph_templates_graph SET t_height='' WHERE t_height='0'	[Success]
484	UPDATE graph_templates_graph SET t_width='' WHERE t_width IS NULL	[Success]
485	UPDATE graph_templates_graph SET t_width='' WHERE t_width='0'	[Success]
486	UPDATE graph_templates_graph SET t_upper_limit='' WHERE t_upper_limit IS NULL	[Success]
487	UPDATE graph_templates_graph SET t_upper_limit='' WHERE t_upper_limit='0'	[Success]
488	UPDATE graph_templates_graph SET t_lower_limit='' WHERE t_lower_limit IS NULL	[Success]
489	UPDATE graph_templates_graph SET t_lower_limit='' WHERE t_lower_limit='0'	[Success]
490	UPDATE graph_templates_graph SET t_vertical_label='' WHERE t_vertical_label IS NULL	[Success]
491	UPDATE graph_templates_graph SET t_vertical_label='' WHERE t_vertical_label='0'	[Success]
492	UPDATE graph_templates_graph SET t_slope_mode='' WHERE t_slope_mode IS NULL	[Success]
493	UPDATE graph_templates_graph SET t_slope_mode='' WHERE t_slope_mode='0'	[Success]
494	UPDATE graph_templates_graph SET t_auto_scale='' WHERE t_auto_scale IS NULL	[Success]
495	UPDATE graph_templates_graph SET t_auto_scale='' WHERE t_auto_scale='0'	[Success]
496	UPDATE graph_templates_graph SET unit_value='' WHERE unit_value='on'	[Success]
497	ALTER TABLE `data_local` ADD INDEX snmp_index(snmp_index(191))	[Success]
498	ALTER TABLE `data_local` ADD INDEX snmp_index(snmp_index(191))	[Success]
499	ALTER TABLE graph_local DROP INDEX snmp_index	[Success]
500	ALTER TABLE graph_local DROP INDEX snmp_index	[Success]
501	ALTER TABLE `graph_local` ADD INDEX snmp_index(snmp_index(191))	[Success]
502	ALTER TABLE `graph_local` ADD INDEX snmp_index(snmp_index(191))	[Success]
503Process Log
504
5052019/03/06 12:46:22 - INSTALL: always: Installation was started at 2019-03-06 10:41:50, completed at 2019-03-06 10:46:22
5062019/03/06 12:46:21 - INSTALL: always: WARNING: One or more upgrades failed to install correctly
5072019/03/06 12:46:21 - INSTALL: always: Finished UPGRADE Process for v1.2.2
5082019/03/06 12:42:29 - INSTALL: always: Upgrading from v0.8.8c (DB 1.2.2 (DB: 0.8.8c)) to v1.0.0
5092019/03/06 12:42:29 - INSTALL: always: NOTE: Using temporary file for db cache: /tmp/cduk8dm6j
5102019/03/06 12:42:29 - INSTALL: always: Switched from to /tmp/cduk8dm6j
5112019/03/06 12:42:28 - INSTALL: always: Converting Table #73 'weathermap_settings'
5122019/03/06 12:42:28 - INSTALL: always: Converting Table #72 'weathermap_maps'
5132019/03/06 12:42:28 - INSTALL: always: Converting Table #71 'weathermap_groups'
5142019/03/06 12:42:27 - INSTALL: always: Converting Table #70 'weathermap_data'
5152019/03/06 12:42:27 - INSTALL: always: Converting Table #69 'weathermap_auth'
5162019/03/06 12:42:26 - INSTALL: always: Converting Table #68 'version'
5172019/03/06 12:42:25 - INSTALL: always: Converting Table #67 'user_log'
5182019/03/06 12:42:25 - INSTALL: always: Converting Table #66 'user_auth_realm'
5192019/03/06 12:42:25 - INSTALL: always: Converting Table #65 'user_auth_perms'
5202019/03/06 12:42:24 - INSTALL: always: Converting Table #64 'user_auth'
5212019/03/06 12:42:24 - INSTALL: always: Converting Table #63 'thold_template'
5222019/03/06 12:42:23 - INSTALL: always: Converting Table #62 'thold_data'
5232019/03/06 12:42:23 - INSTALL: always: Converting Table #61 'snmp_query_graph_sv'
5242019/03/06 12:42:23 - INSTALL: always: Converting Table #60 'snmp_query_graph_rrd_sv'
5252019/03/06 12:42:22 - INSTALL: always: Converting Table #59 'snmp_query_graph_rrd'
5262019/03/06 12:42:22 - INSTALL: always: Converting Table #58 'snmp_query_graph'
5272019/03/06 12:42:22 - INSTALL: always: Converting Table #57 'snmp_query'
5282019/03/06 12:42:21 - INSTALL: always: Converting Table #56 'settings_tree'
5292019/03/06 12:42:21 - INSTALL: always: Converting Table #55 'settings_graphs'
5302019/03/06 12:42:20 - INSTALL: always: Converting Table #54 'settings'
5312019/03/06 12:42:20 - INSTALL: always: Converting Table #53 'rra_cf'
5322019/03/06 12:42:20 - INSTALL: always: Converting Table #52 'rra'
5332019/03/06 12:42:20 - INSTALL: always: Converting Table #51 'poller_time'
5342019/03/06 12:42:20 - INSTALL: always: Converting Table #50 'poller_reindex'
5352019/03/06 12:42:19 - INSTALL: always: Converting Table #49 'poller_output_rt'
5362019/03/06 12:42:19 - INSTALL: always: Converting Table #48 'poller_output'
5372019/03/06 12:42:17 - INSTALL: always: Converting Table #47 'poller_item'
5382019/03/06 12:42:17 - INSTALL: always: Converting Table #46 'poller_command'
5392019/03/06 12:42:17 - INSTALL: always: Converting Table #45 'poller'
5402019/03/06 12:42:17 - INSTALL: always: Converting Table #44 'plugin_thold_threshold_contact'
5412019/03/06 12:42:16 - INSTALL: always: Converting Table #43 'plugin_thold_template_contact'
5422019/03/06 12:42:16 - INSTALL: always: Converting Table #42 'plugin_thold_log'
5432019/03/06 12:42:16 - INSTALL: always: Converting Table #41 'plugin_thold_host_failed'
5442019/03/06 12:42:15 - INSTALL: always: Converting Table #40 'plugin_thold_contacts'
5452019/03/06 12:42:15 - INSTALL: always: Converting Table #39 'plugin_rrdclean_action'
5462019/03/06 12:42:15 - INSTALL: always: Converting Table #38 'plugin_rrdclean'
5472019/03/06 12:42:14 - INSTALL: always: Converting Table #37 'plugin_realms'
5482019/03/06 12:42:14 - INSTALL: always: Converting Table #36 'plugin_notification_lists'
5492019/03/06 12:42:14 - INSTALL: always: Converting Table #35 'plugin_hooks'
5502019/03/06 12:42:13 - INSTALL: always: Converting Table #34 'plugin_db_changes'
5512019/03/06 12:42:13 - INSTALL: always: Converting Table #33 'plugin_config'
5522019/03/06 12:42:13 - INSTALL: always: Converting Table #32 'plugin_autom8_tree_rules'
5532019/03/06 12:42:13 - INSTALL: always: Converting Table #31 'plugin_autom8_tree_rule_items'
5542019/03/06 12:42:12 - INSTALL: always: Converting Table #30 'plugin_autom8_match_rule_items'
5552019/03/06 12:42:12 - INSTALL: always: Converting Table #29 'plugin_autom8_graph_rules'
5562019/03/06 12:42:12 - INSTALL: always: Converting Table #28 'plugin_autom8_graph_rule_items'
5572019/03/06 12:42:11 - INSTALL: always: Converting Table #27 'host_template_snmp_query'
5582019/03/06 12:42:11 - INSTALL: always: Converting Table #26 'host_template_graph'
5592019/03/06 12:42:11 - INSTALL: always: Converting Table #25 'host_template'
5602019/03/06 12:42:11 - INSTALL: always: Converting Table #24 'host_snmp_query'
5612019/03/06 12:42:10 - INSTALL: always: Converting Table #23 'host_snmp_cache'
5622019/03/06 12:42:10 - INSTALL: always: Converting Table #22 'host_graph'
5632019/03/06 12:42:10 - INSTALL: always: Converting Table #21 'host'
5642019/03/06 12:42:09 - INSTALL: always: Converting Table #20 'graph_tree_items'
5652019/03/06 12:42:09 - INSTALL: always: Converting Table #19 'graph_tree'
5662019/03/06 12:42:07 - INSTALL: always: Converting Table #18 'graph_templates_item'
5672019/03/06 12:42:05 - INSTALL: always: Converting Table #17 'graph_templates_graph'
5682019/03/06 12:42:05 - INSTALL: always: Converting Table #16 'graph_templates_gprint'
5692019/03/06 12:42:04 - INSTALL: always: Converting Table #15 'graph_templates'
5702019/03/06 12:42:04 - INSTALL: always: Converting Table #14 'graph_template_input_defs'
5712019/03/06 12:42:03 - INSTALL: always: Converting Table #13 'graph_template_input'
5722019/03/06 12:42:02 - INSTALL: always: Converting Table #12 'graph_local'
5732019/03/06 12:42:00 - INSTALL: always: Converting Table #11 'data_template_rrd'
5742019/03/06 12:41:57 - INSTALL: always: Converting Table #10 'data_template_data_rra'
5752019/03/06 12:41:55 - INSTALL: always: Converting Table #9 'data_template_data'
5762019/03/06 12:41:55 - INSTALL: always: Converting Table #8 'data_template'
5772019/03/06 12:41:54 - INSTALL: always: Converting Table #7 'data_local'
5782019/03/06 12:41:53 - INSTALL: always: Converting Table #6 'data_input_fields'
5792019/03/06 12:41:52 - INSTALL: always: Converting Table #5 'data_input_data'
5802019/03/06 12:41:51 - INSTALL: always: Converting Table #4 'data_input'
5812019/03/06 12:41:51 - INSTALL: always: Converting Table #3 'colors'
5822019/03/06 12:41:51 - INSTALL: always: Converting Table #2 'cdef_items'
5832019/03/06 12:41:51 - INSTALL: always: Converting Table #1 'cdef'
5842019/03/06 12:41:51 - INSTALL: always: Found 73 tables to convert
5852019/03/06 12:41:51 - INSTALL: always: Starting UPGRADE Process for v1.2.2
5862019/03/06 12:41:50 - INSTALL: always: Setting PHP Option memory_limit = -1
5872019/03/06 12:41:50 - INSTALL: always: Setting PHP Option max_execution_time = 0
5882019/03/06 12:41:50 - INSTALL: Checking arguments
58903/06/2019 12:41:50 - INSTALL: always: Spawning background process: /usr/bin/php /var/www/cacti/install/background.php 1551868910.7064