Integrity constraint violation: Duplicate entry for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'Error When Adding Attribute: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 1dynamic key => value pair adminhtml setting for custom moduleConfigurable product super attribute Integrity constraint violation errorMagento exception Integrity constraint violation: 1048 Column 'value' cannot be null' in libZendDbStatementPdo.php:234Magento: using duplicate product button, but emptying Url KeyMagento How to add configurable product while placing order programatically?Magento uses <h1> for the logo on EVERY page - Duplicate h1 tags

Can chords be inferred from melody alone?

The size of sheafification

Do any languages mention the top limit of a range first?

What are these circular spots on these Ariane V SRB nozzles?

How many years before enough atoms of your body are replaced to survive the sudden disappearance of the original body’s atoms?

How easy is it to get a gun illegally in the United States?

Where to pee in London?

Are certificates without DNS fundamentally flawed?

How to check a file was encrypted (really & correctly)

Does the spell "Silence" affect the caster?

Did WWII Japanese soldiers engage in cannibalism of their enemies?

What could prevent players from leaving an island?

Why can I log in to my Facebook account with a misspelled email/password?

Print only the last three columns from file

What does VB stand for?

Is it double speak?

Should I self-publish my novella on Amazon or try my luck getting publishers?

Traveling from Germany to other countries by train?

Which genus do I use for neutral expressions in German?

Does this smartphone photo show Mars just below the Sun?

Is it a bad idea to offer variants of a final exam based on the type of allowed calculators?

Is DC heating faster than AC heating?

Does a 4 bladed prop have almost twice the thrust of a 2 bladed prop?

How to approach protecting my code as a research assistant? Should I be worried in the first place?



Integrity constraint violation: Duplicate entry for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'


Error When Adding Attribute: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 1dynamic key => value pair adminhtml setting for custom moduleConfigurable product super attribute Integrity constraint violation errorMagento exception Integrity constraint violation: 1048 Column 'value' cannot be null' in libZendDbStatementPdo.php:234Magento: using duplicate product button, but emptying Url KeyMagento How to add configurable product while placing order programatically?Magento uses <h1> for the logo on EVERY page - Duplicate h1 tags






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I cant save the super attribute because i get error



$pricesByAttributeValues = array();
$baseCode = Mage::app()->getBaseCurrencyCode();
$allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
$rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
$collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
->addAttributeToFilter('type_id', array('eq' => 'configurable'))
->addAttributeToFilter('sku', array('like' => 'Miila-CV'));

foreach ($collectionConfigurable as $_configurableproduct)
$_configurableproduct->getId();
$_configurableproduct->getName();
$moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
//Get precio moneda base
foreach ($rates as $rate=>$value)
if (strcmp ($rate , $moneda_base ) == 0)

$moneda_base = $value;


//Precio y Ofertas
$precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
$descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
$desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
$_configurableproduct->setPrice($precio);
$_configurableproduct->setSpecialPrice($descuento);
$_configurableproduct->setDesde($desde);
//Configurables
$attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
$i = 0;
foreach ($attributes as $attribute)
$prices = $attribute->getPrices();
foreach ($prices as $price)
$pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
$pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
$pricesByAttributeValues[$i]['label'] = $price['label'];
$pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
$pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
$pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
$pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
$pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
$pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
$i++;


try

$_configurableproduct->setCanSaveConfigurableAttributes(true);
$_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
$_configurableproduct->save();
catch (Exception $e)
echo 'Excepción capturada: ', $e->getMessage(), "n";











