"ps_product_shop" missing

[Manisch]

Hello,

 

I just realized that the table ps_product_shop is missing in my database.

But actually...the shop is running mostly fine...?

 

Well, can anyone tell me how to restore that table?

[musicmaster]

Are you sure you don't just use another prefix? Or that you are seeing cached images? When I delete this table I don't get any products.

[Manisch]

Yes, it sounds odd, but I'm pretty sure. 

 

The only table I found is ps_product (without _shop). 

 

The shop works fine, the only thing I noticed is that I can't check "available for order" for a product in the backoffice. Don't know if it's because of this.

This mainly means: When a product is imported (CSV) it actually IS available for order. As soon as I change something about it and click on "save", it can't be ordered anymore and I can't activate this feature manually.

[bellini13]

and what is your version of Prestashop?  Did you do an upgrade recently or in the past.  All tables with _shop extension were added when MultiStore feature was added.  Depending on your version of Prestashop, you are going to want/need this table.

[Manisch]

The version is 1.6.1.4 - and it's been a while since the last update. 

 

So in the end, is this Table essential or not?

[Manisch]

*push*