Forum GLPI-Project

aldojr404

Member

Registered: 2018-10-01

Posts: 8

SQL Error "1030": Got error 194 "Tablespace is missing for a table"

GLPI SETUP

Hi I need some  help please when upgrading from 9.5.5 to 10 on CENTOS 7 I got the following error, 9.5.5 is working fine, here is the error I got on the setup page. this particular table doesn't have an idb file I noticed. Thanks for your assistance!

Upgrade
Database connection successful

Database version seems correct (11.0.2) - Perfect!Database version seems correct (11.0.2) - Perfect!
Update to 9.5.6

Task Completed. (0 seconds)
Update to 9.5.7

Task Completed. (0 seconds)
Update to 10.0.0

Change of the database layout - glpi_profiles_rssfeeds (2 seconds)

GLPI cache has been changed and will not use anymore APCu or Wincache extensions. Use "php bin/console cache:configure" command to configure cache system.
SQL Error "1030": Got error 194 "Tablespace is missing for a table" from storage engine InnoDB in query "SHOW COLUMNS FROM `glpi_notimportedemails`"
SQL Error "1030": Got error 194 "Tablespace is missing for a table" from storage engine InnoDB in query "SHOW COLUMNS FROM `glpi_notimportedemails`"
SQL Error "1030": Got error 194 "Tablespace is missing for a table" from storage engine InnoDB in query "ALTER TABLE `glpi_notimportedemails` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci"
- Error during the database query: ALTER TABLE `glpi_notimportedemails` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci - Error is Got error 194 "Tablespace is missing for a table" from storage engine InnoDB

Last edited by aldojr404 (2023-07-18 22:36:23)

Kaya84

Member

Registered: 2019-06-13

Posts: 217

Re: SQL Error "1030": Got error 194 "Tablespace is missing for a table"

try with
php bin/console glpi:migration:myisam_to_innodb
and
php bin/console glpi:database:check_schema_integrity
and maybe
php bin/console db:update

then post results

aldojr404

Member

Registered: 2018-10-01

Posts: 8

Re: SQL Error "1030": Got error 194 "Tablespace is missing for a table"

Thank you so much for your reply.

I was able to resolve by creating an empty table called glpi_notimported emails and the upgrade completed. Hope this helps someone.

I also ran:
php bin/console migration:myisam_to_innodb
(completed)

php bin/console migration:utf8mb4
(completed)

php bin/console migration:unsigned_keys (this one didn't complete properly and got this error below)

Migration of column "glpi_bookmarks.entities_id" cannot be done as its default value is negative.
1027/1531 [===============>-------]  67%
1531/1531 [=======================] 100%

Errors occurred during migration.

Thanks again.

Kaya84

Member

Registered: 2019-06-13

Posts: 217

Re: SQL Error "1030": Got error 194 "Tablespace is missing for a table"

Thank you so much for your reply.

I was able to resolve by creating an empty table called glpi_notimported emails and the upgrade completed. Hope this helps someone.

Great

I also ran:
php bin/console migration:myisam_to_innodb
(completed)

php bin/console migration:utf8mb4
(completed)

php bin/console migration:unsigned_keys (this one didn't complete properly and got this error below)

Migration of column "glpi_bookmarks.entities_id" cannot be done as its default value is negative.
1027/1531 [===============>-------]  67%
1531/1531 [=======================] 100%

Errors occurred during migration.

Thanks again.

I think it will be better if u fix that problem (check table, maybe it's empty)

aldojr404

Member

Registered: 2018-10-01

Posts: 8

Re: SQL Error "1030": Got error 194 "Tablespace is missing for a table"

I fixed it by deleting that table glpi_bookmarks per this thread:

https://forum.glpi-project.org/viewtopic.php?id=283373

It wasn't needed on Version 10

:-)

Last edited by aldojr404 (2023-07-20 18:09:40)