• šŸ¤— This support section is delivered by the community, by other users of the software. Support in this section is not delivered by Chevereto Staff, remarks and issues in this section should be always taken with the appropriate context and care, with a grain of salt.

Update failed

Thanos92

Chevereto Member
Hello, after the last update i recieve this error:

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";
 

Rodolfo

ā­ Chevereto Godlike
Chevereto Staff
Administrator
Dear, that's not a problem actually. Is because either your website is too big or because you have enabled dump update query.

The query is dumped so you can issue all that query directly in your MySQL console. This is because in large installations the process (PHP) is limited under HTTP so it could timeout. As a safety system integrity measure those installs require to manually run the query.
 
Top