ERROR 1005: Can't create table (errno: 150)

[inulled]

Executing SQL script in server

ERROR: Error 1005: Can't create table 'drupia1.chosen_themes' (errno: 150)

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

-- Table `drupia1`.`chosen_themes`

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

CREATE  TABLE IF NOT EXISTS `drupia1`.`chosen_themes` (

  `idchosen_themes` INT NOT NULL ,

  `UserPID` VARCHAR(45) NOT NULL ,

  `ThemeID` VARCHAR(45) NOT NULL ,

  `DateTimeLastUsed` DATE NOT NULL ,

  `DateTimeInstalled` DATETIME NOT NULL ,

  PRIMARY KEY (`idchosen_themes`) ,

  INDEX `fk_chosen_themes_users1` (`UserPID` ASC) ,

  INDEX `fk_chosen_themes_theme_repository1` (`ThemeID` ASC) ,

  CONSTRAINT `fk_chosen_themes_users1`

FOREIGN KEY (`UserPID` )

REFERENCES `drupia1`.`users` (`idusers` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

  CONSTRAINT `fk_chosen_themes_theme_repository1`

FOREIGN KEY (`ThemeID` )

REFERENCES `drupia1`.`theme_repository` (`idtheme_repository` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB



SQL script execution finished: statements: 14 succeeded, 1 failed

Can somebody please explain to me what the problem is?

btw, I created this in MySQL Workbench.

[johanafm]

IIrc, that error relates to foreign key problems (google is your friend), and if this is the case, you have most likely misspelt an identifier or have different types on the corresponding fields.