magento2-module-retailer icon indicating copy to clipboard operation
magento2-module-retailer copied to clipboard

Published 20 hours ago • verified publisher icon Smile-SA

Schema update failure: Duplicated key name

Open almeidarobertop opened this issue 8 months ago • 0 comments

When upgrading module from 1.2.9.1 to 2.0.0 we faced an error with duplicate key name. image

Preconditions

Adobe Cloud

Magento Version : Commerce 2.4.6-p3

Module Retailer Version : 1.2.9.1

Environment : Production

Third party modules : no

Steps to reproduce

1. Composer update smile/module-retailer 2. bin/magento setup:upgrade

Expected result

1. Complete setup with no error

Actual result

1. SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'SMILE_RETAILER_ADDRESS_RETAILER_ID', query was: ALTER TABLE smile_retailer_address ADD CONSTRAINT SMILE_RETAILER_ADDRESS_RETAILER_ID UNIQUE KEY (retailer_id) 2. image

almeidarobertop avatar Oct 20 '23 18:10 almeidarobertop