Hi, Alexandre! On Mar 30, Alexandre Almeida wrote:
Hi all,
Any idea why I am getting this error:
A) ERROR
ALTER TABLE login ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil) REFERENCES db_perfil (id_perfil) ON DELETE NO ACTION ON UPDATE NO ACTION; ERROR 1005 (HY000): Can't create table 'dbhomo_aa.#sql-c1f_281' (errno: 150)
you tell us too litle to guess. perhaps there's no db_perfil table in the dbhomo_aa database ? As the manual explains, after errno:150 you can use SHOW ENGINE INNODB STATUS to see a detailed error message
B) HERE IT WORKS
ALTER TABLE login ADD CONSTRAINT fk_db_perfil FOREIGN KEY (id_perfil) REFERENCES dbhomo.db_perfil (id_perfil) ON DELETE NO ACTION ON UPDATE NO ACTION; Query OK, 35199 rows affected (3,27 sec) Records: 35199 Duplicates: 0 Warnings: 0
Note that when I change the database to the original database the command works as expected. Both tables are innodb, the permissions are fine.
Thanks,
Alex
Regards, Sergei