I am trying to upgrade from v4.5.4.2 to v4.7.12, but two issues are stopping me.
I'm currently running PHP version 7.4.30 and when I try to upgrade to PHP 8.1 to be able to perform the upgrade, my community and ACP eventually stops working.
Also, once I run on PHP 8.1 (or 8.0) I get "database problems" that I can't seem to fix. My ACP says I need to run these queries:
UPDATE `core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL;
ALTER TABLE `core_output_cache` DROP INDEX `cache_expire`, CHANGE COLUMN `cache_expire` `cache_expire` INT NOT NULL DEFAULT 0 COMMENT 'Unix timestamp of when the cache expires', ADD KEY `cache_expire` (`cache_expire`);
UPDATE `blog_entry_categories` SET `entry_category_blog_id`=0 WHERE `entry_category_blog_id` IS NULL;
ALTER TABLE `blog_entry_categories` CHANGE COLUMN `entry_category_blog_id` `entry_category_blog_id` INT NOT NULL DEFAULT 0 ;
But it doesn't help if I try to fix them automatically or run them manually. I still get a "database problems" message when I try to upgrade.
What should I do? I am using the automatic installation process in my ACP. Should I upgrade from v4.5.4.2 to v4.7.12 manually instead?