Find the base image attribute id from eav_attribute.
|
1 |
attr_id = SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = "image" AND `frontend_label` = "Base" LIMIT 1; |
Find all images which having a Base image role.
|
1 |
value = SELECT `value` FROM `catalog_product_entity_varchar` WHERE `attribute_id` = (attr_id); |
Find all ids from the media gallery.
|
1 |
gallery = SELECT `value_id` FROM `catalog_product_entity_media_gallery` WHERE `value` IN (value); |
Update the media gallery value to 0.
|
1 |
UPDATE `catalog_product_entity_media_gallery_value` SET `disabled` = 0 WHERE `value_id` IN (gallery); |
Final query:
|
1 2 3 4 |
UPDATE `catalog_product_entity_media_gallery_value` SET `disabled` = 0 WHERE `value_id` IN ( SELECT `value_id` FROM `catalog_product_entity_media_gallery` WHERE `value` IN ( SELECT `value` FROM `catalog_product_entity_varchar` WHERE `attribute_id` = ( SELECT `attribute_id` FROM `eav_attribute` WHERE `attribute_code` = "image" AND `frontend_label` = "Base" LIMIT 1 ) ) ); |
If you want get query string params in controller file,...
Create di.xml and add the below code Magemonkey/Redirect/etc/frontend/di.xml [crayon-6284607b0c5a8856679082/] Create...
You can try below code to change local date to...
Step 1: First you need to add registration.php file in...
Step1 : Override message.js in current theme file on the...
