Upgrade impossible

[ScuolaNotarileNapoletana]

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

[Marc]

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

[ScuolaNotarileNapoletana]

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

[Marc]

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

[ScuolaNotarileNapoletana]

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

[Marc]

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