Error 1005, but can't find problem.

[Fog Juice]

Hello,

 

I keep getting the following error from this code but I can't figure out waht the problem is. Any suggestions?

 

Error:

[Err] 1005 - Can't create table 'dsds.mana_char_status_effects' (errno: 150)

 

Code:

--
-- table: `mana_char_status_effects`
--
CREATE TABLE IF NOT EXISTS `mana_char_status_effects` (
    `char_id`       int(10)         unsigned NOT NULL,
    `status_id`     smallint(5)     unsigned NOT NULL,
    `status_time`   int(10)         signed NOT NULL,
    --
    PRIMARY KEY (`char_id`, `status_id`),
    FOREIGN KEY (`char_id`)
        REFERENCES `mana_characters` (`id`)
        ON DELETE CASCADE
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;

[rajivgonsalves]

that is a foriegn key problem run

 

Show engine innodb status; 

 

to see more details right after you try to create the table