Home | Webstore
Latest News: OOTP Update 20.8 - OOTP 20 Available - FHM 6 Available

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 03-12-2012, 09:03 AM   #101
Solonor
Hall Of Famer
 
Solonor's Avatar
 
Join Date: Mar 2003
Location: Maine
Posts: 4,413
Thanks: 300
Thanked 179x in 107 posts
Quote:
Running Career metrics in 12 always results in an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/career.php on line 160

Warning: Cannot modify header information - headers already sent by (output started at /home/ootpbeli/public_html/StatsLab/career.php:160) in /home/ootpbeli/public_html/StatsLab/career.php on line 229
Same problem here. Anyone figure out the issue?
__________________
Solonor's Groovy Computer Baseball League - Making baseball a hobbit since 2003!

"Beings will come, Frodo. The one constant through all the years has been baseball. Middle Earth has rolled by like an army of Mumakil. It has been erased like a slate, rebuilt and erased again. But baseball has marked the time. This field, this game: it's a part of our past, Frodo. It reminds of us of all that once was good and it could be again. Oh... beings will come Frodo. Beings will most definitely come." - Gladden Field of Dreams
Solonor is offline   Reply With Quote
Old 03-27-2012, 02:11 PM   #102
pallison14
Major Leagues
 
pallison14's Avatar
 
Join Date: Mar 2002
Posts: 452
Thanks: 33
Thanked 23x in 11 posts
Will there be an update for leagues converting to v13 (when it becomes available)?
__________________
Commissioner, NGBL - Putting the FUNK in defunct.

New York (AL), UBL
pallison14 is offline   Reply With Quote
Old 04-10-2012, 12:46 AM   #103
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
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
HustlinOwl is offline   Reply With Quote
Old 04-10-2012, 12:28 PM   #104
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,459
Thanks: 168
Thanked 1,184x in 443 posts
Quote:
Originally Posted by pallison14 View Post
Will there be an update for leagues converting to v13 (when it becomes available)?
Eventually. For now, the current version will have to do.

Quote:
Originally Posted by HustlinOwl View Post
hoping to get some help here, have been going 3 years strong and all of a sudden getting this when loading the SQL files
You generated the SQL dump for Access rather than MySQL.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 04-14-2012, 09:26 PM   #105
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
Quote:
Originally Posted by fhomess View Post
You generated the SQL dump for Access rather than MySQL.
nevermind fixed it

Last edited by HustlinOwl; 04-15-2012 at 02:29 AM.
HustlinOwl is offline   Reply With Quote
Old 04-18-2012, 11:50 AM   #106
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
is there a way to edit picks for each round (besides supplemental) in my amateur draft. I can get to stick through PHP admin, but through statslab timer and dates dont match
HustlinOwl is offline   Reply With Quote
Old 05-05-2012, 04:45 AM   #107
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Do you know of any reason why I would get the following error in the Export Tracker?

ERROR: No League File Found at: "/pcjbl.com/your-league/files/Peanuts_And_CrackerJacks.tar.gz"

The file is there and on the same server as StatsLab.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 05-05-2012, 03:34 PM   #108
Killebrew
Hall Of Famer
 
Killebrew's Avatar
 
Join Date: Dec 2001
Posts: 3,326
Thanks: 120
Thanked 50x in 25 posts
Is anyone using Statslab12 succesfully in OOTP13 yet? We're seeing no dev changes since we moved to OOTP13. The MySQL files are loading no problem, and the pre-OOTP13 dev is still there, just no new dev.

Update/Edit: The OOTP13 dev seems to be working now, in case anyone is checking this thread about that.

Last edited by Killebrew; 05-10-2012 at 04:17 AM.
Killebrew is offline   Reply With Quote
Old 05-05-2012, 04:00 PM   #109
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by Killebrew View Post
Is anyone using Statslab12 succesfully in OOTP13 yet? We're seeing no dev changes since we moved to OOTP13. The MySQL files are loading no problem, and the pre-OOTP13 dev is still there, just no new dev.
We just started PCJBL as a new OOTP13 league and although things appear to have loaded I'm having some various issues (like the export tracker not working). Dev doesn't appear to be working, but out league is only 1 sim in.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Thank you for this post:
Killebrew (05-05-2012)
Old 05-08-2012, 11:21 AM   #110
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by dangarion View Post
Do you know of any reason why I would get the following error in the Export Tracker?

ERROR: No League File Found at: "/pcjbl.com/your-league/files/Peanuts_And_CrackerJacks.tar.gz"

