cancel
Showing results for 
Search instead for 
Did you mean: 

Base table not found after reindex

Base table not found after reindex

After I have did a reindex via SSH, I get the following error:

 

Product Feed indexer process unknown error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'MYUSERNAME.catalog_product_entity' doesn't exist, query was: SELECT `p`.`entity_id` AS `productId` FROM `catalog_product_entity` AS `p` WHERE (entity_id > 0) ORDER BY `entity_id` ASC

 LIMIT 1000

 

The strange thing is that I can find catalog_product_entity in my database. How can I solve this issue?

5 REPLIES 5

Re: Base table not found after reindex

Hello @alexander_jorda 

 

Please try to run below queries:

php bin/magento indexer:reset
php bin/magento indexer:reindex

or first check site able to access database or not cause I can see in error "MYUSERNAME.catalog_product_entity" trying to access table with this prefix "MYUSERNAME". It might be the issue. Please check.

Manish Mittal
https://www.manishmittal.com/

Re: Base table not found after reindex

Re: Base table not found after reindex

I think that i already know what the problem is, but I do not know how to solve it.

I have in my database a prefix of ’mg_’. So the table should look to mg_catalog_product_entity instead of catalog_product_entity

Anyone an idea that the table will look to mg_catalog_product_entity ?

Re: Base table not found after reindex

Hi Manish,

 

How can I do this?

Re: Base table not found after reindex

Someone who knows how to solve this?