Askancy Posted March 27 Share Posted March 27 I was updating my forum and fell into limbo. When I upgrade now I get this "Unfinished Upgrade" error. As I click on continue update, there is the error: Â Â Â Link to comment Share on other sites More sharing options...
Jim M Posted March 27 Share Posted March 27 Please contact your hosting provider for assistance with that error. It is an error with your MySQL storage. Link to comment Share on other sites More sharing options...
Askancy Posted March 27 Author Share Posted March 27 5 minutes ago, Jim M said: Please contact your hosting provider for assistance with that error. It is an error with your MySQL storage. Resolved with: ALTER TABLE core_log DISCARD TABLESPACE; Now, however, when I go into AdminCP: Link to comment Share on other sites More sharing options...
Jim M Posted March 27 Share Posted March 27 Did you complete the upgrade at /admin/upgrade ? Link to comment Share on other sites More sharing options...
Askancy Posted March 27 Author Share Posted March 27 (edited) 3 minutes ago, Jim M said: Did you complete the upgrade at /admin/upgrade ? Yes The public forum is working properly, only the admin doesn't work Also tried recovery mode... Edited March 27 by Askancy Link to comment Share on other sites More sharing options...
Jim M Posted March 27 Share Posted March 27 I would suggest running recovery mode then. Link to comment Share on other sites More sharing options...
Askancy Posted March 27 Author Share Posted March 27 Just now, Jim M said: I would suggest running recovery mode then. I just edited the previous message, I tried that as well.... IP.Board has any internal logs? Link to comment Share on other sites More sharing options...
Jim M Posted March 27 Share Posted March 27 Available logs can be found in /uploads/logs on your filesystem. Link to comment Share on other sites More sharing options...
Askancy Posted March 27 Author Share Posted March 27 (edited) <?php exit; ?> Mon, 27 Mar 2023 18:00:34 +0000 SELECT COUNT(*) FROM `core_log` WHERE `category`='datastore' AND `time`>1679936434 IPS\Db\Exception: Tablespace has been discarded for table `core_log` (1814) #0 /var/www/vhosts/****.it/httpdocs/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 /var/www/vhosts/****.it/httpdocs/system/Db/Select.php(370): IPS\Db\_Select->rewind() #2 /var/www/vhosts/****.it/httpdocs/applications/core/extensions/core/AdminNotifications/ConfigurationError.php(136): IPS\Db\_Select->first() #3 /var/www/vhosts/****.it/httpdocs/applications/core/modules/admin/system/login.php(202): IPS\core\extensions\core\AdminNotifications\_ConfigurationError::runChecksAndSendNotifications() #4 /var/www/vhosts/****.it/httpdocs/applications/core/modules/admin/system/login.php(113): IPS\core\modules\admin\system\_login->_doLogin() #5 /var/www/vhosts/****.it/httpdocs/system/Dispatcher/Controller.php(118): IPS\core\modules\admin\system\_login->manage() #6 /var/www/vhosts/****.it/httpdocs/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /var/www/vhosts/****.it/httpdocs/admin/index.php(13): IPS\_Dispatcher->run() #8 {main} #0 /var/www/vhosts/****.it/httpdocs/init.php(1037): IPS\_Log::log() #1 [internal function]: IPS\IPS::exceptionHandler() #2 {main}  This is the only error log I have inside. If I look at the core_log table, it is empty....   I solved by deleting the core_log table and recreating it:  CREATE TABLE `core_log` ( `id` bigint(20) UNSIGNED NOT NULL COMMENT 'ID Number', `exception_class` varchar(255) DEFAULT NULL COMMENT 'If the log was an exception, the class name', `exception_code` int(3) UNSIGNED DEFAULT NULL COMMENT 'If the log was an exception, the code', `message` mediumtext NOT NULL COMMENT 'The log message', `backtrace` text DEFAULT NULL COMMENT 'The backtrace', `time` int(10) NOT NULL DEFAULT 0 COMMENT 'Unix timestamp of log', `category` varchar(128) DEFAULT NULL COMMENT 'Optional string identifying the type of log', `url` text DEFAULT NULL COMMENT 'URL the error occurred on, if any', `member_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Member that triggered the error, if any', `loaded_hooks` text DEFAULT NULL COMMENT 'Any third party hooks loaded' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ALTER TABLE `core_log` ADD PRIMARY KEY (`id`), ADD KEY `time` (`time`), ADD KEY `category` (`category`); ALTER TABLE `core_log` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Number', AUTO_INCREMENT=103644; COMMIT; Edited March 27 by Askancy Link to comment Share on other sites More sharing options...
Jim M Posted March 27 Share Posted March 27 Glad you resolved the issue on your MySQL storage🙂 Link to comment Share on other sites More sharing options...
Recommended Posts