Historical Database Issues Go Here

[luckymann]

Originally Posted by LansdowneSt

The game no longer uses the Debut Year field in the Master.csv to determine the import year. It looks for stat lines and apparently not fielding-only ones which they have in the db properly. I can add an all zeroes batting line to each and see if that helps. AESP has reported similar issues with one-off earlier guys.

OK, gotcha. So does that mean Littlejohn should come in for '79 and Ramos for '80?

G

[LansdowneSt]

Originally Posted by luckymann

OK, gotcha. So does that mean Littlejohn should come in for '79 and Ramos for '80?

G

Yup

[AESP_pres]

Yeah that happens when a player didn't have an AB his first year (so just a defensive replacement or a pinch runner who didn't score)... not every players but it's always those players.

[luckymann]

Great, thanks lads.

G

[QBL]

At minimun 2017, may be other years too, the incorrect playoff structure is the default.

[Caridnals-BK]

Craig Worthington (worthcr01) is listed as caucausian, but is of Hawaiian-Indian and Mexican descent.

Baltimore Sun, October 3, 1989

[LansdowneSt]

Originally Posted by omg_pwnasaurus

Here's the top 15 names I found (this is from a save starting from 1981 if it matters). I think part of the problem is maybe with the advanced stats the fastballs got degraded cosmetically and to compensate so that the overalls still reflect star quality, it propped up the secondary pitches to the point where it can still retain the previous stuff ratings?

In any event, here's what I found:

1. Dwight Gooden (in 1981 he's created for draft pool) - In version '26, FB/CB best pitches (80/85 pot respectively), In version '27 SL/CU best pitches and FB/CB now average or below

2. Bert Blyleven previously had 75 CB potential now 50, curveball was legendary

3. Nolan Ryan - Fastball now worst pitch in '27

4. David Cone - Fastball now worst pitch in '27

5. Rich Gossage - Fastball now worst pitch in '27

6. Mario Soto - Changeup and Slider should be reversed, best changeup of the 1980's

7. Steve Carlton - Slider and Curveball should be reversed

8. Lee Smith - Has average fastball in '27

9. Bruce Sutter - Splitter and Slider should be reversed

10. Tom Candiotti - Knuckleball is now worst pitch

11. Ron Guidry - Slider and Changeup should be reversed

12. J.R. Richard - Fastball now worst pitch

13. Dave Stieb - Slider now worst pitch, arguably best slider of 1980s

14. Mike Witt - Curveball and Changeup should be reversed

15. Mike Boddicker - Curveball and Forkball should be reversed


Thanks!

This is directly related to the fix in the new patch (27.2.56). It never stopped being looked at even after our discussion trailed off.

[LansdowneSt]

Originally Posted by Caridnals-BK

Craig Worthington (worthcr01) is listed as caucausian, but is of Hawaiian-Indian and Mexican descent.

Baltimore Sun, October 3, 1989

Went East Indian. I'll see if I have a facegen file for him and try to make it so it doesn't even matter for many...

[omg_pwnasaurus]

Originally Posted by LansdowneSt

This is directly related to the fix in the new patch (27.2.56). It never stopped being looked at even after our discussion trailed off.

Awesome! Yeah I wasn't sure if the back and forth here was monitored that way since I didn't really officially post it in a bug report. The dev team rules.

[tiax]

1874 and 1875 Strikeouts


There is some sort of data entry issue with pitcher strikeouts in 1874 and 1875. An instructive example is Dan Collins (collida01), who is credited with 18 Ks in 11 IP in 1874. This gives him a K/9 of 14.7. In reality, Dan Collins had zero strikeouts in 1874 (here are newspaper reports of his two appearances: https://imgur.com/yyh97aS and https://imgur.com/AchIlf0).


Fangraphs has the same strikeout values as OOTP, which makes it easier to see the issue:


https://www.fangraphs.com/leaders/ma...n1=1874&qual=0


Everyone has a strikeout total of 10,11,12 through 18. While Dan Collins is an easily-observed example, it seems that every pitcher's SO count is incorrect. This leads to high-IP pitchers having a terrible K/9 and the Dan Collins of the world having an amazing K/9 (and correspondingly amazing in-game Stuff rating)


Baseball Reference has what appear to be the real numbers:


https://www.baseball-reference.com/l...pitching.shtml
Note that BR's data has 357 SO recorded by batters and 357 Ks thrown by pitchers. Fangraph's data (and similarly OOTP) has 345 batter SO, but only 192 pitcher Ks.


A similar problem occurs in 1875 - all pitchers have SO counts between 6 and 26. George Wright is credited, for example, with 11 K in 4 innings pitched.


As far as I can tell, the BR strikeout numbers for these seasons are basically correct (up to the general uncertainty of 1870s stats) and the FanGraphs/OOTP numbers are just all in error.

EDIT: Also, note that I'm still on '26, so I apologize if this has already been resolved.

[LansdowneSt]

Looks like I will need to go and edit each pitcher for each year. Glad it is 1874 & 1875 and not a later year. Those years are at least a manageable number of pitchers to go through. I'll post here when the edits are complete. One complete, the next patch that generates a new database will have all the BBR numbers in it, so it will then be corrected at the OOTP main database and there will be no need for you to use Dr Dooms tool and manually do it.