-
Issue with upgrading
Hello, that is the exact output of the query that shows the database's character set.
-
Issue with upgrading
I am not sure what you mean. The info I sent is directly from the server itself and is accurate. Is there something I should be changing?
-
Issue with upgrading
The database server uses MariaDB 10.6 and the database uses the utf8mb4 character set. Output from checking that is below: MariaDB [siyclone_cyclone]> show variables like "character_set_database"; +------------------------+---------+ | Variable_name | Value | +------------------------+---------+ | character_set_database | utf8mb4 | +------------------------+---------+ 1 row in set (0.002 sec)
-
Issue with upgrading
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.
-
-
-
-
Help with fixing database before update
Thank you. I have reached out to them as of this morning with your suggestion. This is far beyond my level of expertise and if it cannot be resolved, I will have to just end my site and let my Invision license expire. It’s been a great run.
-
Help with fixing database before update
Thanks. The host has cleared the resource limit, but now I'm seeing formatting text when I try to access the admin panel:
-
Help with fixing database before update
Hello. I have this same issue. When I tried to fix the database myself, it has now made the admin panel and site inaccessible. Any advice? I do not have server access and work through my server host for things outside the admin panel. Currently, I am receiving a message that states Resource Limit Is Reached The website is temporarily unable to service your request as it exceeded resource limit. Please try again later.