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

Tags (1)
2 REPLIES

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

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

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!