Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Table "products" disappeared and can't be restored


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




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


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

  • Create New...