I have recently imported 200 products, the import went well and the images do show up on the back-end correctly, however there is no cached version available. If I look at the category page and image that supposed to show up is expected to be in the following location:
When I do a search there are multiple images with the same name showing up in the cache directory but elsewhere:
find . -name avant-d15-vision-of-love.jpg ./cache/1677d012f6d3f9a624d33d91ea04b887/a/v/avant-d15-vision-of-love.jpg ./cache/8345bde2c7027c4e6418fcda55997597/a/v/avant-d15-vision-of-love.jpg ./cache/5db09c8cfd726a46996de64dc6365508/a/v/avant-d15-vision-of-love.jpg ./cache/b1799097c85e4d88dfbcc551a1d969fc/a/v/avant-d15-vision-of-love.jpg ./cache/cd831224a3bfc78b7eea938937e3e8e6/a/v/avant-d15-vision-of-love.jpg ./cache/76cf6d416a4967076c5ca34aaeae4b62/a/v/avant-d15-vision-of-love.jpg
My question is where are these image link stored in the database? Could it be that the images have been generated in the wrong directory?
Also please don't tell me to do a magento catalog:images:resize as I have 15K products and it runs for 3 days. I can't simply do this everytime I upload new products.