I tried to upgrade the software, but I got this error message on the first step:
Find a solution
There are some problems with your database. Normally it is safe to try to fix these problems automatically however if your community is large, you may want to run the necessary queries manually. If so, the queries to run are:
UPDATE `cyclone_core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL;
ALTER TABLE `cyclone_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`);
Running the queries automatically with the "Fix Automatically" button doesn't work. Running the queries directly in MySQL doesn't work. Furthermore, the table definition appears to already meet what they are trying to change, but it keeps displaying this same error over and over.
Please advise if you good.