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:

 

 

 

Please contact your hosting provider for assistance with that error. It is an error with your MySQL storage.

 

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:

Did you complete the upgrade at /admin/upgrade ?

 

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, 20232 yr by Askancy

I would suggest running recovery mode then.

 

I would suggest running recovery mode then.

I just edited the previous message, I tried that as well.... IP.Board has any internal logs?

Available logs can be found in /uploads/logs on your filesystem.

<?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, 20232 yr by Askancy

Glad you resolved the issue on your MySQL storage🙂