product images problem on prestashop 1.7

[jaymos]

Hi, I've been reading forums for weeks on the internet and there's no way:

In my version 1.7 I have a serious problem with the images of products. They were added to my store through a dropshipping application that takes them from AliExpress. At first they appeared in the back office in the catalog of products but suddenly they stopped being seen everywhere, you only see the thumbnails of the products in the catalog but when clicking on the tab they don't appear. I have tried everything, regenerate thumbnails, review and correct the permissions in cpanel, connect and disconnect the friendly url's, upload the images manually and neither. Maybe the problem is in the url's of the images but I don't know very well how I should modify them so that they are displayed correctly again. Who knows how to solve this, please, I will appreciate it very much.

[Vince]

First you need to share your site and your back office information for checking. it is not easy to find out the reason without the full information. If you want please pm.

[amccurdy]

This issue hounded me for days after I upgraded a client's site from 1.6.16 to 1.7...what ever it was, and product images didn't show on the site or in the product lists in the back office.

The migration tool I used had a small bug which caused a failure of the migration from the old ps_image_shop table to the new one.

I had to migrate this table's contents manually, and the images still didn't show.

It was then I noticed the old ps_image_shop table has it's columns in this order:

id_image
id_shop
cover
id_product

The new ps_image_shop table has the id_product column first, ie:

id_product
id_image
id_shop
cover

I reimported the data in this correct order, and BAMM, the product images appeared instantly!