0

PHP version : PHP 7.1.3

Magento Version Magento 2.1.16

I tried to upgrade the Magento from 2.1.16 To 2.3.1 and I face this issue. Query Executed during update:

ALTER TABLE customer_group MODIFY COLUMN customer_group_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT

Issue Face :

MySQL said: Documentation #1833 - Cannot change column 'customer_group_id': used in a foreign key constraint 'CAT_PRD_IDX_PRICE_STORE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID' of table 'magento_2_1_7.catalog_product_index_price_store'

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.