share|improve this question
































    1















    I cant save the super attribute because i get error



    $pricesByAttributeValues = array();
    $baseCode = Mage::app()->getBaseCurrencyCode();
    $allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
    $rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
    $collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
    ->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
    ->addAttributeToFilter('type_id', array('eq' => 'configurable'))
    ->addAttributeToFilter('sku', array('like' => 'Miila-CV'));

    foreach ($collectionConfigurable as $_configurableproduct)
    $_configurableproduct->getId();
    $_configurableproduct->getName();
    $moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
    //Get precio moneda base
    foreach ($rates as $rate=>$value)
    if (strcmp ($rate , $moneda_base ) == 0)

    $moneda_base = $value;


    //Precio y Ofertas
    $precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
    $descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
    $desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
    $_configurableproduct->setPrice($precio);
    $_configurableproduct->setSpecialPrice($descuento);
    $_configurableproduct->setDesde($desde);
    //Configurables
    $attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
    $i = 0;
    foreach ($attributes as $attribute)
    $prices = $attribute->getPrices();
    foreach ($prices as $price)
    $pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
    $pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
    $pricesByAttributeValues[$i]['label'] = $price['label'];
    $pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
    $pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
    $pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
    $pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
    $pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
    $pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
    $i++;


    try

    $_configurableproduct->setCanSaveConfigurableAttributes(true);
    $_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
    $_configurableproduct->save();
    catch (Exception $e)
    echo 'Excepción capturada: ', $e->getMessage(), "n";











    share|improve this question




























      1












      1








      1








      I cant save the super attribute because i get error



      $pricesByAttributeValues = array();
      $baseCode = Mage::app()->getBaseCurrencyCode();
      $allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
      $rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
      $collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
      ->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
      ->addAttributeToFilter('type_id', array('eq' => 'configurable'))
      ->addAttributeToFilter('sku', array('like' => 'Miila-CV'));

      foreach ($collectionConfigurable as $_configurableproduct)
      $_configurableproduct->getId();
      $_configurableproduct->getName();
      $moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
      //Get precio moneda base
      foreach ($rates as $rate=>$value)
      if (strcmp ($rate , $moneda_base ) == 0)

      $moneda_base = $value;


      //Precio y Ofertas
      $precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
      $descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
      $desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
      $_configurableproduct->setPrice($precio);
      $_configurableproduct->setSpecialPrice($descuento);
      $_configurableproduct->setDesde($desde);
      //Configurables
      $attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
      $i = 0;
      foreach ($attributes as $attribute)
      $prices = $attribute->getPrices();
      foreach ($prices as $price)
      $pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
      $pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
      $pricesByAttributeValues[$i]['label'] = $price['label'];
      $pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
      $pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
      $pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
      $pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
      $pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
      $pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
      $i++;


      try

      $_configurableproduct->setCanSaveConfigurableAttributes(true);
      $_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
      $_configurableproduct->save();
      catch (Exception $e)
      echo 'Excepción capturada: ', $e->getMessage(), "n";











      share|improve this question
















      I cant save the super attribute because i get error



      $pricesByAttributeValues = array();
      $baseCode = Mage::app()->getBaseCurrencyCode();
      $allowedCurrencies = Mage::getModel('directory/currency')->getConfigAllowCurrencies();
      $rates = Mage::getModel('directory/currency')->getCurrencyRates($baseCode, array_values($allowedCurrencies));
      $collectionConfigurable = Mage::getResourceModel('catalog/product_collection')
      ->addAttributeToSelect(array('name', 'id', 'price','special_price','desde','moneda_base'))
      ->addAttributeToFilter('type_id', array('eq' => 'configurable'))
      ->addAttributeToFilter('sku', array('like' => 'Miila-CV'));

      foreach ($collectionConfigurable as $_configurableproduct)
      $_configurableproduct->getId();
      $_configurableproduct->getName();
      $moneda_base = Mage::getModel('catalog/product')->load($_configurableproduct->getId())->getAttributeText('moneda_base');
      //Get precio moneda base
      foreach ($rates as $rate=>$value)
      if (strcmp ($rate , $moneda_base ) == 0)

      $moneda_base = $value;


      //Precio y Ofertas
      $precio = number_format($_configurableproduct->getPrice() / $moneda_base , 2);
      $descuento = number_format($_configurableproduct->getSpecialPrice() / $moneda_base , 2);
      $desde = number_format($_configurableproduct->getDesde() / $moneda_base , 2);
      $_configurableproduct->setPrice($precio);
      $_configurableproduct->setSpecialPrice($descuento);
      $_configurableproduct->setDesde($desde);
      //Configurables
      $attributes = $_configurableproduct->getTypeInstance(true)->getConfigurableAttributes($_configurableproduct);
      $i = 0;
      foreach ($attributes as $attribute)
      $prices = $attribute->getPrices();
      foreach ($prices as $price)
      $pricesByAttributeValues[$i]['product_super_attribute_id'] = $price['product_super_attribute_id'];
      $pricesByAttributeValues[$i]['value_index'] = $price['value_index'];
      $pricesByAttributeValues[$i]['label'] = $price['label'];
      $pricesByAttributeValues[$i]['default_label'] = $price['default_label'];
      $pricesByAttributeValues[$i]['store_label'] = $price['store_label'];
      $pricesByAttributeValues[$i]['is_percent'] = $price['is_percent'];
      $pricesByAttributeValues[$i]['pricing_value'] = (float)$price['pricing_value'] / 2;
      $pricesByAttributeValues[$i]['use_default_value'] = $price['use_default_value'];
      $pricesByAttributeValues[$i]['value_id'] = $price['value_id'];
      $i++;


      try

      $_configurableproduct->setCanSaveConfigurableAttributes(true);
      $_configurableproduct->setConfigurableAttributesData($pricesByAttributeValues);
      $_configurableproduct->save();
      catch (Exception $e)
      echo 'Excepción capturada: ', $e->getMessage(), "n";








      magento-1 superattribute






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Apr 13 '16 at 7:55









      Siarhey Uchukhlebau

      10.6k9 gold badges32 silver badges61 bronze badges




      10.6k9 gold badges32 silver badges61 bronze badges










      asked Apr 12 '16 at 5:21









      Manuel MattarManuel Mattar

      62 bronze badges




      62 bronze badges























          1 Answer
          1






          active

          oldest

          votes


















          0














          I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.



          For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:



          $_configurableproduct->getId();
          $_configurableproduct->getName();


          ...don't do anything at all, they're just useless.






          share|improve this answer



























            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "479"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110458%2fintegrity-constraint-violation-duplicate-entry-for-key-unq-catalog-product-sup%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.



            For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:



            $_configurableproduct->getId();
            $_configurableproduct->getName();


            ...don't do anything at all, they're just useless.






            share|improve this answer





























              0














              I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.



              For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:



              $_configurableproduct->getId();
              $_configurableproduct->getName();


              ...don't do anything at all, they're just useless.






              share|improve this answer



























                0












                0








                0







                I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.



                For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:



                $_configurableproduct->getId();
                $_configurableproduct->getName();


                ...don't do anything at all, they're just useless.






                share|improve this answer













                I think what the exception is saying, is, that you try to add the same super-attribute twice to the product; so, when trying to insert into the database, the unique key throws an error.



                For more help, please add some more comments to your code, and please to this in English. You could also clean it up a little; only by first glance, these lines:



                $_configurableproduct->getId();
                $_configurableproduct->getName();


                ...don't do anything at all, they're just useless.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Apr 13 '16 at 7:47









                simonthesorcerersimonthesorcerer

                3,6572 gold badges11 silver badges28 bronze badges




                3,6572 gold badges11 silver badges28 bronze badges






























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Magento Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f110458%2fintegrity-constraint-violation-duplicate-entry-for-key-unq-catalog-product-sup%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Grendel Contents Story Scholarship Depictions Notes References Navigation menu10.1093/notesj/gjn112Berserkeree

                    Area configuration aggregation error after install Porto themeMagento 2.1 CE Installed but front/backend not loading/workingCSS not loading on page within Magento 2 pageCannot install module in Magento 2no commands defined in the “setup” namespace. in Magento2Magento 2: Static files are present but shows 404Why do i have to always run the commands to clean cache in Magento 2.1.8?Failure reason: 'Unable to unserialize value.'Error 500 after magento migrationIn production mode the site does not loadMagento 2 : Error 500 after installing

                    Middle Expansion Olielle Resaix Definition: Uttering songs of triumph shouting with joy triumphant exulting Sejunction Journal 붙다 달 고급 품목 외출 The stretch trades the screeching tin. Definition: The act of speaking with a drawl a drawl Cough Sand Definition: An uproar a quarrel a noisy outbreak Shake Iron Publicize Horse House Baby 사과 Resaix Flaggy Jelly Temporary Unequaled Puppet A drop in the bucket Shrew 성격 회원 성질 미팅 The burn frames the tacky quality. Materialistic The smoke reduces the way. Yammoe Nondescript Cheek 얼굴 배 약하다 날리다 타다 The illegal country shows the iron. Help Rule Drearien Smoke Teaching Meaty Wasp Abraham Lincoln Jaws 진심 수리하다 Size Cork Idea Convert Think Lark John Lennon 거울 청소 군 추천하다 아이스크림