Hello, after the last update i recieve this error:
Problems executing the SQL update query. It is recommended that you issue the above SQL queries manually.
If you have altered your database
Update failed
The update process failed. Here is the error returned:Problems executing the SQL update query. It is recommended that you issue the above SQL queries manually.
If you have altered your database
Code:
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
DROP TABLE IF EXISTS `chv_assets`;
CREATE TABLE `chv_assets` (
`asset_id` bigint(32) NOT NULL AUTO_INCREMENT,
`asset_key` varchar(255) NOT NULL,
`asset_md5` varchar(32) NOT NULL,
`asset_filename` varchar(255) NOT NULL,
`asset_file_path` varchar(255) NOT NULL,
`asset_blob` blob,
PRIMARY KEY (`asset_id`),
UNIQUE KEY `key` (`asset_key`) USING BTREE,
KEY `md5` (`asset_md5`),
KEY `filename` (`asset_filename`),
KEY `file_path` (`asset_file_path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `chv_pages` ADD `page_code` text ;
UPDATE `chv_settings` SET `setting_value`="default/favicon.png" WHERE `setting_name`="favicon_image" AND `setting_value`="favicon.png";
UPDATE `chv_settings` SET `setting_value`="default/logo.png" WHERE `setting_name`="logo_image" AND `setting_value`="logo.png";
UPDATE `chv_settings` SET `setting_value`="default/logo.svg" WHERE `setting_name`="logo_vector" AND `setting_value`="logo.svg";
UPDATE `chv_settings` SET `setting_value`="default/home_cover.jpg" WHERE `setting_name`="homepage_cover_image" AND `setting_value`="home_cover.jpg";
UPDATE `chv_settings` SET `setting_value`="default/home_cover.jpg" WHERE `setting_name`="homepage_cover_image" AND `setting_value` IS NULL;
UPDATE `chv_settings` SET `setting_value`="default/logo_homepage.png" WHERE `setting_name`="logo_image_homepage" AND `setting_value`="logo_homepage.png";
UPDATE `chv_settings` SET `setting_value`="default/logo_homepage.svg" WHERE `setting_name`="logo_vector_homepage" AND `setting_value`="logo_homepage.svg";
UPDATE `chv_settings` SET `setting_value`="default/consent-screen_cover.jpg" WHERE `setting_name`="consent_screen_cover_image" AND `setting_value` IS NULL;
ALTER TABLE `chv_importing` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `chv_imports` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
DELETE FROM `chv_settings` WHERE `setting_name` = 'minify_enable';
UPDATE `chv_settings` SET `setting_value` = "3.20.3" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";