cancel
Showing results for 
Search instead for 
Did you mean: 

Site down (Base table or view not found)

SOLVED

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