Ttdfjt

How can I convert a linear narrative into a branching narrative?

If the Moon were impacted by a suitably sized meteor, how long would it take to impact the Earth?

Microgravity indicators

How to prevent a single-element caster from being useless against immune foes?

Is it unprofessional to mention your cover letter and resume are best viewed in Chrome?

Can you continue the movement of a Bonus Action Dash granted by Expeditious Retreat if your Concentration is broken mid-move?

How to efficiently shred a lot of cabbage?

Word for giving preference to the oldest child

PCB design using code instead of clicking a mouse?

Using Python in a Bash Script

What are the closest international airports in different countries?

"DDoouubbllee ssppeeaakk!!"

Correct word for a little toy that always stands up?

Should students have access to past exams or an exam bank?

Move arrows along a contour

Reading electrical clamp tester higher voltage/amp 400A

How does Asimov's second law deal with contradictory orders from different people?

My employer is refusing to give me the pay that was advertised after an internal job move

What is a good example for artistic ND filter applications?

Is there any way to work simultaneously on the same DAW project remotely?

Why would an invisible personal shield be necessary?

Why did Windows 95 crash the whole system but newer Windows only crashed programs?

Unknown indication below upper stave

Why tantalum for the Hayabusa bullets?

Magento 2 : Foreign key constraint is incorrectly formed, ALTER TABLE customer_group

upgrade issue from 2.1.14 to 2.2 :: magento2Reindexing foreign key constraint fails on Attribute's IndexMagento import tables from old database show error (errno: 150 “Foreign key constraint is incorrectly formed”)How to export and import categories from MySQLMagento 2.2 : Cannot Add SubcategoryForeign key constraint fails Entity_Type_IDIntegrity constraint error referring to quote_item table while adding product to cartMagento 2 : Unique constraint violation found when adding product, categories or mega menu itemsI faced the error while search any string Magento 2Foreign key constraint is incorrectly formed after upgrade to 2.3.0ALTER TABLE `customer_group` MODIFY COLUMN `customer_group_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

4

After upgrade from magento 2.1.7 to 2.2.3 and am stuck. I have tried everything.

In Pdo.php line 235:

SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to './zwwnzwzjhe/customer_group' (errno:
150 - Foreign key constraint is incorrectly formed), query was: ALTER
TABLE customer_group MODIFY COLUMN customer_group_id int(10)
UNSIGNED NOT NULL AUTO_INCREMENT

In Pdo.php line 228: SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to
'./zwwnzwzjhe/customer_group' (errno: 150 - Foreign key constraint is
incorrectly formed)

I am unable to delete this table or make any changes to this table ...please help.

Thank you

magento2 database customer foreign-key

share|improve this question

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

add a comment | 

4

After upgrade from magento 2.1.7 to 2.2.3 and am stuck. I have tried everything.

In Pdo.php line 235:

SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to './zwwnzwzjhe/customer_group' (errno:
150 - Foreign key constraint is incorrectly formed), query was: ALTER
TABLE customer_group MODIFY COLUMN customer_group_id int(10)
UNSIGNED NOT NULL AUTO_INCREMENT

In Pdo.php line 228: SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to
'./zwwnzwzjhe/customer_group' (errno: 150 - Foreign key constraint is
incorrectly formed)

I am unable to delete this table or make any changes to this table ...please help.

Thank you

magento2 database customer foreign-key

share|improve this question

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

add a comment | 

After upgrade from magento 2.1.7 to 2.2.3 and am stuck. I have tried everything.

In Pdo.php line 235:

SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to './zwwnzwzjhe/customer_group' (errno:
150 - Foreign key constraint is incorrectly formed), query was: ALTER
TABLE customer_group MODIFY COLUMN customer_group_id int(10)
UNSIGNED NOT NULL AUTO_INCREMENT

In Pdo.php line 228: SQLSTATE[HY000]: General error: 1025 Error on rename of './zwwnzwzjhe/#sql-1bd1_25f9' to
'./zwwnzwzjhe/customer_group' (errno: 150 - Foreign key constraint is
incorrectly formed)

I am unable to delete this table or make any changes to this table ...please help.

Thank you

magento2 database customer foreign-key

share|improve this question

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

share|improve this question

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

share|improve this question

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

edited Mar 3 at 16:08

Vishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

asked Mar 3 at 14:47

rogerroger

17622 silver badges1616 bronze badges

1 Answer
1

active

oldest

votes

0

To work around this, use either of these solutions. Both present risks of damaging the data integrity.

Option 1:

Remove constraints
Perform TRUNCATE
Delete manually the rows that now have references to nowhere
Create constraints

Option 2:

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table customer_group; 
SET FOREIGN_KEY_CHECKS = 1;

