SQLSTATE[HY000]: General error: 1478 when trying to reindex or saving new products
Greetings.
I am having General error: 1478 when trying to reindex magento 2. I am using mysql and when running the ssh command, this comes out:
Design Config Grid index has been rebuilt successfully in 00:00:00 Customer Grid index has been rebuilt successfully in 00:00:00 Category Products index has been rebuilt successfully in 00:00:00 Product Categories index has been rebuilt successfully in 00:00:00 Catalog Rule Product index has been rebuilt successfully in 00:00:00 SQLSTATE[HY000]: General error: 1478 InnoDB: Tablespace `kabulo1_ei19` cannot contain TEMPORARY tables., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_eav_temp` LIKE `catalog_product_index_eav_tmp` Stock index has been rebuilt successfully in 00:00:00 Inventory index has been rebuilt successfully in 00:00:00 Catalog Product Rule index has been rebuilt successfully in 00:00:00 SQLSTATE[HY000]: General error: 1478 InnoDB: Tablespace `kabulo1_ei19` cannot contain TEMPORARY tables., query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` Google Product Removal Feed index has been rebuilt successfully in 00:00:00 Google Product Feed index has been rebuilt successfully in 00:00:00 Catalog Search index has been rebuilt successfully in 00:00:00
Please assist.
I am having an issue with those temporary tables