mysql代码1005外键_MySQL中的外键添加失败,错误代码为1005,编号150

所以我试图在我的一个表中添加一个新的外键：

ALTER TABLE `UserTransactions`.`ExpenseBackTransactions`

ADD CONSTRAINT `FK_EBTx_CustomAccountID`

FOREIGN KEY (`CustomAccountID` )

REFERENCES `UserTransactions`.`CustomAccounts` (`CustomAccountID`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

ADD INDEX `FK_EBTx_CustomAccountID` (`CustomAccountID` ASC) ;

我不断收到以下错误：

Error Code: 1005

Can't create table './UserTransactions/#sql-187a_29.frm' (errno: 150)

过去我已经对这个表和其他表做了很多的改变,这是我第一次碰到这个问题.任何想法是什么造成的？

UPDATE

我的SHOW INNODB STATUS错误：

------------------------

LATEST FOREIGN KEY ERROR

------------------------

110525 15:56:36 Error in foreign key constraint of table UserTransactions/#sql-187a_2c:

FOREIGN KEY (`CustomAccountID` )

REFERENCES `UserTransactions`.`CustomAccounts` (`CustomAccountID` )

ON DELETE NO ACTION

ON UPDATE NO ACTION

, ADD INDEX `FK_EBTx_CustomAccountID` (`CustomAccountID` ASC):

Cannot resolve table name close to:

(`CustomAccountID` )

ON DELETE NO ACTION

ON UPDATE NO ACTION

, ADD INDEX `FK_EBTx_CustomAccountID` (`CustomAccountID` ASC)