|
Minors (Single A)
Join Date: Apr 2010
Posts: 71
|
hoping to get some help here, have been going 3 years strong and all of a sudden getting this when loading the SQL files
Quote:
Loading leagues.access.sql
Checking Date
DROP TABLE IF EXISTS [leagues]; -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[leagues]' at line 1
CREATE TABLE IF NOT EXISTS [leagues] ([league_id] LONG, [name] TEXT(50), [abbr] TEXT(50), [nation_id] LONG, [language_id] LONG, [gender] LONG, [historical_league] BIT, [logo_file] TEXT(200), [players_path] TEXT(200), [start_date] DATETIME, [preferred_start_date] DATETIME, [pitcher_award_name] TEXT(50), [hitter_award_name] TEXT(50), [rookie_award_name] TEXT(50), [defense_award_name] TEXT(50), [fictional_players] BIT, [start_fantasy_draft] BIT, [trading_deadline] BIT, [winter_meetings] BIT, [arbitration_offering] BIT, [show_draft_pool] BIT, [rosters_expanded] BIT, [draft_date] DATETIME, [rule_5_draft_date] DATETIME, [roster_expand_date] DATETIME, [trade_deadline_date] DATETIME, [allstar_date] DATETIME, [days_until_deadline] LONG, [next_draft_type] LONG, [parent_league_id] LONG, [league_state] BYTE, [season_year] LONG, [historical_year] SHORT, [league_level] BYTE, [stats_detail] LONG, [historical_import_path] TEXT(200), [foreigner_percentage] SHORT, [was_ootp6] BIT, [was_65] BIT, [allstar_game] BIT, [auto_schedule_allstar] BIT, [allstar_team_id0] LONG, [allstar_team_id1] LONG, [schedule_file_1] TEXT(200), [schedule_file_2] TEXT(200), [rules_rule_5] BIT, [rules_minor_league_options] BIT, [rules_trading] BIT, [rules_draft_pick_trading] BIT, [rules_financials] BIT, [rules_amateur_draft] BIT, [rules_fa_compensation] BIT, [rules_schedule_balanced] BIT, [rules_schedule_inter_league] BIT, [rules_schedule_force_start_day] BIT, [rules_trades_other_leagues] BIT, [rules_free_agents_from_other_leagues] BIT, [rules_free_agents_leave_other_leagues] BIT, [rules_allstar_game] BIT, [rules_spring_training] BIT, [rules_active_roster_limit] SHORT, [rules_secondary_roster_limit] SHORT, [rules_expanded_roster_limit] SHORT, [rules_min_service_days] SHORT, [rules_waiver_period_length] SHORT, [rules_dfa_period_length] SHORT, [rules_fa_minimum_years] SHORT, [rules_salary_arbitration_minimum_years] SHORT, [rules_minor_league_fa_minimum_years] SHORT, [rules_foreigner_limit] SHORT, [rules_foreigner_pitcher_limit] SHORT, [rules_foreigner_hitter_limit] SHORT, [rules_schedule_games_per_team] SHORT, [rules_schedule_typical_series] SHORT, [rules_schedule_preferred_start_day] SHORT, [rules_amateur_draft_rounds] SHORT, [rules_minimum_salary] LONG, [rules_salary_cap] LONG, [rules_player_salary0] LONG, [rules_player_salary1] LONG, [rules_player_salary2] LONG, [rules_player_salary3] LONG, [rules_player_salary4] LONG, [rules_player_salary5] LONG, [rules_player_salary6] LONG, [rules_player_salary7] LONG, [rules_average_coach_salary] LONG, [rules_average_attendance] LONG, [rules_average_national_media_contract] LONG, [rules_cash_maximum] LONG, [rules_average_ticket_price] DOUBLE, [rules_revenue_sharing] BIT, [rules_national_media_contract_fixed] BIT, [rules_owner_decides_budget] BIT, [rules_schedule_auto_adjust_dates] BIT, [rules_historical_import_rookies] BIT, [hof_hits] SHORT, [hof_homeruns] SHORT, [hof_wins] SHORT, [hof_saves] SHORT, [hof_vorp] SHORT, [hof_era_wins] SHORT, [hof_avg_hits] SHORT, [hof_era] DOUBLE, [hof_avg] DOUBLE, [avg_rating_contact] LONG, [avg_rating_gap] LONG, [avg_rating_power] LONG, [avg_rating_eye] LONG, [avg_rating_strikeouts] LONG, [avg_rating_stuff] LONG, [avg_rating_movement] LONG, [avg_rating_control] LONG, [avg_rating_fielding0] LONG, [avg_rating_fielding1] LONG, [avg_rating_fielding2] LONG, [avg_rating_fielding3] LONG, [avg_rating_fielding4] LONG, [avg_rating_fielding5] LONG, [avg_rating_fielding6] LONG, [avg_rating_fielding7] LONG, [avg_rating_fielding8] LONG, [avg_rating_fielding9] LONG, [avg_rating_overall] LONG, [avg_rating_age] DOUBLE, [league_totals_ab] LONG, [league_totals_h] LONG, [league_totals_d] LONG, [league_totals_t] LONG, [league_totals_hr] LONG, [league_totals_bb] LONG, [league_totals_hp] LONG, [league_totals_k] LONG, [league_totals_pa] LONG, [league_totals_babip] DOUBLE, [league_totals_mod_h] DOUBLE, [league_totals_mod_d] DOUBLE, [league_totals_mod_t] DOUBLE, [league_totals_mod_hr] DOUBLE, [league_totals_mod_bb] DOUBLE, [league_totals_mod_hp] DOUBLE, [league_totals_mod_k] DOUBLE, [league_totals_mod_babip] DOUBLE, [ml_equivalencies_avg] DOUBLE, [ml_equivalencies_hr] DOUBLE, [ml_equivalencies_eb] DOUBLE, [ml_equivalencies_bb] DOUBLE, [ml_equivalencies_k] DOUBLE, [ml_equivalencies_hp] DOUBLE, [player_creation_modifier_contact] DOUBLE, [player_creation_modifier_gap] DOUBLE, [player_creation_modifier_power] DOUBLE, [player_creation_modifier_eye] DOUBLE, [player_creation_modifier_strikeouts] DOUBLE, [player_creation_modifier_stuff] DOUBLE, [player_creation_modifier_movement] DOUBLE, [player_creation_modifier_control] DOUBLE, [player_creation_modifier_speed] DOUBLE, [player_creation_modifier_fielding] DOUBLE, [financial_coefficient] DOUBLE, [world_start_year] LONG, [current_date] DATETIME, [background_color_id] TEXT(8), [text_color_id] TEXT(8), CONSTRAINT [league_id] PRIMARY KEY ([league_id])); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[leagues] ([league_id] LONG, [name] TEXT(50), [abbr] TEXT(50), [nation_id] LONG,' at line 1
insert into [leagues] VALUES (100, "OS DIAMOND KINGS", "OSDK", 206, 0, 0, 0, "os_diamond_kings.png", "", "2013-4-1", "2013-4-1", "CY YOUNG AWARD", "HANK AARON AWARD", "ROOKIE OF THE YEAR AWARD", "GOLD GLOVE AWARD", 0, 0, 0, 0, 0, 0, 0, "2013-6-15", "2013-12-1", "2013-8-5", "2013-7-31", "2013-6-12", 79, 0, 0, 2, 2013, 2013, 1, 3, "", 0, 0, 0, 1, 1, 73, 74, "", "", 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 25, 40, 40, 172, 8, 21, 6, 3, 6, 0, 0, 0, 144, 3, 2, 15, 432000, 0, 610000, 710000, 1400000, 4000000, 4960000, 7800000, 11700000, 17200000, 242000, 30659, 25411765, 1420000, 22.5000, 1, 1, 0, 1, 0, 2500, 400, 300, 400, 700, 200, 1750, 3.0000, 0.3000, 125, 119, 76, 107, 125, 100, 148, 91, 0, 110, 146, 124, 122, 136, 135, 171, 148, 145, 109, 30.5639, 165000, 44000, 9500, 950, 5500, 16500, 1500, 32000, 183000, 0.3020, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 0.9870, 0.9110, 0.7940, 1.0590, 1.1180, 0.8940, 1.2590, 0.9440, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#153E7E", "#F62217"), (101, "OSDK Triple A", "OSDKAAA", 206, 0, 0, 0, "osdk_triple_a.png", "", "2013-4-19", "2013-4-15", "Outstanding Pitcher Award", "Outstanding Hitter Award", "Newcomer of the Year Award", "Glove Wizard Award", 0, 1, 0, 0, 0, 1, 0, "2013-6-15", "1981-12-1", "2013-9-1", "2013-7-31", "2013-7-17", -1, 0, 100, 2, 2013, 2013, 2, 1, "", 0, 0, 0, 1, 1, 75, 76, "iln_bgy_g140_sl1d1t6sl2d1t6_c_t12-l140.lsdl", "", 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 140, 3, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12000, 0, 0, 0.0000, 0, 0, 0, 1, 0, 3000, 500, 250, 500, 700, 200, 2000, 4.0000, 0.3000, 104, 111, 66, 90, 106, 90, 114, 69, 0, 114, 110, 151, 131, 121, 100, 169, 151, 125, 92, 29.1885, 88639, 24009, 4865, 613, 2533, 8753, 947, 18596, 98339, 0.3181, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 0.8500, 0.8000, 0.8500, 0.8500, 0.8500, 0.8500, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#FFFFFF", "#1E1E9E"), (102, "OSDK Double A", "OSDKAA", 206, 0, 0, 0, "osdk_double_a.png", "", "2013-4-19", "2013-4-15", "Outstanding Pitcher Award", "Outstanding Hitter Award", "Newcomer of the Year Award", "Glove Wizard Award", 0, 1, 0, 0, 0, 1, 0, "2013-6-15", "1981-12-1", "2013-9-1", "2013-7-31", "2013-7-17", -1, 0, 100, 2, 2013, 2013, 3, 1, "", 0, 0, 0, 1, 1, 77, 78, "iln_bgy_g140_sl1d1t6sl2d1t6_c_t12-l140.lsdl", "", 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 140, 3, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10500, 0, 0, 0.0000, 0, 0, 0, 1, 0, 3000, 500, 250, 500, 700, 200, 2000, 4.0000, 0.3000, 98, 104, 55, 75, 92, 82, 86, 53, 0, 115, 129, 124, 142, 130, 129, 160, 126, 150, 79, 26.8131, 87960, 23392, 4654, 593, 2107, 9239, 1111, 17992, 98310, 0.3137, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 0.8000, 0.7500, 0.8000, 0.8000, 0.8000, 0.8000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#FFFFFF", "#1E1E9E"), (103, "OSDK Single A", "OSDKA", 206, 0, 0, 0, "osdk_single_a.png", "", "2013-4-19", "2013-4-15", "Outstanding Pitcher Award", "Outstanding Hitter Award", "Newcomer of the Year Award", "Glove Wizard Award", 0, 1, 0, 0, 0, 1, 0, "2013-6-15", "1981-12-1", "2013-9-1", "2013-7-31", "2013-7-17", -1, 0, 100, 2, 2013, 2013, 4, 1, "", 0, 0, 0, 1, 1, 79, 80, "iln_bgy_g140_sl1d1t6sl2d1t6_c_t12-l140.lsdl", "", 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 140, 3, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9000, 0, 0, 0.0000, 0, 0, 0, 1, 0, 3000, 500, 250, 500, 700, 200, 2000, 4.0000, 0.3000, 89, 99, 48, 69, 78, 75, 63, 42, 0, 121, 90, 133, 124, 121, 104, 146, 130, 155, 69, 25.3184, 88838, 22982, 4608, 635, 1787, 8354, 1267, 19495, 98459, 0.3137, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 0.7500, 0.7000, 0.7500, 0.7500, 0.7500, 0.7500, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#FFFFFF", "#1E1E9E"), (104, "OSDK College", "OSDKCOL", 206, 0, 0, 0, "osdk_college.png", "", "2013-4-1", "2013-4-1", "ROTARY SMITH AWARD", "DICK HOWSER TROPHY", "FRESHMAN OF THE YEAR", "DEFENSIVE PLAYER OF THE YEAR", 0, 0, 0, 0, 0, 0, 0, "2013-6-15", "1981-12-1", "2013-9-1", "2013-7-31", "2014-4-26", -1, 0, 100, 2, 2013, 2013, 9, 1, "", 0, 0, 0, 1, 1, 97, 98, "", "", 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 1, 0, 35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 3, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 0, 0, 0.0000, 0, 0, 0, 1, 0, 3000, 500, 250, 500, 700, 200, 2000, 4.0000, 0.3000, 83, 90, 39, 58, 68, 67, 45, 35, 0, 113, 130, 112, 135, 121, 133, 160, 135, 138, 59, 23.8494, 165000, 44000, 9500, 950, 5500, 16500, 1500, 32000, 183000, 0.3020, 1.0500, 1.0000, 1.0000, 1.2000, 1.1000, 1.0000, 1.0000, 1.0000, 0.6000, 0.5000, 0.6000, 0.5000, 0.6000, 0.6000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#000000", "#000000"), (105, "OSDK High School", "OSDKHS", 206, 0, 0, 0, "osdk_high_school.png", "", "2013-4-1", "2013-4-1", "PITCHER OF THE YEAR", "OFFENSIVE PLAYER OF THE YEAR", "NEWCOMER OF THE YEAR", "DEFENSIVE PLAYER OF THE YEAR", 0, 0, 0, 0, 0, 0, 0, "2013-6-15", "1981-12-1", "2013-9-1", "2013-7-31", "1982-4-22", -1, 0, 100, 2, 2013, 2013, 10, 1, "", 0, 0, 0, 0, 1, 119, 120, "", "", 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40, 3, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 400, 0, 0, 0.0000, 0, 0, 0, 1, 0, 3000, 500, 250, 500, 700, 200, 2000, 4.0000, 0.3000, 34, 44, 14, 22, 27, 47, 27, 17, 0, 118, 66, 67, 65, 59, 52, 73, 49, 63, 29, 19.2649, 165000, 44000, 9500, 950, 5500, 16500, 1500, 32000, 183000, 0.3020, 1.1000, 1.1000, 1.0000, 1.2000, 1.2000, 1.0000, 1.0000, 1.0000, 0.5000, 0.4000, 0.5000, 0.4000, 0.5000, 0.5000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 1.0000, 2012, "2013-5-13", "#000000", "#000000"); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[leagues] VALUES (100, "OS DIAMOND KINGS", "OSDK", 206, 0, 0, 0, "os_diamond_kin' at line 1
... 3 queries executed
|
|