Re: ERROR 1005: Can't create table (errno: 150)

[Lisa DeSouza]

José Martínez Benavides Wrote:
-------------------------------------------------------
> Make sure the action you set in the ON DELETE or
> ON UPDATE clause doesn't make a conflict with the
> foreign key field. That´s to say, you can't use
> ON DELETE SET NULL if the foreign key field has a
> NOT NULL clause. I hope this was your problem.
>
> Regards,
>
> José Martínez

JOSE, YOU ARE MY NEW HERO!!! MUAAAAAH, THANX A WHOLE LOT!! MY FIELD WAS NOT NULL AND I WAS TRYING TO SET ON DELETE TO NULL.... THANK YOU THANK YOU THANK YOU