[Cooleyvol]

Originally Posted by fhomess

That's not enough detail to know what's wrong (SQL errors are notorious for giving you just enough to be frustrated). OOTP12 has a number of bugs in the SQL dump that for whatever reason didn't show up with my league. Often if the error is on line 1 and you're not getting the table to load at all, it's because it doesn't have that table created yet in the database. Feel free to post the first few lines of each SQL file and I should be able to see what's happening.

Players Game Batting:

DROP TABLE IF EXISTS `players_game_batting`;
CREATE TABLE IF NOT EXISTS `players_game_batting` (`player_id` INT, `year` SMALLINT, `team_id` INT, `game_id` INT, `league_id` INT, `level_id` SMALLINT, `split_id` SMALLINT, `position` SMALLINT, `ab` SMALLINT, `h` SMALLINT, `k` SMALLINT, `pa` SMALLINT, `pitches_seen` SMALLINT, `g` SMALLINT, `gs` SMALLINT, `d` SMALLINT, `t` SMALLINT, `hr` SMALLINT, `r` SMALLINT, `rbi` SMALLINT, `sb` SMALLINT, `cs` SMALLINT, `bb` SMALLINT, `ibb` SMALLINT, `gdp` SMALLINT, `sh` SMALLINT, `sf` SMALLINT, `hp` SMALLINT, `ci` SMALLINT, `vorp` DOUBLE);
insert into `players_game_batting` VALUES (13, 2011, 32, 2433, 10, 2, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000);
insert into `players_game_batting` VALUES (13, 2011, 32, 2489, 10, 2, 0, 2, 3, 0, 1, 3, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000);

Player Contract Extensions:

DROP TABLE IF EXISTS `players_contract_extension`;
CREATE TABLE IF NOT EXISTS `players_contract_extension` (`player_id` INT, `team_id` INT, `league_id` INT, `is_major` TINYINT, `no_trade` TINYINT, `last_year_team_option` TINYINT, `last_year_player_option` TINYINT, `contract_team_id` INT, `contract_league_id` INT, `season_year` INT, `salary0` INT, `salary1` INT, `salary2` INT, `salary3` INT, `salary4` INT, `salary5` INT, `salary6` INT, `salary7` INT, `salary8` INT, `salary9` INT, `years` SMALLINT, `current_year` SMALLINT, `minimum_pa` SMALLINT, `minimum_pa_bonus` INT, `minimum_ip` SMALLINT, `minimum_ip_bonus` INT, `mvp_bonus` INT, `cyyoung_bonus` INT, PRIMARY KEY (`player_id`));
insert into `players_contract_extension` VALUES (1, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
insert into `players_contract_extension` VALUES (2, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);