Base table not found after reindex

[alexander_jorda]

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?

[Manish Mittal]

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.

[theMageComp]

Hello @alexander_jorda 

Did you check this thread?

https://community.magento.com/t5/Magento-1-x-Technical-Issues/SQLSTATE-42S02-Base-table-or-view-not-...

https://magento.stackexchange.com/questions/151779/sqlstate42s02-base-table-or-view-not-found-1146-t...

[alexander_jorda]

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 ?

[alexander_jorda]

Hi Manish,

How can I do this?

[alexander_jorda]

Someone who knows how to solve this?