I can't install

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
I got this error when i'm trying to install it:
JInstaller: :Instalar: Error SQL DB función de error con el numero de error 1005
Can't create table 'cdazuagadb.jos_multileague_player_prediction' (errno: 150) SQL=CREATE TABLE IF NOT EXISTS `jos_multileague_player_prediction` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL , `game_id` INT(11) UNSIGNED NOT NULL , `home_score_prediction` INT(11) UNSIGNED NOT NULL , `away_score_prediction` INT(11) UNSIGNED NOT NULL , `submition_date` DATETIME NOT NULL , `status` TINYINT(4) NOT NULL , PRIMARY KEY (`id`), UNIQUE( `user_id`, `game_id`), INDEX (`user_id`), INDEX (`game_id`), CONSTRAINT FOREIGN KEY (`user_id`) REFERENCES `jos_users`(`id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT FOREIGN KEY (`game_id`) REFERENCES `jos_multileague_game`(`id`) ON DELETE CASCADE ON UPDATE CASCADE )ENGINE=InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
SQL =
CREATE TABLE IF NOT EXISTS `#__multileague_player_prediction` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL ,
`game_id` INT(11) UNSIGNED NOT NULL ,
`home_score_prediction` INT(11) UNSIGNED NOT NULL ,
`away_score_prediction` INT(11) UNSIGNED NOT NULL ,
`submition_date` DATETIME NOT NULL ,
`status` TINYINT(4) NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE( `user_id`, `game_id`),
INDEX (`user_id`),
INDEX (`game_id`),
CONSTRAINT FOREIGN KEY (`user_id`)
REFERENCES `#__users`(`id`)
ON DELETE NO ACTION
ON UPDATE CASCADE,
CONSTRAINT FOREIGN KEY (`game_id`)
REFERENCES `#__multileague_game`(`id`)
ON DELETE CASCADE
ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
Instalación de componentes: error en archivo SQL DB función de error con el numero de error 1005
Can't create table 'cdazuagadb.jos_multileague_player_prediction' (errno: 150) SQL=CREATE TABLE IF NOT EXISTS `jos_multileague_player_prediction` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL , `game_id` INT(11) UNSIGNED NOT NULL , `home_score_prediction` INT(11) UNSIGNED NOT NULL , `away_score_prediction` INT(11) UNSIGNED NOT NULL , `submition_date` DATETIME NOT NULL , `status` TINYINT(4) NOT NULL , PRIMARY KEY (`id`), UNIQUE( `user_id`, `game_id`), INDEX (`user_id`), INDEX (`game_id`), CONSTRAINT FOREIGN KEY (`user_id`) REFERENCES `jos_users`(`id`) ON DELETE NO ACTION ON UPDATE CASCADE, CONSTRAINT FOREIGN KEY (`game_id`) REFERENCES `jos_multileague_game`(`id`) ON DELETE CASCADE ON UPDATE CASCADE )ENGINE=InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
SQL =
CREATE TABLE IF NOT EXISTS `#__multileague_player_prediction` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL ,
`game_id` INT(11) UNSIGNED NOT NULL ,
`home_score_prediction` INT(11) UNSIGNED NOT NULL ,
`away_score_prediction` INT(11) UNSIGNED NOT NULL ,
`submition_date` DATETIME NOT NULL ,
`status` TINYINT(4) NOT NULL ,
PRIMARY KEY (`id`),
UNIQUE( `user_id`, `game_id`),
INDEX (`user_id`),
INDEX (`game_id`),
CONSTRAINT FOREIGN KEY (`user_id`)
REFERENCES `#__users`(`id`)
ON DELETE NO ACTION
ON UPDATE CASCADE,
CONSTRAINT FOREIGN KEY (`game_id`)
REFERENCES `#__multileague_game`(`id`)
ON DELETE CASCADE
ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
Hello,
welcome on board!

we ll take a look asap.

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
Hello, can you please tell me the Mysql version and if your mysql server supports InnoDB engine?And redownload the component from the website and try to install it again .

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
I've downloaded three times but it doesn't work

Mysql version it's 5.1 so i think it supports innodb engine

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
Can you change the Joomla jos_users table to InnoDB or else you will need to change all the tables of the module to MyISAM but the component didnt tested with MyISAM engine , so the better option is to change the joomla X_users table to innoDB. Dont forget to get backup of your database before you do anythink.

Edit.
Another solution would be to remove the foreign key user_id

this text "CONSTRAINT FOREIGN KEY (`user_id`)
REFERENCES `#__users`(`id`)
ON DELETE CASCADE
ON UPDATE CASCADE,"

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
I used second solution and now it's fixed.

Thanks!

[3hills]

--------------------------------------------------
Topic Transfered from old forum
--------------------------------------------------
The current version of the component can be installed even if your joomla tables are MyISAM , but be sure you have installed the plugin of the component too.