Dirty Bill Posted November 20, 2008 Share Posted November 20, 2008 Since the image upload doesn't work properly, I'm setting up the images manually. The challenge I'm currently having is understanding the naming convention for products. Product 1 master image appears to be 1-1.jpg, Product 2 master image appears to be 2-5.jpg; seems that Product 3 is going to be 3-9.jpg, but that doesn't work. Have tried images numbered 3-1 to 3-11 and tried to regen thumbnails, no 3 series images are created.Any assistance would be appreciated. Link to comment Share on other sites More sharing options...
Mogul Posted June 30, 2011 Share Posted June 30, 2011 After an unsuccessful upgrade or something, I'm wrestling with the same problem.After "the change" (don't know if it was an update or a theme programming screw up, my images no longer display on product pages. I have had to go in and manually rewrite the image links...I've got as far as this...the image for any given product is /img/p/number-anothernumber-large.jpgnumber=product id which you can code like this {$product->id|escape}i'm still confused as to what the second number is a property of. The most frustrating thing about prestashop is that there doesn't seem to be a published list of all the database variables.If anybody could add to this, I think me and Dirty Bill would both appreciate it... Link to comment Share on other sites More sharing options...
emokemi Posted November 29, 2011 Share Posted November 29, 2011 Hi, If you guys haven't figured this out yet, "anothernumber" happens to be the id column from the table "ps_image". You will need to do a join including the following tables, ps_product, ps_image to get that image id, "anothernumber" for a specific product. Long-winded, but its either that or several queries to retrieve it. HTH Link to comment Share on other sites More sharing options...
Recommended Posts