ERROR: Tablespace is missing for a table from storage engine innodb
-
Hi Everyone,
I am a newbie to Qlo apps with little DB experience.
I am setting up the application on localhost(xampp) just to see how it works but I discovered some modules/functions return the error as shown in the image below.
This is probably a DB related issue....Can anyone share an insight of how to fix this please?
regards
-
@donBishops said in ERROR: Tablespace is missing for a table from storage engine innodb:
Hi Everyone,
I am a newbie to Qlo apps with little DB experience.
I am setting up the application on localhost(xampp) just to see how it works but I discovered some modules/functions return the error as shown in the image below.
This is probably a DB related issue....Can anyone share an insight of how to fix this please?
regards
E.g. If I load the country page to see list of countries same error is there as shown below
-
Hi @donBishops,
You are encountering an issue with your MySQL storage.
This problem arises due to the tablespace file not existing Or lacking permissions Or being deleted or becoming corrupted.
The tablespace file (.ibd) is crucial for InnoDB tables as it contains the actual table data.
We recommend you check if the file exists on your database system.
Additionally, you can refer to the following resource for more information:
-
@Aman-deep-sharma Thanks for your response @Aman-deep-sharma . Will check this and revert. I really do appreciate.
-
@Aman-deep-sharma Dear aman, thanks for your advice. I tried these steps in the article but did not work for me(probably I did not do some things right).
However, I decided to now use the "Repair Table" function in the phpmyadmin and that fixed the issue.
Thanks I really do appreciate.