I found the key to solve this problem in: http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB_foreign_key_constraints.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/[EMAIL PROTECTED]
