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

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!

Why choosing BSS Commerce?

BSS Commerce is a full-service ecommerce agency with 14+ years of experience, supporting 75,000+ customers worldwide. As an Adobe Commerce Solution Bronze Partner and Select Magento Extensions Builder, we deliver trusted end-to-end solutions.

Our core strength is Magento, with 150+ extensions designed to enhance store performance and drive growth. With deep expertise from years of working on Magento websites, we deliver scalable, high-impact solutions backed by strong client trust.

Discover our extensions: https://bsscommerce.com/magento-2-extensions.html 

Our top-tier extensions:

• BSS Commerce’s Magento 2 B2B Extension enhances B2B performance with streamlined workflows and tailored pricing strategies.
• BSS Commerce’s Magento 2 SEO Extension improves rankings and maximizes organic growth through advanced SEO automation.