Column already exists: 1060 Duplicate column name

Answered

Public

eddieswelding asked May 22, 2019

I am running the installation for Data Migration Pro and am getting an error. I ran php -f bin/magento setup:upgrade and get the error:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘code’, query was: ALTER TABLE `ewe_store_group` ADD COLUMN `code` varchar(32) NULL COMMENT “Store group unique code”, ADD CONSTRAINT `EWE_STORE_GROUP_CODE` UNIQUE KEY (`code`)

UB Data Migration Pro

1 answer

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone May 23, 2019

Public

Hi there,

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘code’, query was: ALTER TABLE `ewe_store_group` ADD COLUMN `code` varchar(32) NULL COMMENT “Store group unique code”, ADD CONSTRAINT `EWE_STORE_GROUP_CODE` UNIQUE KEY (`code`)

Our migration tool doesn’t make any change in the table store_group in the installation step. So, the issue you mentioned is strange. It might relate to something wrong in your instance before you installed our tool (it seems the core module named ‘Magento_Store’ was re-installed when you run the setup:upgrade command).

Please re-check your instance once more at your end, and get back to me if you need further assistance.

Regards,
Mall.