🎯Description of the issue
Manual Update too Failed.
▶🚶Reproduction steps
😢Unexpected result
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_logins` MODIFY `login_secret` mediumtext DEFAULT NULL COMMENT 'The secret part';
ALTER TABLE `chv_settings` MODIFY `setting_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_ip` varchar(191) NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(191) DEFAULT NULL;
ALTER TABLE `chv_ip_bans` MODIFY `ip_ban_message` text DEFAULT NULL;
ALTER TABLE `chv_logins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_powered_by', '1', '1', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet', '0', '0', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet_api_key', NULL, NULL, 'string');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('stopforumspam', '0', '0', 'bool');
📃Error log message
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_logins` MODIFY `login_secret` mediumtext DEFAULT NULL COMMENT 'The secret part';
ALTER TABLE `chv_settings` MODIFY `setting_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_ip` varchar(191) NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(191) DEFAULT NULL;
ALTER TABLE `chv_ip_bans` MODIFY `ip_ban_message` text DEFAULT NULL;
ALTER TABLE `chv_logins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_powered_by', '1', '1', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet', '0', '0', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet_api_key', NULL, NULL, 'string');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('stopforumspam', '0', '0', 'bool');
UPDATE `chv_settings` SET `setting_value` = "3.13.4" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";
Manual Update too Failed.
▶🚶Reproduction steps
- Dashboard > Settings > install update
😢Unexpected result
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_logins` MODIFY `login_secret` mediumtext DEFAULT NULL COMMENT 'The secret part';
ALTER TABLE `chv_settings` MODIFY `setting_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_ip` varchar(191) NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(191) DEFAULT NULL;
ALTER TABLE `chv_ip_bans` MODIFY `ip_ban_message` text DEFAULT NULL;
ALTER TABLE `chv_logins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_powered_by', '1', '1', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet', '0', '0', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet_api_key', NULL, NULL, 'string');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('stopforumspam', '0', '0', 'bool');
📃Error log message
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_logins` MODIFY `login_secret` mediumtext DEFAULT NULL COMMENT 'The secret part';
ALTER TABLE `chv_settings` MODIFY `setting_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_ip` varchar(191) NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(191) DEFAULT NULL;
ALTER TABLE `chv_ip_bans` MODIFY `ip_ban_message` text DEFAULT NULL;
ALTER TABLE `chv_logins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_powered_by', '1', '1', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet', '0', '0', 'bool');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet_api_key', NULL, NULL, 'string');
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('stopforumspam', '0', '0', 'bool');
UPDATE `chv_settings` SET `setting_value` = "3.13.4" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";
Last edited: