Cannot add or update a child row: a foreign key constraint fails (rcc
.wpzy_crw_editors
, CONSTRAINT wp0e_project_editors
FOREIGN KEY (project
) REFERENCES wp0e_crw_projects
(project
) ON DELETE CASCADE ON UPDATE CASCADE)
INSERT INTO wpzy_crw_editors (project, user_id) VALUES (‘Test Project’, 2),(‘Test Project’, 1)
It’s because the database prefix has changed. Not sure how to fix.