ERROR 1005: Can't create table './db/table.frm' (errno: 150)

Hello,

I found the key to solve this problem in:
http://darkstar.ist.utl.pt/mysql/doc...nstraints.html

You'll probably need an INDEX for that new foreign key you are declaring in
older versions this isn't neccesary but in latest ones it is a restriction.

You can have more info about the error description if you have root access
by typing
mysql> show innodb status;

LATEST FOREIGN KEY ERROR
------------------------
030807 1:27:10 Error in foreign key constraint of table database/table:
There is no index in the table database/table where the columns appear
as the first columns. Constraint:
foreign key (key) references database.table(key) on delete cascade)
type=innodb
also if you type:
shell> perror 150

you obtain:
150 = Foreign key constraint is incorrectly formed
I hope this to be enough...
Aaron D. Tavío Medina

__________________________________________________ _______________
Multiplica por cinco el tamaño de tu buzón de correo y envía adjuntos de
hasta 2 Mb con MSN Almacenamiento Extra. http://join.msn.com/?pgmarket=es-es
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw