Cannot add foreign key constraint, mysql

Question

I have three tables: advocate, client and event. In event table, I have two fields that are referencing two fields from advocate table and one field referencing client, and when I try to add foreign key I get this cannot add foreign key constraint error.

create table advocate(

ida int(11) not null, 
idk int(11) not null,

#...

primary key(ida, idk)

)engine = InnoDB default charset=utf8;



create table client(

jmb varchar(13) not null primary key

#...

)engine=InnoDB default charset=utf8;



create table event(

ida int(11) not null,
idk int(11) not null,
jmb varchar(13) not null,

#...

primary key(ida,idk,jmb),

foreign key(ida, idk)
references advocate(ida, idk)
on update cascade
on delete restrict,

foreign key(jmb)
references client.jmb
on update cascade
on delete restrict


)engine=InnoDB default charset=utf8;

If we are to help you, it's important to show the precise text of the command that fails and the precise text of the resulting error message. Please [edit] your question to provide those things. — O. Jones, Feb 19 '17 at 17:16
Possible duplicate of [MySQL Cannot Add Foreign Key Constraint](http://stackoverflow.com/questions/15534977/mysql-cannot-add-foreign-key-constraint) — ultrajohn, Feb 19 '17 at 17:17

score 1 · Accepted Answer · answered Feb 19 '17 at 17:17

1

Can you try changing:

foreign key(jmb)
references client.jmb
on update cascade
on delete restrict

to

foreign key(jmb)
references client (jmb)
on update cascade
on delete restrict

answered Feb 19 '17 at 17:17

Darshan Mehta

30,102
11
68
102

That was it. Thank you – bliny Feb 19 '17 at 17:20

Cannot add foreign key constraint, mysql

1 Answers1