Jump to content

MissNyx

Clients
  • Posts

    10
  • Joined

  • Last visited

Recent Profile Visitors

1,104 profile views

MissNyx's Achievements

  1. Hi Jim -- I tinkered around and figured it out - Not even 100% sure what worked but we did get upgraded today to the latest release
  2. Turns out the calendar was causing the issue since we upgraded PHP -- I disabled the calendar and now our forum is back -- However, when we attempt to upgrade we get stuck at the following: 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 `core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL; ALTER TABLE `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`); I have attempted both the Fix Automatically and Trying to run the Query in PhoMyAdmin with no luck of advancing past this stage -- I just get what i put below -- I am not great with this stuff so any help would be great! 0 rows affected. (Query took 0.0006 seconds.) UPDATE `core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL [Edit inline] [ Edit ] [ Create PHP code ] MySQL returned an empty result set (i.e. zero rows). (Query took 0.0067 seconds.) ALTER TABLE `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`)
  3. And now since trying to resolve the database issues we now have a 500 error on the forum
  4. We are on a severally outdated version of 4.5 and when i go to upgrade i get This Database message UPDATE `core_output_cache` SET `cache_expire`=0 WHERE `cache_expire` IS NULL; ALTER TABLE `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`); I tried fixing automatically and manually running the queries in PHP my admin and nothing lets me get past this point
×
×
  • Create New...