database error during update

[Murat333]

I'm getting the following error while updating;

previous version : 3.13.4

UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
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.5" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";

 

[Rodolfo]

dashboard/settings/system



"Run it manually" means that you have to run the SQL update, because you choose to dump the query.

3.14.0 will add this to avoid future misunderstandings:

 

[Murat333]

problem solved. Thank you.