|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
01-07-2011, 02:32 PM | #1 |
Minors (Triple A)
Join Date: Jun 2003
Posts: 226
|
Error when hitting "Load SQL Files"
Not sure how come I am getting the same error over and over. I followed the directions that I was given on here but obviously I am missing something.
After I upload the reports, I go into my import/export folder and copy all the SQL files and open FTP (CyberDuck Mac) and drag it to the /sqldump folder. Once its finished uploading I go into the StatsLab Admin function and hit Load SQL Dump and I get the following error: ERROR: Error loading SQL tables. Please see /home/paramoun/sqldump/sqlloadlog.txt for details When I go there, I don't really know what I am looking for, but here is a copy of that load, everything looks Successful to me but the files won't update like last box score is 2 weeks old: _______________________________________________ LOADING: cities.mysql.sql ... SUCCESSFUL! Processing took 7 seconds LOADING: coaches.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: divisions.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: games.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: games_score.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: human_manager_history.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_manager_history_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_manager_history_fielding_stats_stats.mysql.s ql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_manager_history_financials.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_manager_history_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_manager_history_record.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: human_managers.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_events.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_history.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_history_all_star.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_history_batting_stats.mysql.sql ... 2 insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 87032, 77965, 20783, 15309, 0, 0, 4131, 388, 2560, 1541, 542, 0, 10938, 7694, 0, 725, 0, 648, 0, 0, 2270, 0, 7079, 0, 0.2666, 0.3355, 0.4280, 11961.8121, 5.5329, 0.1614, inf, 0.7635, 73.9798, 0.0000, 0.0000); -> Unknown column 'inf' in 'field list' insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 98393, 87884, 22741, 18282, 0, 0, 4606, 561, 2482, 1429, 591, 0, 11481, 8926, 0, 865, 0, 718, 0, 0, 2590, 0, 7649, 0, 0.2588, 0.3306, 0.4087, 12755.6118, 5.1827, 0.1499, inf, 0.7393, 70.7426, 0.0000, 0.0000); -> Unknown column 'inf' in 'field list' LOADING: league_history_fielding_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_history_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_playoff_fixtures.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: league_playoffs.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: leagues.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: nations.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: parks.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: players.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: players_at_bat_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 5 seconds LOADING: players_awards.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: players_batting.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_career_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: players_career_fielding_stats.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_career_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: players_contract.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_contract_extension.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_fielding.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: players_game_batting.mysql.sql ... SUCCESSFUL! Processing took 5 seconds LOADING: players_game_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 6 seconds LOADING: players_individual_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 6 seconds LOADING: players_league_leader.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: players_pitching.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_roster_status.mysql.sql ... SUCCESSFUL! Processing took 2 seconds LOADING: players_streak.mysql.sql ... SUCCESSFUL! Processing took 4 seconds LOADING: players_value.mysql.sql ... SUCCESSFUL! Processing took 3 seconds LOADING: sub_leagues.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_affiliations.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_bullpen_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_fielding_stats_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_financials.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_history.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_history_batting_stats.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: team_history_fielding_stats_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_history_financials.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_history_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: team_history_record.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_last_financials.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_record.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_relations.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_roster.mysql.sql ... SUCCESSFUL! Processing took 1 seconds LOADING: team_roster_staff.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: team_starting_pitching_stats.mysql.sql ... SUCCESSFUL! Processing took 0 seconds LOADING: teams.mysql.sql ... SUCCESSFUL! Processing took 0 seconds Done Loading SQL Files: 61 files loaded in 70 seconds
__________________
Commissioner: Paramount Baseball League (running7-years real time) American Baseball Legion (a new OOTP18 Startup) Last edited by Dbobola22; 01-07-2011 at 02:33 PM. |
01-11-2011, 02:16 PM | #2 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
The league history batting stats file is the one with the error and it's because a division by 0 is causing it to report "inf" in a field that should be numeric. This is an OOTP bug.
Fortunately, you don't need this file for StatsLab. I'd encourage you (and all StatsLab users) to limit their SQL dumps to just the files required by StatsLab. They're listed at the very end of the StatsLab ReadMe. There are some small SQL bugs in other files, too, but I've only coded around the ones that StatsLab uses.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
Bookmarks |
|
|