Hi everyone, i'm trying to upgrade my board from version 4.5.4.2 to 4.7.2.1. I have a fix to made to database, and even hitting on "fix automatically" or executing queries manually on db it still shows error that i have to fix database with this queries:

UPDATE `invision_core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL;
ALTER TABLE `invision_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`);

Any suggestion?

Tks

Please  upload a fresh set of files from your client area, then run the upgrade from /admin/upgrade . Let us know if this works for you and if not let us know here right away and we can get it sorted for you

Done, upgrade page finished without errors and now ... HTTP ERROR 500 😞

Please use recovery mode to disable all 3rd party items. Its very likely one of those is not compatible with your site

https://invisioncommunity.com/4guides/client-services/getting-support-r292/#recoverymode

I see that i have to edit a constants.php file that i don't have. 

I've created it at main level but it's not working

I have created a ticket for you on this so we can take a closer look