algisna Posted September 12, 2016 Share Posted September 12, 2016 (edited) Some of my product strated showing wrong images in front page..If I log to back office these products still have right pictures. I thought my DB is corrupted, I checked image tables "_image", "_image_shop", "_product_attribute_image" - they are all taging right pictures.. But front shop is still showing wrong picture from completely different product (same picture for all products affected by this issue). Deleted cache, disabled non prestashop modules, regenerated images - nothing helps Any ideas? Edited September 12, 2016 by algisna (see edit history) Link to comment Share on other sites More sharing options...
tuk66 Posted September 12, 2016 Share Posted September 12, 2016 What URL and what images are wrong? Link to comment Share on other sites More sharing options...
algisna Posted September 12, 2016 Author Share Posted September 12, 2016 (edited) Here is an example:http://www.rcshop.lt/rcshoplt/off-road-110/1088369-vrx-racing-spirit-ebd-1-10-buggy-24ghz-rtr.html Product ID 1088369. ps_image table gives following images: 10442 and 104441 In Backoffice they are displayed correctly, but front page generates link with picture 1637. This happened to at least 10-20 products, always showing picture 1367 Edited September 12, 2016 by algisna (see edit history) Link to comment Share on other sites More sharing options...
modprestashop Posted September 12, 2016 Share Posted September 12, 2016 By any chance does your shop is multi-shop and you forgot to set up image for this shop only? Link to comment Share on other sites More sharing options...
algisna Posted September 12, 2016 Author Share Posted September 12, 2016 No, multishop is disabled. Link to comment Share on other sites More sharing options...
modprestashop Posted September 12, 2016 Share Posted September 12, 2016 In this case the only way to solve your problem is debug whole product page and check from where that 1367 numbered image come. Because PrestaShop installation is same for all and it must take images which are in _images table. Link to comment Share on other sites More sharing options...
HerbalHispano Posted September 12, 2016 Share Posted September 12, 2016 Gracias Link to comment Share on other sites More sharing options...
algisna Posted September 13, 2016 Author Share Posted September 13, 2016 I don't have enough knowlege to debug the page.. Can someone help me finding out whre does this picture comming from? It looks like problem is only happening to products with color attribute. Link to comment Share on other sites More sharing options...
tuk66 Posted September 13, 2016 Share Posted September 13, 2016 I see thumbnail blocks with id thumbnail_104441 and thumbnail_104442, but the image is always 64338. Strange. It is something wrong in the theme (or modules). Link to comment Share on other sites More sharing options...
algisna Posted September 13, 2016 Author Share Posted September 13, 2016 Thanks for everyone, I managed to solve the issue myself.. Some of 'PS_IMAGE' table rows had emtpy strings in 'URL' column instead of NULL values.. Replaced all empty string with NULL and .... everything is fine again Also cleared cache. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now