Magento can’t add new attribute options

– Magento version: 1.7.0.2 CE
– Mangento freezes while adding new attrubite values
– Magento stays on please wait
– Timeout saving attribute options
– Magento to much attributes
– magento attribute options limit

While I was working with magento I got stuck on a strange problem, Magento freezes everytime I try to add more then one attribute value at once. To use the layered navigation in magento for filtering the 350 types of brands I was creating dropdown attribute options. After 240 options magento wouldn’t save any new values and freezes on Please Wait…

Few solutions I found while searching on Google:
– Disable Loggin
– Disable caching and remove the folder var
-Edit: app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php
and change: ‘type’ => ‘varchar(255)’,
into
‘type’ => ‘varchar(255)’, => ‘type’ => ‘varchar(100)’,

This solutions didn’t work for me, but the following part did the trick.
1. Open php.ini
2. Alter or Add the following lines:

Restart apache and the problem is solved
magento_attribute_freeze

Comments: 4

  1. Brando Bandido July 23, 2013 at 14:19 Reply

    You nailed it bro! Thank you so much for sharing this fix. I’ve been looking for this for hours already. Thank God I found your website.

    Magento, I still love ya!

    Cheers from PH!

  2. Sarita Sharma May 2, 2014 at 09:14 Reply

    Thanks Buddy!

    You saved a lot of my time and it is working like charm!!! 🙂
    Kudos to you!

    Thank you!

  3. Mark January 14, 2015 at 09:41 Reply

    You are a genius, that has been bugging me for ages, maxing out at 250 attributes is so limiting.

    The magento admin area seems to be loading a lot quicker since this change also, Thanks

  4. Dhananjay March 30, 2016 at 12:12 Reply

    Hi

    I have applied all the above but i am still unable to update one of my product attribute.

    I have also updated magento to latest version and repaired database, still not working,

    Any help would be appreciated.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

-->