cancel
Showing results for 
Search instead for 
Did you mean: 

Site down (Base table or view not found)

SOLVED
   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Site down (Base table or view not found)

Hi

Im having a bit of an emergency. My site unexpectedly went down, with the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test1.catalog_product_index_price' doesn't exist

You can see what im talking about here.

http://www.dtacollectibles.com/new-arrival

 

Please help as I am currently losing sales. 

Thanks!

-Tyler

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Site down (Base table or view not found)

Hi @dtacoll,

I am sorry you are experiencing that critical issue on your website.

 

As you can see in the error message, that table is missing in your database.

Do you have a recent database backup to restore?

Regards.
Gabriel

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

View solution in original post

3 REPLIES 3

Re: Site down (Base table or view not found)

Hi @dtacoll,

I am sorry you are experiencing that critical issue on your website.

 

As you can see in the error message, that table is missing in your database.

Do you have a recent database backup to restore?

Regards.
Gabriel

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

Re: Site down (Base table or view not found)

Hi,

 

 

I was able to fix the issue by restoring the table, and restarting MySQL.

 

Thanks!

Re: Site down (Base table or view not found)

Hello @dtacoll  Can you please explain how did you restore ted that table? I am getting following error 

"base table or view not found: 1932 table '.catalog_product_index_price replica'

P.S:Using magento 2.3.3