Error 194 in upgrade - Tablespace is missing for a table

[Askancy]

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:

 

 

 

[Jim M]

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

[Askancy]

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:

[Jim M]

Did you complete the upgrade at /admin/upgrade ?

[Askancy]

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, 2023 by Askancy

[Jim M]

I would suggest running recovery mode then.

[Askancy]

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?

[Jim M]

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

[Askancy]

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

[Jim M]

Glad you resolved the issue on your MySQL storage🙂