Database Exception: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'n2-cr_matrixcontent_column1_locale_fk'; check that column/key exists

This is the error I am receiving when attempting to update the database for the new version of craft. I've checked for that specific table and confirmed that it doesn't exist. How do I prevent it from trying to drop it or otherwise fix this problem?

  • Bump. Having a similar issue.
    – Dustin C
    Jul 6, 2018 at 21:13

1 Answer 1


For reference to anyone else that might have this problem. Some of the tables in my database did not have foreign keys in the specific Craft format. This occurred when table changes were done manually without knowing about this extra detail. Shout out to Brad Bell with Craft support for catching and fixing the problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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