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 08-11-2011, 01:16 AM   #61
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
One more screenshot. I am sure I am doing something wrong for it to look like that.
Attached Images
Image 
almo is offline   Reply With Quote
Old 08-13-2011, 04:10 PM   #62
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,860
Blog Entries: 1
Thanks: 49
Thanked 83x in 55 posts
Another question, after every sim do you still have to load the SQL files in a particular order like you did before or can you just load them all at once? Also, what post-load functions should you run each time?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 08-13-2011, 05:23 PM   #63
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,388
Thanks: 1,852
Thanked 1,147x in 474 posts
Quote:
Originally Posted by molarmite View Post
Another question, after every sim do you still have to load the SQL files in a particular order like you did before or can you just load them all at once? Also, what post-load functions should you run each time?
You can load them in any order. Just run the season, park factors, etc afterwards.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-13-2011, 09:19 PM   #64
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,860
Blog Entries: 1
Thanks: 49
Thanked 83x in 55 posts
I tried loading the new files I uploaded, like half of them work fine but some of them have an error, I reuploaded the games.mysql.sql file but it still shows the error when I try to load it:

Loading games.mysql.sql
... 1000 queries executed
... 2000 queries executed
... 3000 queries executed
... 4000 queries executed
... 5000 queries executed
... 6000 queries executed
... 7000 queries executed
... 8000 queries executed
... 9000 queries executed
... 10000 queries executed
... 11000 queries executed
... 12000 queries executed
... 13000 queries executed
insert into `games` VALUES (1, 103, 191, 198, 5685, "2011-3-31", 1800, 0, 1, 0, 9, 4, 1, 9, 3, 2, 0, 31905, 24215, 32250, 31905, 24215); -> Duplicate entry '1' for key 'PRIMARY'
insert into `games` VALUES (2, 103, 196, 194, 5413, "2011-3-31", 1835, 0, 1, 0, 9, 1, 3, 7, 8, 0, 0, 30308, 31031, 33580, 31031, 30308); -> Duplicate entry '2' for key 'PRIMARY'
insert into `games` VALUES (3, 103, 189, 192, 5710, "2011-3-31", 1835, 0, 1, 0, 9, 0, 3, 1, 5, 0, 1, 32720, 30551, 26035, 30551, 32720); -> Duplicate entry '3' for key 'PRIMARY'
insert into `games` VALUES (4, 103, 197, 195, 5576, "2011-3-31", 1900, 0, 1, 0, 9, 3, 4, 8, 9, 1, 1, 31185, 25992, 18853, 25992, 31185); -> Duplicate entry '4' for key 'PRIMARY'
insert into `games` VALUES (5, 103, 193, 187, 6160, "2011-3-31", 1905, 0, 1, 0, 9, 11, 2, 15, 7, 0, 1, 35120, 27006, 0, 35120, 27006); -> Duplicate entry '5' for key 'PRIMARY'
insert into `games` VALUES (6, 103, 190, 188, 5587, "2011-3-31", 1905, 0, 1, 0, 9, 1, 5, 9, 6, 0, 0, 31680, 27181, 0, 27181, 31680); -> Duplicate entry '6' for key 'PRIMARY'
insert into `games` VALUES (7, 103, 191, 198, 1954, "2011-4-1", 1800, 0, 1, 0, 9, 5, 2, 6, 4, 0, 1, 19207, 19553, 32250, 33208, 19553); -> Duplicate entry '7' for key 'PRIMARY'
insert into `games` VALUES (8, 103, 196, 194, 3014, "2011-4-1", 1835, 0, 1, 0, 10, 5, 6, 12, 12, 0, 1, 35148, 25903, 0, 30769, 31399); -> Duplicate entry '8' for key 'PRIMARY'
insert into `games` VALUES (9, 103, 190, 188, 2925, "2011-4-1", 1835, 0, 1, 0, 10, 1, 2, 6, 6, 0, 1, 33296, 30840, 0, 27612, 33568); -> Duplicate entry '9' for key 'PRIMARY'
insert into `games` VALUES (10, 103, 189, 192, 3115, "2011-4-1", 1835, 0, 1, 0, 9, 3, 10, 7, 9, 2, 2, 30194, 23193, 0, 23193, 30194); -> Duplicate entry '10' for key 'PRIMARY'
insert into `games` VALUES (11, 103, 197, 195, 3065, "2011-4-1", 1900, 0, 1, 0, 11, 5, 6, 11, 12, 0, 1, 31310, 26544, 0, 32636, 27497); -> Duplicate entry '11' for key 'PRIMARY'
insert into `games` VALUES (12, 103, 193, 187, 3073, "2011-4-1", 1905, 0, 1, 0, 9, 2, 10, 5, 10, 0, 0, 27636, 30478, 0, 30478, 27636); -> Duplicate entry '12' for key 'PRIMARY'
insert into `games` VALUES (13, 103, 191, 198, 3195, "2011-4-2", 1300, 0, 1, 0, 9, 5, 3, 12, 8, 2, 0, 19207, 23145, 32250, 31908, 23145); -> Duplicate entry '13' for key 'PRIMARY'
insert into `games` VALUES (14, 103, 196, 194, 3212, "2011-4-2", 1305, 0, 1, 0, 9, 5, 3, 9, 5, 1, 0, 25022, 27861, 25903, 30778, 32695); -> Duplicate entry '14' for key 'PRIMARY'
insert into `games` VALUES (15, 103, 193, 187, 3409, "2011-4-2", 1305, 0, 1, 0, 9, 7, 3, 14, 8, 0, 1, 32098, 22880, 0, 32098, 23276); -> Duplicate entry '15' for key 'PRIMARY'
insert into `games` VALUES (16, 103, 189, 192, 3441, "2011-4-2", 1335, 0, 1, 0, 9, 18, 6, 18, 9, 0, 3, 24427, 26037, 0, 24427, 26037); -> Duplicate entry '16' for key 'PRIMARY'
insert into `games` VALUES (17, 103, 190, 188, 3315, "2011-4-2", 1835, 0, 1, 0, 9, 1, 9, 4, 10, 1, 1, 26863, 26173, 0, 26173, 26863); -> Duplicate entry '17' for key 'PRIMARY'
insert into `games` VALUES (18, 103, 197, 195, 3319, "2011-4-2", 1900, 0, 1, 0, 9, 2, 4, 6, 9, 1, 1, 25073, 32637, 31310, 23548, 31233); -> Duplicate entry '18' for key 'PRIMARY'
insert into `games` VALUES (19, 103, 191, 198, 3230, "2011-4-3", 1300, 0, 1, 0, 9, 2, 4, 4, 10, 0, 0, 32261, 19377, 28569, 23272, 32261); -> Duplicate entry '19' for key 'PRIMARY'
insert into `games` VALUES (20, 103, 196, 194, 2982, "2011-4-3", 1305, 0, 1, 0, 9, 7, 1, 12, 7, 0, 0, 24700, 26128, 0, 24700, 26128); -> Duplicate entry '20' for key 'PRIMARY'
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 08-13-2011, 09:20 PM   #65
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
Trying to run our amateur draft with statslab 12, no issues until now. Have this message on draftboard (Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/osdkootp/public_html/StatsLab/draftReport.php on line 189) and get the player not draft eligible when manger tries to make the first overall pick? Contacted Fhmoss just on and logged right off
HustlinOwl is offline   Reply With Quote
Old 08-13-2011, 09:36 PM   #66
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
Quote:
Originally Posted by fhomess View Post
There aren't any players in the StatsLab draft list. Try the following:
1. Log in as one of your GM's.
2. Go to the team's draft warroom, and add a player to their draft list.
3. Save the draft list.
4. Remove the player from the draft list, and save again.
5. Go to the draft admin page, and click the generate auto draft list button.
6. Try drafting the players manually.
Got doing this
Quote:
Originally Posted by HustlinOwl View Post
Trying to run our amateur draft with statslab 12, no issues until now. Have this message on draftboard (Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/osdkootp/public_html/StatsLab/draftReport.php on line 189) and get the player not draft eligible when manger tries to make the first overall pick? Contacted Fhmoss just on and logged right off
HustlinOwl is offline   Reply With Quote
Old 08-16-2011, 01:35 AM   #67
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,459
Thanks: 168
Thanked 1,184x in 443 posts
Hi all,

