Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.
Please keep in mind:
Support response
Support checklist
UPDATE `chv_gvsettings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance'; UPDATE `chv_gvsettings` SET `setting_value` = 0, `setting_default` = 0, `setting_typeset` = "bool" WHERE `setting_name` = "maintenance"; INSERT IGNORE INTO `chv_gvstorage_apis` VALUES ('7', 'OpenStack', 'openstack'); UPDATE `chv_gvsettings` SET `setting_value`="mail" WHERE setting_name = "email_mode" AND `setting_value`="phpmail"; UPDATE `chv_gvsettings` SET `setting_default`="mail" WHERE setting_name = "email_mode"; TRUNCATE TABLE `chv_gvstats`; INSERT INTO `chv_gvstats` (stat_id, stat_date_gmt, stat_type) VALUES ("1", NULL, "total") ON DUPLICATE KEY UPDATE stat_type=stat_type; UPDATE `chv_gvstats` SET stat_images = (SELECT IFNULL(COUNT(*),0) FROM `chv_gvimages`), stat_albums = (SELECT IFNULL(COUNT(*),0) FROM `chv_gvalbums`), stat_users = (SELECT IFNULL(COUNT(*),0) FROM `chv_gvusers`), stat_image_views = (SELECT IFNULL(SUM(image_views),0) FROM `chv_gvimages`), stat_disk_used = (SELECT IFNULL(SUM(image_size) + SUM(image_thumb_size) + SUM(image_medium_size),0) FROM `chv_gvimages`) WHERE stat_type = "total"; INSERT INTO `chv_gvstats` (stat_type, stat_date_gmt, stat_images, stat_image_views, stat_disk_used) SELECT sb.stat_type, sb.stat_date_gmt, sb.stat_images, sb.stat_image_views, sb.stat_disk_used FROM (SELECT "date" AS stat_type, DATE(image_date_gmt) AS stat_date_gmt, COUNT(*) AS stat_images, SUM(image_views) AS stat_image_views, SUM(image_size + image_thumb_size + image_medium_size) AS stat_disk_used FROM `chv_gvimages` GROUP BY DATE(image_date_gmt)) AS sb ON DUPLICATE KEY UPDATE stat_images = sb.stat_images; INSERT INTO `chv_gvstats` (stat_type, stat_date_gmt, stat_users) SELECT sb.stat_type, sb.stat_date_gmt, sb.stat_users FROM (SELECT "date" AS stat_type, DATE(user_date_gmt) AS stat_date_gmt, COUNT(*) AS stat_users FROM `chv_gvusers` GROUP BY DATE(user_date_gmt)) AS sb ON DUPLICATE KEY UPDATE stat_users = sb.stat_users; INSERT INTO `chv_gvstats` (stat_type, stat_date_gmt, stat_albums) SELECT sb.stat_type, sb.stat_date_gmt, sb.stat_albums FROM (SELECT "date" AS stat_type, DATE(album_date_gmt) AS stat_date_gmt, COUNT(*) AS stat_albums FROM `chv_gvalbums` GROUP BY DATE(album_date_gmt)) AS sb ON DUPLICATE KEY UPDATE stat_albums = sb.stat_albums; UPDATE `chv_gvusers` SET user_content_views = COALESCE((SELECT SUM(image_views) FROM `chv_gvimages` WHERE image_user_id = user_id GROUP BY user_id), "0"); INSERT INTO `chv_gvstorage_apis` VALUES ('8', 'Local', 'local') ON DUPLICATE KEY UPDATE storage_api_type = 'local'; UPDATE `chv_gvpages` SET page_icon = "fas fa-landmark" WHERE page_url_key = "tos" AND page_icon IS NULL OR page_icon = ""; UPDATE `chv_gvpages` SET page_icon = "fas fa-lock" WHERE page_url_key = "privacy" AND page_icon IS NULL OR page_icon = ""; UPDATE `chv_gvpages` SET page_icon = "fas fa-at" WHERE page_url_key = "contact" AND page_icon IS NULL OR page_icon = ""; INSERT INTO `chv_gvstorage_apis` VALUES ("3", "Microsoft Azure", "azure") ON DUPLICATE KEY UPDATE storage_api_name = "Microsoft Azure"; INSERT INTO `chv_gvstorage_apis` VALUES ("9", "S3 compatible", "s3compatible") ON DUPLICATE KEY UPDATE storage_api_type = "s3compatible"; INSERT INTO `chv_gvstorage_apis` VALUES ("10", "Alibaba Cloud OSS", "oss") ON DUPLICATE KEY UPDATE storage_api_type = "oss"; INSERT INTO `chv_gvstorage_apis` VALUES ("11", "Backblaze B2", "b2") ON DUPLICATE KEY UPDATE storage_api_type = "b2"; UPDATE `chv_gvpages` SET page_internal = "tos" WHERE page_url_key = "tos"; UPDATE `chv_gvpages` SET page_internal = "privacy" WHERE page_url_key = "privacy"; UPDATE `chv_gvpages` SET page_internal = "contact" WHERE page_url_key = "contact"; ALTER TABLE `chv_gvip_bans` MODIFY `ip_ban_ip` varchar(255) NOT NULL; ALTER TABLE `chv_gvpages` MODIFY `page_internal` varchar(255) DEFAULT NULL; ALTER TABLE `chv_gvusers` MODIFY `user_username` varchar(255) NOT NULL; ALTER TABLE `chv_gvusers` MODIFY `user_email` varchar(255) DEFAULT NULL; ALTER TABLE `chv_gvusers` MODIFY `user_image_expiration` varchar(255) DEFAULT NULL; ALTER TABLE `chv_gvusers` MODIFY `user_registration_ip` varchar(255) NOT NULL; DROP INDEX `album_creation_ip` ON `chv_gvalbums`; ALTER TABLE `chv_gvalbums` ADD INDEX `album_creation_ip` (`album_creation_ip`(255)); DROP INDEX `image_name` ON `chv_gvimages`; ALTER TABLE `chv_gvimages` ADD INDEX `image_name` (`image_name`(255)); DROP INDEX `image_extension` ON `chv_gvimages`; ALTER TABLE `chv_gvimages` ADD INDEX `image_extension` (`image_extension`(255)); DROP INDEX `image_uploader_ip` ON `chv_gvimages`; ALTER TABLE `chv_gvimages` ADD INDEX `image_uploader_ip` (`image_uploader_ip`(255)); DROP INDEX `image_path` ON `chv_gvimages`; ALTER TABLE `chv_gvimages` ADD INDEX `image_path` (`image_path`(255)); ALTER TABLE `chv_gvimages` ENGINE=InnoDB; ALTER TABLE `chv_gvalbums` ENGINE=InnoDB; ALTER TABLE `chv_gvusers` ENGINE=InnoDB; ALTER TABLE `chv_gvalbums` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvcategories` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvdeletions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvimages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvip_bans` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvpages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvsettings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvstorages` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvusers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvlogins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; INSERT INTO `chv_gvimports` (`import_path`, `import_options`, `import_status`, `import_users`, `import_images`, `import_albums`, `import_time_created`, `import_time_updated`, `import_errors`, `import_started`, `import_continuous`) SELECT '/var/www/vhosts/gaiviet.vip/httpdocs/importing/no-parse', 'a:1:{s:4:"root";s:5:"plain";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '0', '1' FROM DUAL WHERE NOT EXISTS (SELECT * FROM `chv_gvimports` WHERE `import_path`='/var/www/vhosts/gaiviet.vip/httpdocs/importing/no-parse' AND `import_continuous`=1 LIMIT 1); INSERT INTO `chv_gvimports` (`import_path`, `import_options`, `import_status`, `import_users`, `import_images`, `import_albums`, `import_time_created`, `import_time_updated`, `import_errors`, `import_started`, `import_continuous`) SELECT '/var/www/vhosts/gaiviet.vip/httpdocs/importing/parse-users', 'a:1:{s:4:"root";s:5:"users";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '0', '1' FROM DUAL WHERE NOT EXISTS (SELECT * FROM `chv_gvimports` WHERE `import_path`='/var/www/vhosts/gaiviet.vip/httpdocs/importing/parse-users' AND `import_continuous`=1 LIMIT 1); INSERT INTO `chv_gvimports` (`import_path`, `import_options`, `import_status`, `import_users`, `import_images`, `import_albums`, `import_time_created`, `import_time_updated`, `import_errors`, `import_started`, `import_continuous`) SELECT '/var/www/vhosts/gaiviet.vip/httpdocs/importing/parse-albums', 'a:1:{s:4:"root";s:6:"albums";}', 'working', '0', '0', '0', NOW(), NOW(), '0', '0', '1' FROM DUAL WHERE NOT EXISTS (SELECT * FROM `chv_gvimports` WHERE `import_path`='/var/www/vhosts/gaiviet.vip/httpdocs/importing/parse-albums' AND `import_continuous`=1 LIMIT 1); ALTER TABLE `chv_gvalbums` ADD `album_cover_id` bigint(32) DEFAULT NULL; ALTER TABLE `chv_gvalbums` ADD `album_parent_id` bigint(32) DEFAULT NULL; ALTER TABLE `chv_gvimages` ADD `image_is_360` tinyint(1) NOT NULL DEFAULT '0'; UPDATE chv_gvalbums SET album_cover_id = (SELECT image_id FROM chv_gvimages WHERE image_album_id = album_id AND image_is_approved = 1 LIMIT 1) WHERE album_cover_id IS NULL; DROP TABLE IF EXISTS `chv_gvassets`; CREATE TABLE `chv_gvassets` ( `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`(191)) USING BTREE, KEY `md5` (`asset_md5`), KEY `filename` (`asset_filename`), KEY `file_path` (`asset_file_path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `chv_gvpages` ADD `page_code` text ; UPDATE `chv_gvsettings` SET `setting_value`="default/favicon.png" WHERE `setting_name`="favicon_image" AND `setting_value`="favicon.png"; UPDATE `chv_gvsettings` SET `setting_value`="default/logo.png" WHERE `setting_name`="logo_image" AND `setting_value`="logo.png"; UPDATE `chv_gvsettings` SET `setting_value`="default/logo.svg" WHERE `setting_name`="logo_vector" AND `setting_value`="logo.svg"; UPDATE `chv_gvsettings` SET `setting_value`="default/home_cover.jpg" WHERE `setting_name`="homepage_cover_image" AND `setting_value`="home_cover.jpg"; UPDATE `chv_gvsettings` SET `setting_value`="default/home_cover.jpg" WHERE `setting_name`="homepage_cover_image" AND `setting_value` IS NULL; UPDATE `chv_gvsettings` SET `setting_value`="default/logo_homepage.png" WHERE `setting_name`="logo_image_homepage" AND `setting_value`="logo_homepage.png"; UPDATE `chv_gvsettings` SET `setting_value`="default/logo_homepage.svg" WHERE `setting_name`="logo_vector_homepage" AND `setting_value`="logo_homepage.svg"; UPDATE `chv_gvsettings` SET `setting_value`="default/consent-screen_cover.jpg" WHERE `setting_name`="consent_screen_cover_image" AND `setting_value` IS NULL; ALTER TABLE `chv_gvimporting` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; ALTER TABLE `chv_gvimports` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; UPDATE `chv_gvsettings` SET `setting_value`="default/watermark.png" WHERE `setting_name`="watermark_image" AND `setting_value`="watermark.png"; UPDATE `chv_gvsettings` SET `setting_typeset`="string" WHERE `setting_name`="explore_albums_min_image_count"; UPDATE `chv_gvpages` SET `page_icon`="fas fa-landmark" WHERE `page_icon`="icon-text"; UPDATE `chv_gvpages` SET `page_icon`="fas fa-lock" WHERE `page_icon`="icon-lock"; UPDATE `chv_gvpages` SET `page_icon`="fas fa-at" WHERE `page_icon`="icon-mail"; ALTER TABLE `chv_gvimages` ADD KEY `image_is_360` (`image_is_360`); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_cover', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_listing', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_image-viewer_foot', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_image-viewer_top', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_after_image-viewer', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_after_header', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_before_header', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_footer', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_content_tab-about_column', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_content_before_comments', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_explore_after_top', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_user_after_top', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_user_before_listing', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_album_before_header', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_album_after_header', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_listing_before_pagination', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_listing_after_pagination', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_cover_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_listing_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_image-viewer_foot_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_image-viewer_top_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_after_image-viewer_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_after_header_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_before_header_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_image_footer_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_content_tab-about_column_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_content_before_comments_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_explore_after_top_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_user_after_top_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_user_before_listing_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_album_before_header_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_album_after_header_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_listing_before_pagination_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_listing_after_pagination_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_before_title', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_cta', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_before_title_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('banner_home_after_cta_nsfw', NULL, NULL, 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_uploads_url', '0', '0', 'bool'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('chevereto_news', 'a:0:{}', 'a:0:{}', 'string'); INSERT INTO `chv_gvsettings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('cron_last_ran', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'string'); DELETE FROM `chv_gvsettings` WHERE `setting_name` = 'cloudflare'; DELETE FROM `chv_gvsettings` WHERE `setting_name` = 'theme_show_embed_content'; DELETE FROM `chv_gvsettings` WHERE `setting_name` = 'theme_top_bar_color'; DELETE FROM `chv_gvsettings` WHERE `setting_name` = 'minify_enable'; UPDATE `chv_gvsettings` SET `setting_value` = "3.20.17" WHERE `setting_name` = "chevereto_version_installed"; UPDATE `chv_gvsettings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";