MySQL Forums
Forum List  »  MySQL Workbench

Error after Forward Engineer
Posted by: Allan Murrell
Date: October 03, 2020 03:53PM

Hi

I am a novice to MySQL but (having done plenty of MS Access Development in the past) and after reading a few chapters of a decent book and watching a few videos on MySQL, I've managed to make a decent start.

Ive installed MySQL v8.0.12 (thats what was specified in the book I bought) and Ive also installed Workbench.

Ive created a Schema and several tables and everything looks fine. Ive mostly been doing this in the EER Diagram and Ive added a few 1:n links and 2 or 3 n:m links. All but one of my n:m are working fine but I keep getting an error and I just cant figure out why. Can anyone please help ?

ERROR: Error 3734: Failed to add the foreign key constraint. Missing column 'event_id' for constraint 'fk_tblEvent_Band_Artist_tblEvents1' in the referenced table 'tblevents'




Al

Options: ReplyQuote


Subject
Views
Written By
Posted
Error after Forward Engineer
59
October 03, 2020 03:53PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.