share|improve this answer

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  nothing works I am unable to delete manually due to foreign key, Option 2 also doesnt work when i truncate, I get the Cannot truncate a table referenced in a foreign key constraint (zwwnzwzjhe.catalog_product_bundle_price_index, CONSTRAINT catalog_product_bundle_price_index_ibfk_1 FOREIGN KEY (customer_group_id) REFERENCES zwwnzwzjhe.customer_group (`customer_) 16:14:18 SQL command
  
  – roger
  Mar 3 at 16:15
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @roger even when you are using second option ?
  
  – Vishwas Bhatnagar
  Mar 3 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes SET FOREIGN_KEY_CHECKS = 0 Query executed OK, 0 rows affected. (0.000 s) Edit TRUNCATE table customer_group Query executed OK, 0 rows affected. (0.023 s) Edit SET FOREIGN_KEY_CHECKS = 1 Query executed OK, 0 rows affected. (0.000 s) Edit
  
  – roger
  Mar 3 at 16:20
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Query seems to be executed , i don't see any errors @roger
  
  – Vishwas Bhatnagar
  Mar 3 at 16:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  0 rows affected. i still get the same error so I am guessing now effect is taking place
  
  – roger
  Mar 3 at 16:35
  

  
  
  
  

 | 
show 2 more comments

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f264178%2fmagento-2-foreign-key-constraint-is-incorrectly-formed-alter-table-customer-g%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

To work around this, use either of these solutions. Both present risks of damaging the data integrity.

Option 1:

Remove constraints
Perform TRUNCATE
Delete manually the rows that now have references to nowhere
Create constraints

Option 2:

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table customer_group; 
SET FOREIGN_KEY_CHECKS = 1;

share|improve this answer

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  nothing works I am unable to delete manually due to foreign key, Option 2 also doesnt work when i truncate, I get the Cannot truncate a table referenced in a foreign key constraint (zwwnzwzjhe.catalog_product_bundle_price_index, CONSTRAINT catalog_product_bundle_price_index_ibfk_1 FOREIGN KEY (customer_group_id) REFERENCES zwwnzwzjhe.customer_group (`customer_) 16:14:18 SQL command
  
  – roger
  Mar 3 at 16:15
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @roger even when you are using second option ?
  
  – Vishwas Bhatnagar
  Mar 3 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes SET FOREIGN_KEY_CHECKS = 0 Query executed OK, 0 rows affected. (0.000 s) Edit TRUNCATE table customer_group Query executed OK, 0 rows affected. (0.023 s) Edit SET FOREIGN_KEY_CHECKS = 1 Query executed OK, 0 rows affected. (0.000 s) Edit
  
  – roger
  Mar 3 at 16:20
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Query seems to be executed , i don't see any errors @roger
  
  – Vishwas Bhatnagar
  Mar 3 at 16:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  0 rows affected. i still get the same error so I am guessing now effect is taking place
  
  – roger
  Mar 3 at 16:35
  

  
  
  
  

 | 
show 2 more comments

0

To work around this, use either of these solutions. Both present risks of damaging the data integrity.

Option 1:

Remove constraints
Perform TRUNCATE
Delete manually the rows that now have references to nowhere
Create constraints

Option 2:

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table customer_group; 
SET FOREIGN_KEY_CHECKS = 1;

share|improve this answer

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  nothing works I am unable to delete manually due to foreign key, Option 2 also doesnt work when i truncate, I get the Cannot truncate a table referenced in a foreign key constraint (zwwnzwzjhe.catalog_product_bundle_price_index, CONSTRAINT catalog_product_bundle_price_index_ibfk_1 FOREIGN KEY (customer_group_id) REFERENCES zwwnzwzjhe.customer_group (`customer_) 16:14:18 SQL command
  
  – roger
  Mar 3 at 16:15
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @roger even when you are using second option ?
  
  – Vishwas Bhatnagar
  Mar 3 at 16:16
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes SET FOREIGN_KEY_CHECKS = 0 Query executed OK, 0 rows affected. (0.000 s) Edit TRUNCATE table customer_group Query executed OK, 0 rows affected. (0.023 s) Edit SET FOREIGN_KEY_CHECKS = 1 Query executed OK, 0 rows affected. (0.000 s) Edit
  
  – roger
  Mar 3 at 16:20
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Query seems to be executed , i don't see any errors @roger
  
  – Vishwas Bhatnagar
  Mar 3 at 16:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  0 rows affected. i still get the same error so I am guessing now effect is taking place
  
  – roger
  Mar 3 at 16:35
  

  
  
  
  

 | 
show 2 more comments

To work around this, use either of these solutions. Both present risks of damaging the data integrity.

Option 1:

Remove constraints
Perform TRUNCATE
Delete manually the rows that now have references to nowhere
Create constraints

Option 2:

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table customer_group; 
SET FOREIGN_KEY_CHECKS = 1;

share|improve this answer

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

Remove constraints
Perform TRUNCATE
Delete manually the rows that now have references to nowhere
Create constraints

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table customer_group; 
SET FOREIGN_KEY_CHECKS = 1;

share|improve this answer

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges

answered Mar 3 at 16:07

Vishwas BhatnagarVishwas Bhatnagar

3,06322 gold badges2323 silver badges4646 bronze badges