StatsLab SQL Utilities for OOTPX

[jsweber]

I have been trying to figure out why I'm still getting 2 different issues when I load my dumps...

First off I have tried to troubleshoot and even wipe the db and start over but for whatever reason I get the following 2 errors on loading the dump files:

insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 87032, 77965, 20783, 15309, 0, 0, 4131, 388, 2560, 1541, 542, 0, 10938, 7694, 0, 725, 0, 648, 0, 0, 2270, 0, 7079, 0, 0.2666, 0.3355, 0.4280, 11961.8121, 5.5329, 0.1614, 1.#INF, 0.7635, 73.9798, 0.0000, 0.0000);
 -> 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 '' at line 1
   insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 98393, 87884, 22741, 18282, 0, 0, 4606, 561, 2482, 1429, 591, 0, 11481, 8926, 0, 865, 0, 718, 0, 0, 2590, 0, 7649, 0, 0.2588, 0.3306, 0.4087, 12755.6118, 5.1827, 0.1499, 1.#INF, 0.7393, 70.7426, 0.0000, 0.0000);
 -> 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 '' at line 1

I might be missing something in setup I'm not really sure. And the second issue is non of the all star nominees are showing up to vote on. I have tried searching the forums with no luck.. Any advice?

EDIT: Ok after checking some things out I really don't need these anyways so I guess I'm down to my only issue of the all stars voting not working.. thanks

[Recte44]

Any progress on modifications for OOTP11???

I'd love the Draft Utility to be able to handle compensation picks much easier than currently; also a big addition would be the ability to view batting and pitching stats/ratings for position players and pitchers; as well as adding a filter to the Development page for pitching, batting and fielding development events.

[Recte44]

Has anyone heard from fhomess??? I really, really need his help.

[js155306]

I'm having a major problem with the draft utility in the OOTP9 version.

My league expanded from eight to ten teams this off-season, which the utility has apparently recognized since they are able to log-in. However, when I went to set up the amateur draft, even though there are slots for ten picks on the admin page, the actual draft page is still only generating eight picks per round.

Does anyone know what has to be done to fix this?

[fhomess]

StatsLab11 released.

[Cowtippers]

Have a question. Didn't see it answered in any of the post above but I may have missed it. I've got statslab uploaded and working. All the sql files are in the correct folder and show up loaded. I can't get any of the links to show up when the managers log in to statslab. I go into the admin portion of statslab and tell it to have the last sim, exporter, etc. loaded but when I click the check box and hit save it does nothing. I'm at a loss on what to do. I've even deleted the /admin part and tried to get that screen to work by setting the sim length but that still does nothing. I know its probably something I'm doing wrong but I just can't figure it out.

Thanks!

[EKomrska15]

I have a question about the HOF....How can I get players to show up to vote on? Is there somethign special I need to do to have players show up that retired 5 years ago?

[fhomess]

This thread can be unstickied.

[thickman1]

So our league expanded by 4 teams this past off-season (24 - 28). I went in to the draft tool in statslab and while it shows 28 teams in the admin section - and lets me put them in any order - it only saves the first 24 teams. When looking at the draft board it only shows 24 picks.

Can someone tell me how to fix that?