Hi guys, im trying to update my database to use all lowercase characters for any value name path for images.
If i happen to run this via a simple SQL code, when i go back into magento admin and edit a product, ALL of the image options (Base/Small/Thumb) are NOT selected....any ideas, why changing the case of the image path would do this? And how can i get around it?
Have you also update the media attributes "image", "small_image", "thumbnail" in the table "catalog_product_entity_varchar" ?
The base image, small image, thumbnail image information is stored in this table.
Ive not, but ive just looked into that table, and cant find a reference of base image/small image/thumbnail.....
Look for the attribute codes image, small_image, thumbnail in the table eav_attribute. Get the attribute_id values.
In my Magento installation,
image has attribute_id 85
small_image has attribute_id 86
thumbnail has attribute_id 87
In catalog_product_entity_varchar table, the image values have the attribute ids found in eav_attribute.