2

I have a specific attribute in a specific attribute set that is not saving correctly. Looking in the database tables catalog_product_entity_int and eav_entity_attribute, everything appears normal: catalog_product_entity_int holds the correct value of the problematic attribute.

However after saving the product, even though the value is changed correctly in the database, the value on the backend and frontend remain blank. No errors are logged or displayed.

This attribute saves correctly, but does not show the saved value

It appears to be only this specific attribute in this specific attribute set. I have added the suspect attribute to a different attribute set and it saved properly. I am also able to properly save other attributes in the problematic attribute set.

I'm hoping that maybe theres a table that is somehow missing a row that I can just fill in and get things back to normal.

Can anyone point me in the right direction?

EDIT: Here is a quick overview of the table rows that show all the correct values in the correct places...

eav_attribute

| attribute_id | attribute_code  | backend_type | frontend_input | frontend_label  |
------------------------------------------------------------------------------------
| 175          | connection_type | int          | select         | Connection Type |

eav_attribute_set

| attribute__set_id | attribute_set_name       |
------------------------------------------------
| 68                | Fiber Optic Patch Cables |

eav_attribute_group

| attribute_group_id | attribute_set_id | attribute_group_name       |
----------------------------------------------------------------------
| 1381                | 68              | Singlemode Simplex Jumpers |

eav_entity_attribute

| entity_type_id | attribute_set_id | attribute_group_id | attribute_id |
-------------------------------------------------------------------------
| 4              | 68               | 1381               | 175          |

and a sample product from catalog_product_entity_int

| entity_type_id | attribute_id | store_id | entity_id | value |
----------------------------------------------------------------
| 4              | 175          | 0        | 3723      | 958   |

and for reference, the associated value from eav_attribute_option_value

| value_id | option_id | store_id | value |
-------------------------------------------
| 5371     | 958       | 0        | SC/ST |
| 5372     | 958       | 1        | SC/ST |

EDIT 2: Updating as I find potentially useful information, since this attribute is related to a project I'm working on. This attribute works as expected in advanced search, and also in layered navigation.

EDIT 3: I created the bounty on Friday when I left the office; and now I am back in the office on Monday and the issue appears to have resolved itself. All products are correctly displaying their assigned values, and the attribute saves correctly. There are no cron jobs running on the server, and I had refreshed the index and cache many times while trying to troubleshoot the issue. I'll award the bounty to anyone who can give a reasonable explanation to this sorcery.

closed as off-topic by David Manners, Marius, Vladimir Kerkhoff, Moose, Keyul Shah Nov 18 '14 at 11:31

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions describing a problem that can't be reproduced OR seemingly went away on its own (or went away when a typo was fixed) are off-topic as they are unlikely to help future readers." – David Manners, Marius, Vladimir Kerkhoff, Moose, Keyul Shah
If this question can be reworded to fit the rules in the help center, please edit the question.

  • I agree with you that a table (somewhere) is not being updated. Have you tried to delete the attribute and re-create it? Also, what value are you trying to assign - boolean? – Jongosi Aug 6 '14 at 21:15
  • I don't want to delete the attribute, because then I would have to re-import all of the products that use that attribute. Its a standard dropdown with a number of values (not a boolean). – andyjv Aug 7 '14 at 12:30
  • 1
    What is the HTML output of your dropdown in the backend? Maybe the value of the dropdown-option is correct and the value is not loaded? – Anna Völkl Aug 10 '14 at 12:41
  • 1
    it might have also been index related (product flat table) – Julien Lachal Aug 11 '14 at 14:33
  • 1
    @someGuyOnTheWeb Magento's Cache. Server has APC. All other attributes and products appeared to be updating correctly, so I suspect it had to do with an error in Magento's indexing – andyjv Aug 12 '14 at 12:31
1

Are there more than one installations(test, dev, etc...) of the Magento in same server for staging? If you configure APC cache in the app/etc/local.xml with same prefix for all of them, probably they share cache and this could be cause of the problem above until APC cache purged:
local.xml of A installation

<global> 
    ....
    <cache>
        <backend>apc</backend>
        <prefix>SAME_PREFIX</prefix>
    </cache>
</global> 


local.xml of B installation

<global> 
    ....
    <cache>
        <backend>apc</backend>
        <prefix>SAME_PREFIX</prefix>
    </cache>
</global> 
  • Only one installation on this server – andyjv Aug 15 '14 at 18:05

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