0

i have a multiselect product attribute, that when ever i change its settings and save, i get

enter image description here

but the settings don't get changed. Here's the attribute's database values:

enter image description here

I'm on magento 2.2.4, any idea how to fix this?

3
  • any errors showing while saving ? Jul 19, 2018 at 5:18
  • no errors in console nor in logs Jul 19, 2018 at 19:19
  • 1
    I 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. Aug 8, 2018 at 10:09

2 Answers 2

1

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.

1
  • Yes, I had to do manually change it in DB ... Oct 3, 2018 at 13:33
0

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"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.