Skip to content

SQL Foreign Key issue preventing setup:upgrade from completing

I am running into an issue when trying to run setup:upgrade, to where it fails with saying;

SQLSTATE[42000]: Syntax error or access violation: 1091 Can’t DROP ‘REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID’; check that column/key exists, query was: ALTER TABLE review DROP FOREIGN KEY REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID

I don’t have any reviews, so my review table is empty (and never been touched), and as far as I know, default with what it has inside it;

enter image description here

I am not even exactly sure what could’ve changed in the system to even have it looking/trying to mess with that section (in trying to drop its foreign key all of a sudden).

Any ideas what could be the issue here? Or a simple way to fix it — by creating a makeshift foreign key just to appease its request?