Hello y’all
I tried to upgrade centreon from 20.04 to hos latest version but i’ve got this error.
Can someone help me please.
Thanks.
Solved
Upgrading from centreon 20.04 to 22
+3Best answer by marcelluis
Hello
This command has resolved the issue for me : SET GLOBAL innodb_strict_mode = 0;
Hope it will help someone else
+14Hallo, Can you share your logs upgrade.log and sql-error.log?
+21Hi
Can you edit the /usr/share/centreon/src/Core/Platform/Infrastructure/Repository/DbWriteUpdateRepository.php file at line 289 and change this bloc:
private function isSqlComment(string $line): bool
{
return str_starts_with(trim($line), '--');
}Then refresh your page (Ctrl + F5)
Regards
+3Hello
I restored centreon yesterday to his 20.04 version
Today i have this issue
I juste need to drop that from centreon.cf_nagios table ?
+21Hi
ALTER TABLE `cfg_nagios` DROP COLUMN `postpone_notification_to_timeperiodregards,
+21Can you send me the result of this SQL request:
show create table cfg_nagios;
+21Can you copy-past the result in a bloc code for better readability?
+3Hello Y’all
Sorry for the late : here is the result
| Table | Create Table -------------------------------------------------------------------------------------------------------------------------+
| cfg_nagios | CREATE TABLE `cfg_nagios` (
`nagios_id` int(11) NOT NULL AUTO_INCREMENT,
`nagios_name` varchar(255) DEFAULT NULL,
`use_timezone` int(11) unsigned DEFAULT NULL,
`log_file` varchar(255) DEFAULT NULL,
`cfg_dir` varchar(255) DEFAULT NULL,
`temp_file` varchar(255) DEFAULT NULL,
`status_file` varchar(255) DEFAULT NULL,
`status_update_interval` int(11) DEFAULT NULL,
`nagios_user` varchar(255) DEFAULT NULL,
`nagios_group` varchar(255) DEFAULT NULL,
`postpone_notification_to_timeperiod` tinyint(1) DEFAULT 0,
`enable_notifications` enum('0','1','2') DEFAULT NULL,
`execute_service_checks` enum('0','1','2') DEFAULT NULL,
`accept_passive_service_checks` enum('0','1','2') DEFAULT NULL,
`execute_host_checks` enum('0','1','2') DEFAULT NULL,
`accept_passive_host_checks` enum('0','1','2') DEFAULT NULL,
`enable_event_handlers` enum('0','1','2') DEFAULT NULL,
`log_rotation_method` varchar(255) DEFAULT NULL,
`log_archive_path` varchar(255) DEFAULT NULL,
`check_external_commands` enum('0','1','2') DEFAULT NULL,
`external_command_buffer_slots` int(11) DEFAULT NULL,
`command_check_interval` varchar(255) DEFAULT NULL,
`command_file` varchar(255) DEFAULT NULL,
`downtime_file` varchar(255) DEFAULT NULL,
`comment_file` varchar(255) DEFAULT NULL,
`lock_file` varchar(255) DEFAULT NULL,
`retain_state_information` enum('0','1','2') DEFAULT NULL,
`state_retention_file` varchar(255) DEFAULT NULL,
`retention_update_interval` int(11) DEFAULT NULL,
`use_retained_program_state` enum('0','1','2') DEFAULT NULL,
`use_retained_scheduling_info` enum('0','1','2') DEFAULT NULL,
`retained_contact_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_contact_service_attribute_mask` bigint(20) DEFAULT NULL,
`retained_process_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_process_service_attribute_mask` bigint(20) DEFAULT NULL,
`retained_host_attribute_mask` bigint(20) DEFAULT NULL,
`retained_service_attribute_mask` bigint(20) DEFAULT NULL,
`use_syslog` enum('0','1','2') DEFAULT NULL,
`log_notifications` enum('0','1','2') DEFAULT NULL,
`log_service_retries` enum('0','1','2') DEFAULT NULL,
`log_host_retries` enum('0','1','2') DEFAULT NULL,
`log_event_handlers` enum('0','1','2') DEFAULT NULL,
`log_initial_states` enum('0','1','2') DEFAULT NULL,
`log_external_commands` enum('0','1','2') DEFAULT NULL,
`log_passive_checks` enum('0','1','2') DEFAULT NULL,
`global_host_event_handler` int(11) DEFAULT NULL,
`global_service_event_handler` int(11) DEFAULT NULL,
`sleep_time` varchar(10) DEFAULT NULL,
`service_inter_check_delay_method` varchar(255) DEFAULT NULL,
`host_inter_check_delay_method` varchar(255) DEFAULT NULL,
`service_interleave_factor` varchar(255) DEFAULT NULL,
`max_concurrent_checks` int(11) DEFAULT NULL,
`max_service_check_spread` int(11) DEFAULT NULL,
`max_host_check_spread` int(11) DEFAULT NULL,
`check_result_reaper_frequency` int(11) DEFAULT NULL,
`max_check_result_reaper_time` int(11) DEFAULT NULL,
`interval_length` int(11) DEFAULT NULL,
`auto_reschedule_checks` enum('0','1','2') DEFAULT NULL,
`auto_rescheduling_interval` int(11) DEFAULT NULL,
`auto_rescheduling_window` int(11) DEFAULT NULL,
`use_aggressive_host_checking` enum('0','1','2') DEFAULT NULL,
`enable_flap_detection` enum('0','1','2') DEFAULT NULL,
`low_service_flap_threshold` varchar(255) DEFAULT NULL,
`high_service_flap_threshold` varchar(255) DEFAULT NULL,
`low_host_flap_threshold` varchar(255) DEFAULT NULL,
`high_host_flap_threshold` varchar(255) DEFAULT NULL,
`soft_state_dependencies` enum('0','1','2') DEFAULT NULL,
`service_check_timeout` int(11) DEFAULT NULL,
`host_check_timeout` int(11) DEFAULT NULL,
`event_handler_timeout` int(11) DEFAULT NULL,
`notification_timeout` int(11) DEFAULT NULL,
`ocsp_timeout` int(11) DEFAULT NULL,
`ochp_timeout` int(11) DEFAULT NULL,
`perfdata_timeout` int(11) DEFAULT NULL,
`obsess_over_services` enum('0','1','2') DEFAULT NULL,
`ocsp_command` int(11) DEFAULT NULL,
`obsess_over_hosts` enum('0','1','2') DEFAULT NULL,
`ochp_command` int(11) DEFAULT NULL,
`process_performance_data` enum('0','1','2') DEFAULT NULL,
`host_perfdata_command` int(11) DEFAULT NULL,
`service_perfdata_command` int(11) DEFAULT NULL,
`host_perfdata_file` varchar(255) DEFAULT NULL,
`service_perfdata_file` varchar(255) DEFAULT NULL,
`host_perfdata_file_template` text DEFAULT NULL,
`service_perfdata_file_template` text DEFAULT NULL,
`host_perfdata_file_mode` enum('a','w','2') DEFAULT NULL,
`service_perfdata_file_mode` enum('a','w','2') DEFAULT NULL,
`host_perfdata_file_processing_interval` int(11) DEFAULT NULL,
`service_perfdata_file_processing_interval` int(11) DEFAULT NULL,
`host_perfdata_file_processing_command` int(11) DEFAULT NULL,
`service_perfdata_file_processing_command` int(11) DEFAULT NULL,
`check_for_orphaned_services` enum('0','1','2') DEFAULT NULL,
`check_for_orphaned_hosts` enum('0','1','2') DEFAULT NULL,
`check_service_freshness` enum('0','1','2') DEFAULT NULL,
`service_freshness_check_interval` int(11) DEFAULT NULL,
`freshness_check_interval` int(11) DEFAULT NULL,
`check_host_freshness` enum('0','1','2') DEFAULT NULL,
`host_freshness_check_interval` int(11) DEFAULT NULL,
`date_format` varchar(255) DEFAULT NULL,
`instance_heartbeat_interval` smallint(6) DEFAULT 30,
`illegal_object_name_chars` varchar(255) DEFAULT NULL,
`illegal_macro_output_chars` varchar(255) DEFAULT NULL,
`use_regexp_matching` enum('0','1','2') DEFAULT NULL,
`use_true_regexp_matching` enum('0','1','2') DEFAULT NULL,
`admin_email` varchar(255) DEFAULT NULL,
`admin_pager` varchar(255) DEFAULT NULL,
`nagios_comment` text DEFAULT NULL,
`nagios_activate` enum('0','1') DEFAULT NULL,
`event_broker_options` varchar(255) DEFAULT NULL,
`translate_passive_host_checks` int(11) DEFAULT NULL,
`nagios_server_id` int(11) DEFAULT NULL,
`enable_predictive_host_dependency_checks` enum('0','1','2') DEFAULT NULL,
`enable_predictive_service_dependency_checks` enum('0','1','2') DEFAULT NULL,
`cached_host_check_horizon` int(11) DEFAULT NULL,
`cached_service_check_horizon` int(11) DEFAULT NULL,
`passive_host_checks_are_soft` int(11) DEFAULT NULL,
`use_large_installation_tweaks` enum('0','1','2') DEFAULT NULL,
`enable_environment_macros` enum('0','1','2') DEFAULT NULL,
`use_setpgid` enum('0','1','2') DEFAULT NULL,
`additional_freshness_latency` int(11) DEFAULT NULL,
`debug_file` varchar(255) DEFAULT NULL,
`debug_level` int(11) DEFAULT NULL,
`debug_level_opt` varchar(200) DEFAULT '0',
`debug_verbosity` enum('0','1','2') DEFAULT NULL,
`max_debug_file_size` int(11) DEFAULT NULL,
`daemon_dumps_core` enum('0','1') DEFAULT NULL,
`cfg_file` varchar(255) NOT NULL DEFAULT 'centengine.cfg',
`log_pid` enum('0','1') DEFAULT '1',
`enable_macros_filter` enum('0','1') DEFAULT '0',
`macros_filter` text DEFAULT NULL,
PRIMARY KEY (`nagios_id`),
KEY `cmd1_index` (`global_host_event_handler`),
KEY `cmd2_index` (`global_service_event_handler`),
KEY `cmd3_index` (`ocsp_command`),
KEY `cmd4_index` (`ochp_command`),
KEY `cmd5_index` (`host_perfdata_command`),
KEY `cmd6_index` (`service_perfdata_command`),
KEY `cmd7_index` (`host_perfdata_file_processing_command`),
KEY `cmd8_index` (`service_perfdata_file_processing_command`),
KEY `nagios_server_id` (`nagios_server_id`),
KEY `cfg_nagios_ibfk_27` (`use_timezone`),
CONSTRAINT `cfg_nagios_ibfk_15` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_18` FOREIGN KEY (`global_host_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_19` FOREIGN KEY (`global_service_event_handler`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_20` FOREIGN KEY (`ocsp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_21` FOREIGN KEY (`ochp_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_22` FOREIGN KEY (`host_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_23` FOREIGN KEY (`service_perfdata_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_24` FOREIGN KEY (`host_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_25` FOREIGN KEY (`service_perfdata_file_processing_command`) REFERENCES `command` (`command_id`) ON DELETE SET NULL,
CONSTRAINT `cfg_nagios_ibfk_26` FOREIGN KEY (`nagios_server_id`) REFERENCES `nagios_server` (`id`) ON DELETE CASCADE,
CONSTRAINT `cfg_nagios_ibfk_27` FOREIGN KEY (`use_timezone`) REFERENCES `timezone` (`timezone_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 |
1 row in set (0.000 sec)
+3Hello
This command has resolved the issue for me : SET GLOBAL innodb_strict_mode = 0;
Hope it will help someone else
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.