Magento can not REALLY save attribute

Posted on 2012-08-25
Last Modified: 2012-09-01
Hi experts,

Since couple of days ago I have a problem with saving attribute color in Magento.
It says saved but it does not really save.
Tried to insert a value for the color in English uk and French en push the save button. I can  see the message "the attribute color has been changed". But when I click on "Manage Label/Options" again to see if the value I just inserted really saved. I see that it is again empty.
There are many iteams (1000 itemas ) on Attribute color so something has difficulty to save them on the server. But I do not know where should I start to fix. Is it a problem with mangento, javascript,mysql or something els on the Ubuntu server?

My provider changed his name sever ip couple of days ago. I inserted the new name severs in /etc/resolv.conf file. Everything goes ok. Except Saving color attribute. Does changing name server has anything to do with this issue? I already reboot the server. But it did not help.

I hope somebody has some solution for this issue.

Thank you,
Question by:g1arash
    LVL 58

    Accepted Solution

    The multiple store may be what is bottlenecking the update with that many colours that it is trying to update.
    That many colours is very high - have you thought about breaking them down into more constituent parts i.e. instead of 100 colours in varying shades of blue just have 1 colour blue and a seperate attribute for the varieties of blue.

    Author Comment

    Thank you GaryC123 for you reply.
    Problem is that we are using locally  Naision to import export our products so it is getting to complicated to reconfigure all these system to achieve our goal.

    Is it not possible to copy all color attribute in English store which is complete to Engish UK en French store through phpmyadmin? so yes, Which table do i need to touch?

    Or is it not possible to modify php code of porduct view page to show ALWAYS the color attribute from English store for English UK or French?
    LVL 58

    Expert Comment

    It's not as simple as just copying a table in Magento - many tables are connected even for just simple things.
    I recommend you contact the Navision and ask them since it is their plugin that is failing

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
    Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now