View Old Forum Thread

Old Forum Index » Baseball Beta Testing » Beta Issues & Suggestions » Spreadsheet Error - 2033 Draft Class Missing

CaseyStengel

Spreadsheet Error - 2033 Draft Class Missing

May 21, 2009 at 02:00PM View BBCode

The following players are not populating the spreadsheets for batters (both team and individual spreadsheets) for the Seattle Sounders:

What is common? They were all drafted in 2033.

I just checked the team spreadsheets and found that there are no players from the 2033 draft on the batters and fielders spreadsheets... the pitchers spreadsheet is OK.

Admin

May 21, 2009 at 02:15PM View BBCode

Hmmm, none of them have batter stats yet either. Have they been playing?

This is related to this issue I think:

http://www.simdynasty.com/oldforum-viewthread.jsp?tid=220200

Tyson

CaseyStengel

May 21, 2009 at 04:32PM View BBCode

No, they are in my minors... however EVERY POSITION PLAYER drafted in 2033 is missing from the batters and fielding spreadsheets... there has got to be at least one player who could play in the majors.

Admin

May 21, 2009 at 05:01PM View BBCode

Promote one of the guys and see what happens after he plays.

Tyson

CaseyStengel

May 21, 2009 at 05:59PM View BBCode

OK... I successfully promoted Rich East to the Majors.

I get this error message when I try to access the Lineup vs RHP (as well as LHP) page.

select bstats_runs, bstats_hsbs, bstats_cs, bstats_errors, bstats_singles as bss_singles, bstats_doubles as bss_doubles, bstats_triples as bss_triples, bstats_homeruns as bss_homeruns, bstats_walks as bss_walks, bstats_ab as bss_ab, bstats_games as bss_games, bstats_hbps as bss_hbps, bstats_strikeouts as bss_strikeouts, bstats_rbis as bss_rbis from batterstats where bstats_type = 0 and bstats_tp_id = 39435 and bstats_year = 2035 *** SQLException caught *** SQLState: S1000 Message: Illegal operation on empty result set Vendor: 0

I can view other team Lineup pages, but not mine.

Admin

May 21, 2009 at 06:26PM View BBCode

Yeah, he is missing his batterstats line which is causing some issues. These get copied from OffSeason to OffSeason, so if he was missing his originally, he won't get one for 2035 until he plays in a game.

I'll see if I can add these in or do something to fix this next week. If he happens to find his way into a game, I *think* the problem will fix itself.

Tyson

CaseyStengel

May 21, 2009 at 08:43PM View BBCode

I noticed that ABE auto promoted a player (Angel Judy) before/after the last game leaving me with 26 players on my ML roster. It looks like I have an invisible player on my team.

I demoted East, benched my Left Fielder, promoted East demoting Judy, and set East as the #1 backup in LF for the next game.

I expect that East will play in the next game (assuming ABE does not ignore my back up settings). I also assume that a player will be promoted if the code checks for 25 players BEFORE the game.

CaseyStengel

May 21, 2009 at 08:50PM View BBCode

I just pulled up the results for the 2033 draft and found that [url=http://beta.simdynasty.com/player.jsp?id=39655] Jimmy McLaughlin[/url], the #1 draft pick and 27 years old, has never played in the majors.

I don't know how Chris sets his lineups, but if he downloads the spreadsheets and uses them to determine who plays in the majors (like I do), McLaughlin never shows up. And so, the best draft pick of the 2033 season is wasting away in Chris' minors.

CaseyStengel

May 21, 2009 at 10:36PM View BBCode

Originally posted by CaseyStengel
I noticed that ABE auto promoted a player (Angel Judy) before/after the last game leaving me with 26 players on my ML roster. It looks like I have an invisible player on my team.

I demoted East, benched my Left Fielder, promoted East demoting Judy, and set East as the #1 backup in LF for the next game.

I expect that East will play in the next game (assuming ABE does not ignore my back up settings). I also assume that a player will be promoted if the code checks for 25 players BEFORE the game.

East DID NOT play. ABE promoted Angel Judy again. It looks like the class of 2033 is a bust destined to wallow in the minors.

dunn_acolyte

May 23, 2009 at 11:30AM View BBCode

http://www.simdynasty.com/oldforum-viewthread.jsp?tid=225930

This is related to this also as Stein the catcher(2033 draftee) is on roster but not recognized as such and another player(Ed Matthews) is called up to majors by ABE for games.

Admin

May 23, 2009 at 03:36PM View BBCode

Thanks, I'll look into this next week. I'll either get the batter stats setup for these guys or just delete the players.

Tyson

tworoosters

May 23, 2009 at 06:50PM View BBCode

Originally posted by CaseyStengel
It looks like the class of 2033 is a bust destined to wallow in the minors.

Ironically [url=http://beta.simdynasty.com/player.jsp?player=nobody&mode=stats&id=39675]Myette[/url] is my 1st round pick in the 2033 draft, note his development curve.

Admin

May 27, 2009 at 07:12PM View BBCode

Ok, I ran a script which may have fixed this. I'm not sure if the guys will show on the spreadsheet this year, but at least you should be able to access the pages.

Tyson

CaseyStengel

May 28, 2009 at 02:15PM View BBCode

Class of 2033 can play in the majors now AND are on the spreadsheets...

Pages: 1