Magento 1: Error Creating a Customer Attribute

Question

I'm trying to create a Wholesale: Yes/No drop down attribute on customer accounts in the admin. After creating my module and install script, I get the following error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'mycompany_wholesale_setup' for key 'PRIMARY'

Here is what I tried:

app/etc/modules/Mycompany_Wholesale.xml

<?xml version="1.0"?>
    <config>
        <modules>
            <Mycompany_Wholesale>
                <active>true</active>
                <codePool>local</codePool>
                <version>0.1.0</version>
            </Mycompany_Wholesale>
        </modules>
    </config>

---

app/code/local/Mycompany/Wholesale/etc/config.xml

<?xml version="1.0"?>
    <config>
        <modules>
            <Mycompany_Wholesale>
                <version>0.1.0</version>
            </Mycompany_Wholesale>
        </modules>
        <global>
            <resources>
                <mycompany_wholesale_setup>
                    <setup>
                        <module>Mycompany_Wholesale</module>
                        <class>Mage_Customer_Model_Entity_Setup</class>
                    </setup>
                    <connection>
                        <use>core_setup</use>
                    </connection>
                </mycompany_wholesale_setup>

                <Mycompany_Wholesale_write>
                    <connection>
                        <use>core_write</use>
                    </connection>
                </Mycompany_Wholesale_write>

                <Mycompany_Wholesale_read>
                    <connection>
                        <use>core_read</use>
                    </connection>
                </Mycompany_Wholesale_read>
            </resources>
        </global>   
    </config>

---

app/code/local/Mycompany/Wholesale/sql/mycompany_wholesale_setup/mysql4-install-0.1.0.php

<?php
$installer = $this;
$installer->startSetup();

$setup = new Mage_Eav_Model_Entity_Setup('core_setup');

$entityTypeId     = $setup->getEntityTypeId('customer');
$attributeSetId   = $setup->getDefaultAttributeSetId($entityTypeId);
$attributeGroupId = $setup->getDefaultAttributeGroupId($entityTypeId, $attributeSetId);

$setup->addAttribute("customer", "wholesale",  array(
    "type"     => "int",
    "backend"  => "",
    "label"    => "Wholesale",
    "input"    => "select",
    'source'   => 'eav/entity_attribute_source_boolean',
    "visible"  => true,
    "required" => false,
    "default"  => "",
    "frontend" => "",
    "unique"   => false,
    "note"     => "Wholesale"
));

        $attribute   = Mage::getSingleton("eav/config")->getAttribute("customer", "wholesale");


$setup->addAttributeToGroup(
    $entityTypeId,
    $attributeSetId,
    $attributeGroupId,
    'wholesale',
    '999'  //sort_order
);

$used_in_forms=array();

$used_in_forms[]="adminhtml_customer";
//$used_in_forms[]="checkout_register";
//$used_in_forms[]="customer_account_create";
//$used_in_forms[]="customer_account_edit";
//$used_in_forms[]="adminhtml_checkout";
        $attribute->setData("used_in_forms", $used_in_forms)
                ->setData("is_used_for_customer_segment", true)
                ->setData("is_system", 0)
                ->setData("is_user_defined", 1)
                ->setData("is_visible", 1)
                ->setData("sort_order", 100)
                ;
        $attribute->save();    

$installer->endSetup();

Any idea what I did wrong or how I can fix the Duplicate entry error? I should also note that I don't have direct access to the DB

Answer 1

Try this Code

in your config.xml file

<?xml version="1.0"?>
<config>
  <modules>
    <Mycompany_Wholesale>
      <version>0.1.0</version>
    </Mycompany_Wholesale>
  </modules>
  <global>
    <helpers>
      <wholesale>
        <class>Mycompany_Wholesale_Helper</class>
      </wholesale>
    </helpers>
    <models>
      <wholesale>
        <class>Mycompany_Wholesale_Model</class>
        <resourceModel>wholesale_mysql4</resourceModel>
      </wholesale>
    </models>
    <resources>
      <customerattribute_setup>
        <setup>
          <module>Mycompany_Wholesale</module>
          <class>Mage_Customer_Model_Entity_Setup</class>
        </setup>
        <connection>
          <use>core_setup</use>
        </connection>
      </customerattribute_setup>
      <customerattribute_write>
        <connection>
          <use>core_write</use>
        </connection>
      </customerattribute_write>
      <customerattribute_read>
        <connection>
          <use>core_read</use>
        </connection>
      </customerattribute_read>
    </resources>
  </global>
</config> 

and in your install file customerattribute_setup/mysql4-install-0.1.0.php

<?php
$installer = $this;
$installer->startSetup();


$installer->addAttribute("customer", "wholesale",  array(
    "type"     => "int",
    "backend"  => "",
    "label"    => "Wholesale",
    "input"    => "select",
    "source"   => "eav/entity_attribute_source_boolean",
    "visible"  => true,
    "required" => false,
    "default" => "",
    "frontend" => "",
    "unique"     => false,
    "note"       => ""

    ));

$attribute   = Mage::getSingleton("eav/config")->getAttribute("customer", "wholesale");


$used_in_forms=array();

$used_in_forms[]="adminhtml_customer";
        $attribute->setData("used_in_forms", $used_in_forms)
        ->setData("is_used_for_customer_segment", true)
        ->setData("is_system", 0)
        ->setData("is_user_defined", 1)
        ->setData("is_visible", 1)
        ->setData("sort_order", 100)
        ;
        $attribute->save();



$installer->endSetup();

Please note, I used customerattribute_setup instead of mycompany_wholesale_setup, So you only need to adjust this as you wish