After Upgrade 2.2.5 To 2.3.0 when i am runnung php bin/magento setup:upgrade it give bellow error:

Schema creation/updates:

SQLSTATE[HY000]: General error: 1823 Failed to add the foreign key constraint 'test@test@002dtestnew/CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID' to system tables, query was: ALTER TABLE cms_block_store MODIFY COLUMN block_id smallint(6) NOT NULL , ADD CONSTRAINT CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID FOREIGN KEY (block_id) REFERENCES cms_block (block_id) ON DELETE CASCADE, ADD CONSTRAINT CMS_BLOCK_STORE_STORE_ID_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE CASCADE


An error was due to Duplicate tables in a database, BK_cms_block. i was copied table and rename it for backup purpose and that creating issue , so i just delete BK tables and error resolve

| improve this answer | |
  • No one can think of such solution :) But Really it worked. Thanks a lot. – Dhaval Solanki Aug 13 '19 at 6:28
  • Thanks for good feedback – Navin Bhudiya Aug 13 '19 at 6:31
  • 1
    Works for me as well. – Sukumar Gorai Oct 30 '19 at 19:45

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.