I've been on vacation with only intermittent internet access. Here are some responses.

Quote:
Originally Posted by molarmite View Post
Two questions: For the export tracker, it says "/game/lgexports/vMLB.lg.tar.gz" because my file is vMLB.tar.gz, how do I stop it from assuming there's a .lg at the end?
On the StatsLab Admin screen, under Export Tracker settings, in the League Name field, enter vMLB.tar.gz, and StatsLab will use that extension rather than the old OOTP11 default of .lg.

Quote:
Originally Posted by molarmite View Post
What SQL files do I have to upload after every sim and which ones every year, etc.?
The ones with "history" in the name are only needed every year. The rest of the ones specified in the read me are needed after every sim.

Quote:
Originally Posted by cody8200 View Post
I can only answer the second part. You need to upload all SQL files needed ( the ones listed in the PDF) after every sim. Should only be 10 megs or so when zipped up. You need to run everything except for career metrics and player development and similarity scores after every sim. Run all 3 on the last day of the baseball year (before the end of the actual year)
No. Development should be run whenever you want to see that updated. Run Career Position, Park Factors, Season Metrics after every sim. The others are only needed at the end of the year. FWIW, Win Share can be run whenever, but don't really make sense until the season is completed.

Quote:
Originally Posted by almo View Post
Does Statslab work in a scouting league? I watched one of the videos fidel put together on how to install StatsLab, but about 1 min in he said something about how if you are in a scouting league, that statslab is not applicable. Is this true? If so, are there other tools and utilities that mirror it?
StatsLab can't handle player ratings in a scouted league, however there are plenty of features in StatsLab you can still use. You can hide the ratings easily from the StatsLab admin page.

