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 KEYREVIEW_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;
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?