Never mind. I found the problem. It is because I have some course_id in groups which do not exist in courses.
On Nov 4, 3:50 pm, Steveston <[EMAIL PROTECTED]> wrote: > I have 6 tables > 1. course > 2. groups > 3. group_members > 4. group_events > 5. events > 6. users > > "Users" is the parent table for group_members > "Courses" is the parent table for groups > "events" is the parent table for group_events > "groups" is the parent table for group_members and group_events > > (Parent table here means that the PK in the parent table is the FK in > child table) > > I can set referential/foreign keys correctly for group_members, > group_events. > > However,when I try to set up referential for "groups",it always fails > (error 1452 "cannot add or update a child row: foreign key constaint > fails"). > > The`PK in groups is id, which is referenced by groups_id in > group_members and group_events. > > The PK in course is id, which I want to have it referenced by > course_id in table "groups". > > Type & size are the same for id in courses and course_id in groups. > > Can anyone suggest me where I made mistake? > > Thanks, --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---