Quote:
Originally Posted by almo View Post
Hello..I got through the installation of stats lab...its just that my screens look weird. Is this how everybody elses looks?
The path to your league HTML is incorrect in your StatsLab admin screen.

Quote:
Originally Posted by molarmite View Post
Another question, after every sim do you still have to load the SQL files in a particular order like you did before or can you just load them all at once? Also, what post-load functions should you run each time?
You can load the SQL files in any order after initial installation. By default, StatsLab loads them alphabetically.

Quote:
Originally Posted by molarmite View Post
I tried loading the new files I uploaded, like half of them work fine but some of them have an error, I reuploaded the games.mysql.sql file but it still shows the error when I try to load it:
Does your games.mysql.sql file have a line at the top to DROP the table and then to CREATE the table? If not, check those options in the OOTP12 SQL configuration. They're new to OOTP12.
__________________
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 09-12-2011, 01:01 PM   #68
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Frank, do you happen to have any updates on development progress?
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 09-12-2011, 05:19 PM   #69
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 BleedingCubbyBlue View Post
Frank, do you happen to have any updates on development progress?
Honestly, I haven't taken any time to work on it in about 3 weeks, and by "it", I mean StatsLab in general. Given things going on in my real world, I can't really give any sort of ETA at this point.
__________________
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 09-13-2011, 06:43 PM   #70
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 fhomess View Post
Honestly, I haven't taken any time to work on it in about 3 weeks, and by "it", I mean StatsLab in general. Given things going on in my real world, I can't really give any sort of ETA at this point.
Understood. Thanks for the reply.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 09-25-2011, 09:07 AM   #71
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,269
Thanks: 38
Thanked 130x in 71 posts
Okay, I'm probably being dense, but I cannot figure this out.

I followed the directions exactly the same way I did for 11. pre-patch 2 for StatsLab. Everything looks okay visually on the StatsLab site. However, for whatever reason, when I go to set up the first development tables, I am getting time out errors before I can accomplish anything -- even if I limit the request to, say, A league pitching ratings... Related to this, I had far more trouble with time out errors when loading SQL files -- for the first time ever, I had to split them, and they are exactly the same size as they were back in OOTP 11, so this makes no sense to me.

However, I notice documentation for a patch 2 in with the StatsLab directions, and so I am guessing that the patch is where things in StatsLab might be adjusted to OOTP 12. However, I see no patch 2 in the zip file download. Nor do I see a conversion2-2.php file.

So I am stuck. Either I have done the correct installation but time out errors are preventing me from using the development tracker OR there is an important patch that I am not finding.
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball

Last edited by beorn; 09-25-2011 at 09:16 AM.
beorn is offline   Reply With Quote
Old 11-14-2011, 10:17 AM   #72
griffeyin98
Major Leagues
 
