Below error appears on api call ,

[2020-06-18 07:57:42] main.CRITICAL: Report ID: webapi-5eeb1e76e4607; Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.catalog_category_product_index_store0' doesn't exist, query was: SELECT `main_table`.* FROM `wishlist_item` AS `main_table`

Any idea how to solve it ?


Try to disable magento Catalog Flat for Category from Admin>Store>Catalog>Catalog>Use Flat Catalog Category make it NO.

enter image description here

| improve this answer | |
  • Thankyou for your response , let me check , – devmage Jun 18 at 8:43
  • its already set to no – devmage Jun 18 at 9:17

The database catalog_category_product_index_store0 table does not create that why you getting error. This table is created when indexing for Category Product will run properly . Might be in your system Indexing Category Product is not working. So, you have to do indexing again .

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.