Historical database issues go here!

[Daniel_09]

Look at the following examples where the players have no major league experience, but already have more than 1 year of service time, major league contract, etc....

These screenshots were taken with the updated version of the game on steam.

[ZouDave]

I've done this with 2 different leagues now, and I've had the same result but with different players.

Both leagues were historical imports starting in 1921 with full history for MLB and Negro Leagues and Minors imported. Everything set to import new rookies each year, auto-expand, etc. Both leagues with no human controls, me set to commish, and just sim to March 27, 2023.

In first test league, player Frank Burt is the issue.

Historical ID burtfr01
BBRef ID burtfr01
Historical Minors ID burt--001fra

He has OSA ratings on 1/1 of each year in his history starting in 1922 to 1930, then starts signing with minor league teams every year, sometimes multiple times per year, until about 1954 when he starts playing Major League games. By 1958, he's starting 35+ games every year as a SP until 2019. Then he converts to a RP and pitches in 42-75 games each year between 2019-2022. In 2019, it shows he's 19 years old. His age showed 0 until 2004 when he turned 1. His career numbers are off the charts. He has every pitching record imaginable. His Major League Service is over 72 years.

In 2nd test league, the culprit is John Dwyer

Historical ID dwyerjo01
BBRef ID dwyerjo01
Historical Minors ID dwyer-001joh

VERY similar story, only this time as a Catcher. Started playing MLB games in 1944, is now 19 in 2022. His Major Service is 86 years.

Happy to upload screenshots if you need them, let me know what else you want to know.

[Lukas Berger]

Originally Posted by szathkey

Hi all,

Are these DB issues being worked on for the next patch? Unfortunately, my OCD will not allow me to start a historical season until hometowns are fixed. I know I this may seem bonkers, but that's where I am at...any info would be appreciated.

The random db issues yes, but not especially hometowns right now.

I can try to move those up the list a bit though and get to them sooner rather than later. May need some coding changes as well, but hopefully those should not be too onerous.

Lost a couple days already this week though with a flu/covid/fever Thankfully sort lived though, as I'm already feeling better and back at it.

[Zitofan75]

Here's a player named Jim Matthews. A career minor leaguer, his stats caught my eye when in 1953 he's supposedly hit 50 HR's with only 29 RBI's. According to BR, he did hit 50 HR's for Amarillo that year but his RBI totals should come out to 152. I then noticed he was also supposed to have driven in 29 runs for multiple seasons; in reality he never had a purely 29 RBI year.

[Lukas Berger]

Originally Posted by ZouDave

Historical ID burtfr01
BBRef ID burtfr01
Historical Minors ID burt--001fra
...
Historical ID dwyerjo01
BBRef ID dwyerjo01
Historical Minors ID dwyer-001joh

Both these guys are fixed up now.

[Zitofan75]

Originally Posted by Zitofan75

Here's a player named Jim Matthews. A career minor leaguer, his stats caught my eye when in 1953 he's supposedly hit 50 HR's with only 29 RBI's. According to BR, he did hit 50 HR's for Amarillo that year but his RBI totals should come out to 152. I then noticed he was also supposed to have driven in 29 runs for multiple seasons; in reality he never had a purely 29 RBI year.

His ID is matthe006jam

[Lukas Berger]

Originally Posted by Zitofan75

His ID is matthe006jam

He's missing RBI totals for a lot of those years, so we have to make those up. Obviously 29 is not a reasonable number to use for most of those years though. Dunno how that happened

[Lukas Berger]

Originally Posted by Zitofan75

His ID is matthe006jam

Originally Posted by Lukas Berger

He's missing RBI totals for a lot of those years, so we have to make those up. Obviously 29 is not a reasonable number to use for most of those years though. Dunno how that happened

Ok, mostly fixed this up now.

[szathkey]

Thanks Lukas...sorry to hear you were sick, but glad you are feeling better! I'm not sure why it bothers me as much as it does. I fully realize it shouldn't...The human mind is an interesting thing!

[Lukas Berger]

Originally Posted by szathkey

Thanks Lukas...sorry to hear you were sick, but glad you are feeling better! I'm not sure why it bothers me as much as it does. I fully realize it shouldn't...The human mind is an interesting thing!

Oh, I understand completely. It bothers me a lot too tbh.

The problem is with all the work on the historical db merger this year, it was a given not 100% of everything would be 100% ready by release and so we had to try to pick the things that would hopefully irritate the lowest amount of folks the least. Hopefully succeeded in that to some extent at least, even if not perfectly

[Daniel_09]

Thanks Lukas, I hope the bug in the service time of some players in Historical Data can be fixed in the next 2 or 3 builds.

Matt already replied in another thread that they have a fix for the problem.

[Scipio Africanus]

Lukas, is the database merger work likely to be concluded in the next few weeks/months or is this a more long-term (multi-year) project?

[Lukas Berger]

Originally Posted by Scipio Africanus

Lukas, is the database merger work likely to be concluded in the next few weeks/months or is this a more long-term (multi-year) project?

I mean, it's concluded already. Just a matter of smoothing out any resulting bugs which should be more weeks/months than anything too long-term.

[Jays Fan]

Please forgive if this is already here but I've looked and don't see it posted. I have a fictional game, scouting off (i.e. 100% accuracy), into which I like to manually import some historical players each year. I normally manually import players from the historical database using the ID, and was doing so for the year 1967, usually the players from the year ahead so in this case 1968. Never had any issue before. Settings using Neutralized stats, Peak Seasons of Career, Fielding Ratings based on Entire Career, Pitcher Stamina Entire Career. When I've been doing this in OOTP24, every hitter I import gets 10/10 on avoid K. When I go into Commisioner mode and look at the editor, the potential avoid K at right seems correct (e.g. 90) but then the L and R amounts seem to be getting multipled by 10 (e.g. 180/170 with 90 in the right). Tried with a poor hitter (Bobby Cox) and even he came out as Avoid K vs. LHP 220, vs RHP 219, Potential overall as 92. The 92 seems correct for potential. Same thing is happening even for pitchers, where their hitting potential in Avoid K is off the charts. Love the game in any case!

[Beirnej1]

Seen a number of these with the age in the real life tabs. Not sure if its just cosmetic or if it will effect recalc and will wait for Cal Mitchell to be 1516 years old before recalc starts.

I only play random debut settings if that helps.

[Zitofan75]

Started a 1946 replay. Some of the teams in mixed nationality leagues show up as USA when they were something else. Other leagues, like the International League correctly showed various nationalities.

[Zitofan75]

I started a historic league starting in 1980 with full history and found this guy dominating the leaderboards. It says he played in 1895 (but born in 2002) and it looks like the same error I found earlier, even down to the stats. His ID is figuer001lui

[Lukas Berger]

Originally Posted by Jays Fan

Please forgive if this is already here but I've looked and don't see it posted. I have a fictional game, scouting off (i.e. 100% accuracy), into which I like to manually import some historical players each year. I normally manually import players from the historical database using the ID, and was doing so for the year 1967, usually the players from the year ahead so in this case 1968. Never had any issue before. Settings using Neutralized stats, Peak Seasons of Career, Fielding Ratings based on Entire Career, Pitcher Stamina Entire Career. When I've been doing this in OOTP24, every hitter I import gets 10/10 on avoid K. When I go into Commisioner mode and look at the editor, the potential avoid K at right seems correct (e.g. 90) but then the L and R amounts seem to be getting multipled by 10 (e.g. 180/170 with 90 in the right). Tried with a poor hitter (Bobby Cox) and even he came out as Avoid K vs. LHP 220, vs RHP 219, Potential overall as 92. The 92 seems correct for potential. Same thing is happening even for pitchers, where their hitting potential in Avoid K is off the charts. Love the game in any case!

This is likely not really a historical db issue and would require some deeper troubleshooting. If you could post this to its own thread in the main bug reports forum, that would help. Thanks!

[Lukas Berger]

Originally Posted by Zitofan75

I started a historic league starting in 1980 with full history and found this guy dominating the leaderboards. It says he played in 1895 (but born in 2002) and it looks like the same error I found earlier, even down to the stats. His ID is figuer001lui

Fixed, thanks.

[Zitofan75]

Originally Posted by Lukas Berger

Fixed, thanks.

Thanks!