v1.1.6, M2.4.2: Error SQLSTATE[42S02]: Base table or view not found

Created by Esther Nguyen, Modified on Fri, 28 Jan 2022 at 02:52 PM by Esther Nguyen

ISSUE:

After installing, we get the following error: the module does not work.

3 exception(s):

Exception #0 (Magento\Framework\DB\Adapter\TableNotFoundException): SQLSTATE[42S02]: Base table or view not found: 1146 Table '....inventory_stock' doesn't exist, query was: SELECT `main_table`.* FROM `inventory_stock` AS `main_table`

Exception #1 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table '....inventory_stock' doesn't exist, query was: SELECT `main_table`.* FROM `inventory_stock` AS `main_table`

Exception #2 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table '....inventory_stock' doesn't exist


SOLUTION:

Our latest version 1.1.6 has not covered the case the MSI is disabled on your site, which makes the table inventory_stock disappear in the database.


To temporarily resolve the issue, please download the file attached below to override the current file on your site.


If you need any further assistance, please feel free to contact us. We'd be happy to support you!

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article