[email protected] wrote:
7. I'm guessing this is down to something daft like spurious spaces in the SeoFilename so tomorrow I'll do some random cross checking and see what I can find.
Everything looks correct, but it's worth checking the above. I had a vendor with '/' in their descriptions which made for all sorts of fun with subdirectories being created.
Do you have direct access to your db? I'm curious what you have in Picture for an example product without image
FROM Picture pic
INNER JOIN Product_Picture_Mapping map
ON pic.Id = map.PictureId
WHERE map.ProductId = xxxxx --eg 123