2

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

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;
  • 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

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.