mysql – Problem creating foreign key in the database, error number 1239. Wrong foreign key definition

Here is my code

CREATE TABLE, IF NOT `game_review`.`game` (
`game_general_id` VARCHAR (8) AS (concat (game_code, game_id)),
`game_code` VARCHAR (1) NOT NULL,
`game_id` INT (7) NOT NULL,
`game_title` VARCHAR (128) NOT NULL,
`game_description` VARCHAR (255) NULL,
`developer_general_id` VARCHAR (8) NOT NULL,
`publisher_general_id` VARCHAR (8) NOT NULL,
`genre_general_id` VARCHAR (4) NOT NULL,
`platform_general_id` VARCHAR (4) NOT NULL,
`platform_general_id2` VARCHAR (4) NOT NULL,
`game_release & # 39; DATE NULL,
`game_upload` DATE NOT NULL,
`game_rating` INT NULL,
`game_price` VARCHAR (24) NULL,
`game_size` VARCHAR (24) NULL,
`game_thumbnail` VARCHAR (255) NULL,
`game_poster` VARCHAR (255) NULL,
`game_image1` VARCHAR (255) NULL,
`game_image2` VARCHAR (255) NULL,
`game_image3` VARCHAR (255) CHARACTER SET # utf8mb4 & # 39; COLLATE # utf8mb4_unicode_ci & # 39; ZERO,
`game_video1` VARCHAR (255) NULL,
`game_video2` VARCHAR (255) NULL,
`user_general_id` VARCHAR (8) NOT NULL,
CONSTRAINT game_general_id PRIMARY KEY (`game_code`,` game_id`),
INDEX `developer_general_id_idx` (` developer_general_id` ASC),
INDEX `genre_general_id_idx` (` genre_general_id` ASC),
INDEX `platform_general_id_idx` (` platform_general_id` ASC),
INDEX `user_general_id_idx` (` user_general_id` ASC),
INDEX `publisher_general_id_idx` (` publisher_general_id` ASC),
INDEX `platform_general_id2_idx` (` platform_general_id2` ASC),
CONSTRAINT `developer_general_idfk`
FOREIGN KEY (`developer_general_id`)
REFERENCES game_review.developer (developer_code, developer_id)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `genre_general_idfk`
FOREIGN KEY (`genre_general_id`)
REFERENCES `game_review`.`genre` (` genre_general_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `platform_general_idfk`
FOREIGN KEY (`platform_general_id`)
REFERENCES `game_review`.`platform` (` platform_general_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `user_general_idfk`
FOREIGN KEY (`user_general_id`)
REFERENCES `game_review`.`user` (` user_general_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `publisher_general_idfk`
FOREIGN KEY (`publisher_general_id`)
REFERENCES `game_review`.`publisher` (` publisher_general_id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `platform_general_idfk2`
Foreign key (`platform_general_id2`)
REFERENCES `game_review`.`platform` (` platform_general_id`)
ON DELETE NO ACTION
UPDATE NO ACTION)
ENGINE = InnoDB;