i have a multiselect product attribute, that when ever i change its settings and save, i get
but the settings don't get changed. Here's the attribute's database values:
I'm on magento 2.2.4, any idea how to fix this?
-
any errors showing while saving ?– Rahul SinghJul 19, 2018 at 5:18
-
no errors in console nor in logs– Mariam GhallebJul 19, 2018 at 19:19
-
1I have (probably) the same problem - the value is saved in the database, but no options are selected in the product edit from in the Magento backend. Magento 2.2.5.– Andreas von StudnitzAug 8, 2018 at 10:09
Add a comment
|
2 Answers
I have faced the same issue and fixed it using database. After a long R&D, I found that the same attribute values exist in both catalog_product_entity_varchar and catalog_product_entity_text tables.
You can check the all multiselect attributes from below query:
SELECT e.`attribute_id`,`attribute_code`,`frontend_input`,`backend_type`,`backend_model` FROM eav_attribute e LEFT JOIN `catalog_eav_attribute` ce ON e.attribute_id = ce.attribute_id WHERE e.entity_type_id = 4 AND ce.is_visible = 1 AND e.frontend_input='multiselect'
For example, attribute id is 182, so delete all entries from catalog_product_entity_text table where attribute_id is 182.
Login In your phpmyadmin Select your website db Open following table "eav_attribute" Find attribute id "attribute_id" Edit Row If "backend_model" Column blank then paste this "Magento\Eav\Model\Entity\Attribute\Backend\ArrayBackend"
