Adika
-
Posts
18 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by Adika
-
-
10 hours ago, Marc Stridgen said:
If you go to your admin CP, and go to the support section, check there is nothing showing under the mysql section
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?
-
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) -
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.
-
On 12/21/2022 at 1:24 PM, Randy Calvert said:
It looks like the host is just serving the raw files instead of parsing PHP properly. The host needs to fix your instance to properly parse PHP files.
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.
-
12 hours ago, Marc Stridgen said:
You would need to contact your hosting company regarding this issue. Its likely this is what has been causing you the problems. You are out of resource on your server
Thanks. The host has cleared the resource limit, but now I'm seeing formatting text when I try to access the admin panel:
-
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.
Issue with upgrading
in Technical Problems
Posted · Edited by Adika
Hello, that is the exact output of the query that shows the database's character set.