Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Table "products" disappeared and can't be restored


neurotoxic

Recommended Posts

I am building a website for a friend and I unfortunately let him look at PHPMyAdmin installed on his website to see if no product's weight was still at "zero".

 

Somehow, he managed to delete completely the table "products" while trying to change some weights from PHPMyAdmin in that table. At least, I thought the table was deleted. So I wrote to the hosting company and asked them to restore a backup that was older than the day the problem occured. To no avail.

 

They restored an old backup, but I still can't see the table "products" and I am getting the same error message (See it here):

 

1146 - Table 'commerce_meneldur_com.products' doesn't exist

 

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

 

[TEP STOP]

 

That can be seen on the main page.

 

So I am deeply confused. I can't understand what might've happened. Does anyone have some idea as to what went wrong?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...