Orsdxy

I am trying to add customer attribute using upgradedata, when ever i ran the the upgrade script it's throw me the "Unique constraint violation found" in command prompt.

UpgradeData.php



public $customer_attribute_used_in_forms = ['adminhtml_checkout','adminhtml_customer','adminhtml_customer_address','customer_account_edit','customer_address_edit','customer_register_address','customer_account_create','customer_address_edit','customer_register_address'];

public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context) {





        $installer = $setup;

        /** @var CustomerSetup $customerSetup */

        $customerSetup = $this->customerSetupFactory->create(['setup' => $setup]);



        if (version_compare($context->getVersion(), '1.1.0') < 0) {



            $installer->getConnection()->addColumn(

                $installer->getTable('quote_address'),

                'address_status',

                [

                    'comment' => 'Address Location',

                    'type' => Table::TYPE_TEXT,

                    'length' => 255

                ]

            );



            $installer->getConnection()->addColumn(

                $installer->getTable('sales_order_address'),

                'address_status',

                [

                    'comment' => 'Address Location',

                    'type' =>  Table::TYPE_TEXT,

                    'length' => 255

                ]

            );

        }



        if (version_compare($context->getVersion(), '1.2.7') < 0) {

           $installer->startSetup();

            $attributeCode = "pin";

            $customerSetup->addAttribute('customer',$attributeCode, 

            [

                'label' => 'PIN',

                'type' => 'text',

                'frontend_input' => 'text',

                'required' => true,

                'visible' => true,

                'system'=> 0,

                'position' => 999,

                'is_used_in_grid' => true,

                'is_visible_in_grid' => true,

                'is_filterable_in_grid' => true,

                'is_searchable_in_grid' => true,

                'backend' => ''

            ]);

            $loyaltyAttribute = $customerSetup->getEavConfig()->getAttribute('customer', $attributeCode);

            $loyaltyAttribute->setData('used_in_forms',$this->customer_attribute_used_in_forms);

            $loyaltyAttribute->save();

            $installer->endSetup();



            $installer->startSetup();

            $attributeCode = "cii_telephone";

            $customerSetup->addAttribute('customer',$attributeCode, 

            [

                'label' => 'Telephone',

                'type' => 'text',

                'frontend_input' => 'text',

                'required' => false,

                'visible' => true,

                'system'=> 0,

                'position' => 1000,

                'is_used_in_grid' => true,

                'is_visible_in_grid' => true,

                'is_filterable_in_grid' => true,

                'is_searchable_in_grid' => true,

                'backend' => ''

            ]);

            $attribute = $customerSetup->getEavConfig()->getAttribute('customer', $attributeCode);

            $attribute->setData('used_in_forms',$this->customer_attribute_used_in_forms);

            $attribute->save();

            $installer->endSetup();

        } 

    }

}

Also update the version on etc/module.xml file with the current version.

Error:

share your ideas and thoughts and thanks in advance for your better support