jiangmeichao
Chevereto Member
Description of the issue
My chevereto program failed to update 3.17.0
When updating version 3.17.0, the prompt is as follows:
# Dumped update query. https://v3-docs.chevereto.com/setup/update-guide.html#manual-procedure
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_albums` ADD `album_cover_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_albums` ADD `album_parent_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_images` ADD `image_is_360` tinyint(1) NOT NULL DEFAULT '0';
UPDATE chv_albums
SET album_cover_id = (SELECT image_id FROM chv_images WHERE image_album_id = album_id AND image_is_approved = 1 LIMIT 1)
WHERE album_cover_id IS NULL;
ALTER TABLE `chv_images` ADD KEY `image_is_360` (`image_is_360`);
UPDATE `chv_settings` SET `setting_value` = "3.17.0" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";
My chevereto program failed to update 3.17.0
When updating version 3.17.0, the prompt is as follows:
# Dumped update query. https://v3-docs.chevereto.com/setup/update-guide.html#manual-procedure
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_albums` ADD `album_cover_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_albums` ADD `album_parent_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_images` ADD `image_is_360` tinyint(1) NOT NULL DEFAULT '0';
UPDATE chv_albums
SET album_cover_id = (SELECT image_id FROM chv_images WHERE image_album_id = album_id AND image_is_approved = 1 LIMIT 1)
WHERE album_cover_id IS NULL;
ALTER TABLE `chv_images` ADD KEY `image_is_360` (`image_is_360`);
UPDATE `chv_settings` SET `setting_value` = "3.17.0" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";