Join Date: Jun 2006
Posts: 312
Thanks: 2
Thanked 5x in 5 posts
I'm guessing this will be an easy fi and I entered somethign wrong, but when I go to the exports page for my league, it says

ERROR: No League File Found at: "http://www.mtblcentral.com/league_files/MTBL12.tar.gz"

but that's exactly where the league file is located, if you grab just the url portion, it'll download our league file. any ideas what I did wrong?
griffeyin98 is offline   Reply With Quote
Old 11-14-2011, 03:38 PM   #73
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,388
Thanks: 1,852
Thanked 1,147x in 474 posts
What do your export tracker settings look like in the admin tab?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 11-14-2011, 03:49 PM   #74
griffeyin98
Major Leagues
 
Join Date: Jun 2006
Posts: 312
Thanks: 2
Thanked 5x in 5 posts
League Name: mtbl12.tar.gz
League File Path: Index of /league_files
Export file path /league_files
griffeyin98 is offline   Reply With Quote
Old 11-15-2011, 11:41 PM   #75
ootpFox07
All Star Starter
 
ootpFox07's Avatar
 
Join Date: Dec 2005
Posts: 1,636
Thanks: 1,220
Thanked 570x in 287 posts
Frank,
I know I say this everytime I run a post-season for my solo league, but once again, thank you for StatsLab and the Playoff summary. This used to take me long hours to produce manually and it's time I can enjoy doing things like teasing my brow, cleaning my wife and daughters hair from the sink drains and browsing historical team graphs. Thanks man!
__________________
Mods:
ootpFox07 is offline   Reply With Quote
Old 12-06-2011, 02:15 PM   #76
thickman1
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
Quote:
Originally Posted by HustlinOwl View Post
Trying to run our amateur draft with statslab 12, no issues until now. Have this message on draftboard (Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/osdkootp/public_html/StatsLab/draftReport.php on line 189) and get the player not draft eligible when manger tries to make the first overall pick? Contacted Fhmoss just on and logged right off
Does anyone know if this has been fixed or addressed?
thickman1 is offline   Reply With Quote
Old 12-13-2011, 10:08 PM   #77
Whitesnake
Bat Boy
 
Join Date: Oct 2006
Posts: 15
Thanks: 0
Thanked 0x in 0 posts
StatsLab12 Career Metrics Problem

Quote:
Originally Posted by cody8200 View Post
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
I'm getting the same problem when I run career metrics at the end of the season after installing StatsLab. Career metrics worked perfectly on the initial SQL upload. Any idea how I can fix this?

Love StatsLab!!!

- Bill
Whitesnake is offline   Reply With Quote
Old 12-26-2011, 06:33 PM   #78
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,363
Thanks: 69
Thanked 688x in 399 posts
Can anyone who's updated v11 with v12 tell me if it overwrites all of your settings? I'd like to know before I update.
Cooleyvol is offline   Reply With Quote
Old 12-27-2011, 05:25 PM   #79
USF
All Star Reserve
 
USF's Avatar
 
Join Date: Oct 2011
Location: Maple, ON - Canada
Posts: 821
Thanks: 254
Thanked 137x in 106 posts
StatsLab V12

Thank you for creating this utility.

It took me a while to get it to work but, I'm set now.

I am getting one error in the draft utility. If anyone can help it would be appreciated!



Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web118/b1183/ipg.usfleaguesnet/ootpsl/draftWarroom.php on line 438


Thanks!
Jason

Last edited by USF; 12-31-2011 at 10:07 PM.
USF is offline   Reply With Quote
Old 12-27-2011, 08:45 PM   #80
eMLBCommish
All Star Reserve
 
eMLBCommish's Avatar
 
Join Date: Mar 2003
Posts: 618
Thanks: 6
Thanked 17x in 11 posts
Quote:
Originally Posted by Cooleyvol View Post
Can anyone who's updated v11 with v12 tell me if it overwrites all of your settings? I'd like to know before I update.
Mark,

What I've done is read the instructions, and removed anything that would update settings. (IE config.txt) So far, so good.

But I only did this yesterday with one SQL dump to update my new members to be included. Not sure the next time I do a dump if it'll still work.
__________________
Member of SimNation
eMLBCommish 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 12:45 AM.

 

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