The file is there and on the same server as StatsLab.
Try /your-league/files/ instead and Peanuts_And_CrackerJacks for League Name
__________________


Last edited by BleedingCubbyBlue; 05-08-2012 at 11:23 AM.
BleedingCubbyBlue is offline   Reply With Quote
Old 05-08-2012, 11:24 AM   #111
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by BleedingCubbyBlue View Post
Try /your-league/files/Peanuts_And_CrackerJacks.tar.gz insead.
I tried about 6 different folder locations including the one you suggested.

I even tried ../ before and other options wondering if it was looking at root or needed to be kicked out of the folder it was in and down a directory.

Still no dice.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 05-09-2012, 11:10 AM   #112
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by dangarion View Post
I tried about 6 different folder locations including the one you suggested.

I even tried ../ before and other options wondering if it was looking at root or needed to be kicked out of the folder it was in and down a directory.

Still no dice.
Looks like I edited after you saw my post.

Try /your-league/files/ instead and Peanuts_And_CrackerJacks for League Name
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 05-09-2012, 11:33 AM   #113
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by BleedingCubbyBlue View Post
Looks like I edited after you saw my post.

Try /your-league/files/ instead and Peanuts_And_CrackerJacks for League Name
Let me see if that works.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!

Last edited by dangarion; 05-09-2012 at 11:35 AM.
dangarion is offline   Reply With Quote
Old 07-12-2012, 10:42 PM   #114
trendon
Minors (Single A)
 
Join Date: Jul 2009
Posts: 94
Thanks: 28
Thanked 36x in 6 posts
Help needed.

I foolishly deleted all of the contents of my dump folder and I tried to start over by going to install.php. However, it is not creating the dbopen file that I need. Can I simply create it myself and drop it in there?
trendon is offline   Reply With Quote
Old 07-12-2012, 10:55 PM   #115
trendon
Minors (Single A)
 
Join Date: Jul 2009
Posts: 94
Thanks: 28
Thanked 36x in 6 posts
OK, that works, but now ...

ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

I don't recall needing to create that last time so I assume it is automatic.
trendon is offline   Reply With Quote
Old 10-27-2012, 01:28 PM   #116
gollum65
All Star Reserve
 
Join Date: Feb 2007
Posts: 924
Thanks: 18
Thanked 13x in 10 posts
Hiya. I'm attempting to install Statslab 12 to use with an OOTP 13 league that I'm in the process of starting up. I've followed the installation instructions step by step. I'm at step 10, Configure StatsLab General Settings.

The first time I pull up the admin.php page I get a page with the correct buttons and fields so I know a valid connection to the sql database exists. But if I enter any settings and hit SAVE at the bottom I get the following error page:

Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 18


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: mysql_error() expects parameter 1 to be resource, null given in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 55


Warning: Cannot modify header information - headers already sent by (output started at /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php:18) in /home/xyzxyz/public_html/old_TIMERS_Statslab/save_admin.php on line 64

So what am I missing? What did I do wrong? I should also note that over the years since Statslab came out I've tried on a few occasions to install it and have always had these types of issues. I was hoping a newer version of Statslab would work for me as I'd really like to use it. I've used it in other leagues and it's great.

Thanks in advance.
__________________
OOTP X Beta Team

Last edited by gollum65; 10-27-2012 at 01:29 PM.
gollum65 is offline   Reply With Quote
Old 10-29-2012, 11:23 AM   #117
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,459
Thanks: 168
Thanked 1,184x in 443 posts
You actually aren't getting a valid connection to your MySQL database. I've sent you a PM.

Also, please note that there are minor SQL changes to the database dump that make StatsLab12 incompatible with OOTP13.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 06-15-2017, 08:23 AM   #118
patrickisonfire
Bat Boy
 
Join Date: Jun 2017
Posts: 6
Thanks: 0
Thanked 1x in 1 post
Cpu control

Quote:
Originally Posted by BobDylanRH View Post
I've got a team showing up as CPU controlled when they are not. Because of it, the owner can't use his team with StatsLab. Anyone else seen this?
Hey dude. Did you end up getting this issue fixed? Im having the same problem.
patrickisonfire is offline   Reply With Quote
Old 06-21-2017, 02:15 PM   #119
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,459
Thanks: 168
Thanked 1,184x in 443 posts
Quote:
Originally Posted by patrickisonfire View Post
Hey dude. Did you end up getting this issue fixed? Im having the same problem.
Shoot me a PM with details and I'll help you out. I don't recall the original concern quoted, but a couple of similar issues I've seen in the past were because a GM was added and the MySQL data in StatsLab wasn't yet updated.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 05:20 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments