StatsLab12

[HustlinOwl]

anyone having much luck? I can't even get my images to show correctly or my export

[fhomess]

Originally Posted by cody8200

Weird. The contract extension sql file is def. loaded. I just went back to the file load list to make sure.

It's an OOTP bug with the SQL dump for the players_contract sql file. The players_contract_extension table is fine.

Originally Posted by Cooleyvol

None that I know of.

I have three and installed three statslab apps with each set to default to its league.

As Mark says, you can have separate installs for different leagues. You define the league ID of each install on the admin page of StatsLab. If these leagues are all within the same saved game, then you can point them all to the same database.

[fhomess]

Originally Posted by OpeningDay85

1. When I try to load all the SQL Files through StatsLab I am able to load everything except the league_history_batting_stats.mysql.sql and players.mysql.sql files.

I get the following errors....


league_history_batting_stats.mysql.sql
Loading league_history_batting_stats.mysql.sql
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
insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 86187, 77467, 20131, 15214, 0, 0, 4016, 368, 2209, 1505, 540, 0, 10097, 7367, 0, 727, 0, 626, 0, 0, 2268, 0, 6593, 0, 0.2599, 0.3275, 0.4068, 11040.9813, 5.0957, 0.1469, 1.#INF, 0.7342, 73.5941, 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, 97794, 87886, 22423, 19092, 0, 0, 4470, 498, 2404, 1454, 589, 0, 11211, 8411, 0, 822, 0, 675, 0, 0, 2592, 0, 7372, 0, 0.2551, 0.3237, 0.3994, 12168.1925, 4.9237, 0.1443, 1.#INF, 0.7231, 71.1698, 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
... 282 queries executed

This should have been coded around with my latest update. Try redownloading from the link above and let me know if you still have this problem... OR ... you can send me a link to your StatsLab install with a working commish password and I can check it myself.

Originally Posted by OpeningDay85

players.mysql.sql
... 42000 queries executed
insert into `players` VALUES (31388, 0, 0, "Lloyd", "Shunick\", "", 18, "1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, 166, 104, 37, 29, 118, 72, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 52, 51, 42, 63, 0, 0, 0, 0, 0, 0, 0, 0, 16, 1, 1, 3, 0, 0, 0, 0, 0, 1, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0); -> 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 '1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, ' at line 1
... 42587 queries executed

It's failing on the slash in the player's name and I have no idea why that slash is there.

Originally Posted by OpeningDay85

2. I am trying to set up the draft ultity to no avil. We have already started the draft on our forums and so right now I need to manually enter our first 2 rounds through statslab. When selected manual pick, I am then needed to enter a player ID. When I do that, I get the following error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/primetim/public_html/StatsLab/draftProcess.php on line 383
player not draft eligible


Any help or direction would be greatly appreciated. Thanks!

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.

[Cooleyvol]

Contract Extensions and Game Batting tables are not loading.

Giving:
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

[OpeningDay85]

Thanks fhomess. The steps to get the player drafted worked. Question.....what do I put in the Email List in the Email Settings for the draft ultity. It doesn't look like I can put in everyone's email.

[cody8200]

Originally Posted by fhomess

It's an OOTP bug with the SQL dump for the players_contract sql file. The players_contract_extension table is fine.

Thanks. Have we reported this yet to Andreas on the Project manager? if not, I can.

[fhomess]

Originally Posted by Cooleyvol

Contract Extensions and Game Batting tables are not loading.

Giving:
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

That's not enough detail to know what's wrong (SQL errors are notorious for giving you just enough to be frustrated). OOTP12 has a number of bugs in the SQL dump that for whatever reason didn't show up with my league. Often if the error is on line 1 and you're not getting the table to load at all, it's because it doesn't have that table created yet in the database. Feel free to post the first few lines of each SQL file and I should be able to see what's happening.

Originally Posted by OpeningDay85

Thanks fhomess. The steps to get the player drafted worked. Question.....what do I put in the Email List in the Email Settings for the draft ultity. It doesn't look like I can put in everyone's email.

You may need to create an email list that forwards to all your GM's. Check with your webhost if you don't know how to do this.

Originally Posted by cody8200

Thanks Frank. Have we reported this yet to Andreas on the Project manager? if not, I can.

I haven't as I have been fairly busy with life stuff lately. Please go ahead and submit it.

[BleedingCubbyBlue]

Originally Posted by OpeningDay85

Thanks fhomess. The steps to get the player drafted worked. Question.....what do I put in the Email List in the Email Settings for the draft ultity. It doesn't look like I can put in everyone's email.

The way I got around this was to edit the database settings for that particular field type to be 500 characters rather than 255. Do you have phpMyAdmin set up?

[Cooleyvol]

Originally Posted by fhomess

That's not enough detail to know what's wrong (SQL errors are notorious for giving you just enough to be frustrated). OOTP12 has a number of bugs in the SQL dump that for whatever reason didn't show up with my league. Often if the error is on line 1 and you're not getting the table to load at all, it's because it doesn't have that table created yet in the database. Feel free to post the first few lines of each SQL file and I should be able to see what's happening.

Players Game Batting:

DROP TABLE IF EXISTS `players_game_batting`;
CREATE TABLE IF NOT EXISTS `players_game_batting` (`player_id` INT, `year` SMALLINT, `team_id` INT, `game_id` INT, `league_id` INT, `level_id` SMALLINT, `split_id` SMALLINT, `position` SMALLINT, `ab` SMALLINT, `h` SMALLINT, `k` SMALLINT, `pa` SMALLINT, `pitches_seen` SMALLINT, `g` SMALLINT, `gs` SMALLINT, `d` SMALLINT, `t` SMALLINT, `hr` SMALLINT, `r` SMALLINT, `rbi` SMALLINT, `sb` SMALLINT, `cs` SMALLINT, `bb` SMALLINT, `ibb` SMALLINT, `gdp` SMALLINT, `sh` SMALLINT, `sf` SMALLINT, `hp` SMALLINT, `ci` SMALLINT, `vorp` DOUBLE);
insert into `players_game_batting` VALUES (13, 2011, 32, 2433, 10, 2, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000);
insert into `players_game_batting` VALUES (13, 2011, 32, 2489, 10, 2, 0, 2, 3, 0, 1, 3, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000);

Player Contract Extensions:

DROP TABLE IF EXISTS `players_contract_extension`;
CREATE TABLE IF NOT EXISTS `players_contract_extension` (`player_id` INT, `team_id` INT, `league_id` INT, `is_major` TINYINT, `no_trade` TINYINT, `last_year_team_option` TINYINT, `last_year_player_option` TINYINT, `contract_team_id` INT, `contract_league_id` INT, `season_year` INT, `salary0` INT, `salary1` INT, `salary2` INT, `salary3` INT, `salary4` INT, `salary5` INT, `salary6` INT, `salary7` INT, `salary8` INT, `salary9` INT, `years` SMALLINT, `current_year` SMALLINT, `minimum_pa` SMALLINT, `minimum_pa_bonus` INT, `minimum_ip` SMALLINT, `minimum_ip_bonus` INT, `mvp_bonus` INT, `cyyoung_bonus` INT, PRIMARY KEY (`player_id`));
insert into `players_contract_extension` VALUES (1, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
insert into `players_contract_extension` VALUES (2, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[hank9481]

How big are your files? I'm dealing with some significant issues with huge file sizes I think and getting a lot of server timeouts so I'm curious if something about my league is causing this.

My player_career files are around 20MB each.
My game files as big as 35MB.

The rest are smaller, but many still into the MB. Has anyone else experienced similar issues?

[Andreas Raht]

The inf, ind and nan codes are exception codes:
IEEE floating point exceptions: NaNs, 1.#INF, 1.#IND, etc

I hope I got rid of them now. Please let me know it future builds of OOTP still produce these codes.
Thanks!

[Cooleyvol]

Originally Posted by Andreas Raht

The inf, ind and nan codes are exception codes:
IEEE floating point exceptions: NaNs, 1.#INF, 1.#IND, etc

I hope I got rid of them now. Please let me know it future builds of OOTP still produce these codes.
Thanks!

So, what are we to do with the current dumped files that contain these in order to get Statslab working completely?

[Andreas Raht]

Originally Posted by Cooleyvol

So, what are we to do with the current dumped files that contain these in order to get Statslab working completely?

You could use a text editor and let it replace all findings with zero. For example replace "1.#INF" with "0".

[HustlinOwl]

had to reboot league and now managers are all switched around under different profiles. Im commish, but have to login in as a different manager and no admin powers. Any way to reset?

[fhomess]

Originally Posted by Cooleyvol

So, what are we to do with the current dumped files that contain these in order to get Statslab working completely?

I've coded around some of these, but they take slightly different forms at times.

At the moment, I can't figure out why your two tables aren't loading properly. The code you posted works fine for me when I try to execute those SQL statements in my DB.

Originally Posted by HustlinOwl

had to reboot league and now managers are all switched around under different profiles. Im commish, but have to login in as a different manager and no admin powers. Any way to reset?

PM sent.

[sdodd]

While updating the player development, I get this error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@mlob.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache mod_fcgid/2.3.6 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at Home Port 80

[BleedingCubbyBlue]

Originally Posted by sdodd35@yahoo.com

While updating the player development, I get this error

Are you trying to update all player development at once or league by league? If you're not doing league by league, go to Dev>Admin and then click the individual leagues. I always get a timeout of FAs, but everything else updates.

[sdodd]

Originally Posted by BleedingCubbyBlue

Are you trying to update all player development at once or league by league? If you're not doing league by league, go to Dev>Admin and then click the individual leagues. I always get a timeout of FAs, but everything else updates.

I'll give it a shot, thanks

[sdodd]

No didn't work

[JoeyBats]

Having some issues here: Admin - StatsLab for OOTP12

Any help would be appreciated...thanks