Home | Webstore
Latest News: - OOTP 15: Update #6 Released! - OOTP 15 Released! - FHM 2014: Version 1.6.19 Available! - iOOTP Baseball 2014 for iOS Available NOW! - Beyond the Sideline Football Announced! - Title Bout Championship Boxing 2.5 released!

OOTP 15 World Series Special: 50% Off!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 15 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools
Old 07-24-2011, 01:57 PM   #21 (permalink)
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
anyone having much luck? I can't even get my images to show correctly or my export
HustlinOwl is offline   Reply With Quote
Old 07-24-2011, 02:43 PM   #22 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,232
Thanks: 106
Thanked 773x in 333 posts
Quote:
Originally Posted by cody8200 View Post
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.

Quote:
Originally Posted by Cooleyvol View Post
Quote:
Originally Posted by Tony M View Post
A quick question Frank. I have a universe with four major leagues - is there a way of not having StatsLab defaulting to one particular league.
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Other Mods:
StatsLab11
19th Century: Schedules, FaceGen
BBCards: Full list of known templates
- Fictional Cards: 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 07-24-2011, 02:54 PM   #23 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,232
Thanks: 106
Thanked 773x in 333 posts
Quote:
Originally Posted by OpeningDay85 View Post
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.

Quote:
Originally Posted by OpeningDay85 View Post
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.

Quote:
Originally Posted by OpeningDay85 View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Other Mods:
StatsLab11
19th Century: Schedules, FaceGen
BBCards: Full list of known templates
- Fictional Cards: 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 07-24-2011, 06:19 PM   #24 (permalink)
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,126
Thanks: 59
Thanked 569x in 336 posts
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
Cooleyvol is offline   Reply With Quote
Old 07-25-2011, 12:28 AM   #25 (permalink)
Minors (Single A)
 
Join Date: Apr 2011
Posts: 71
Thanks: 8
Thanked 12x in 7 posts
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.
OpeningDay85 is offline   Reply With Quote
Old 07-25-2011, 12:20 PM   #26 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,122
Thanks: 1,336
Thanked 792x in 356 posts
Quote:
Originally Posted by fhomess View Post
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.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb

Last edited by cody8200; 07-27-2011 at 05:31 PM.
cody8200 is offline   Reply With Quote
Old 07-25-2011, 01:42 PM   #27 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,232
Thanks: 106
Thanked 773x in 333 posts
Quote:
Originally Posted by Cooleyvol View Post
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.

Quote:
Originally Posted by OpeningDay85 View Post
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.

Quote:
Originally Posted by cody8200 View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Other Mods:
StatsLab11
19th Century: Schedules, FaceGen
BBCards: Full list of known templates
- Fictional Cards: 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 07-25-2011, 05:00 PM   #28 (permalink)
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 599
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by OpeningDay85 View Post
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?
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 07-25-2011, 06:15 PM   #29 (permalink)
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,126
Thanks: 59
Thanked 569x in 336 posts
Quote:
Originally Posted by fhomess View Post
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:
Code:
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:
Code:
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);
Cooleyvol is offline   Reply With Quote
Old 07-25-2011, 08:39 PM   #30 (permalink)
Major Leagues
 
hank9481's Avatar
 
Join Date: Jun 2002
Posts: 327
Thanks: 0
Thanked 3x in 3 posts
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?
__________________
HH
www.mblsim.com
hank9481 is offline   Reply With Quote
Old 07-26-2011, 04:27 AM   #31 (permalink)
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 7,817
Thanks: 495
Thanked 3,043x in 1,034 posts
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!
Andreas Raht is offline   Reply With Quote
Thank you for this post:
fhomess (07-26-2011)
Old 07-26-2011, 07:23 AM   #32 (permalink)
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,126
Thanks: 59
Thanked 569x in 336 posts
Quote:
Originally Posted by Andreas Raht View Post
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?
Cooleyvol is offline   Reply With Quote
Old 07-26-2011, 07:49 AM   #33 (permalink)
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 7,817
Thanks: 495
Thanked 3,043x in 1,034 posts
Quote:
Originally Posted by Cooleyvol View Post
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".
Andreas Raht is offline   Reply With Quote
Old 07-26-2011, 10:26 AM   #34 (permalink)
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
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?
HustlinOwl is offline   Reply With Quote
Old 07-26-2011, 12:20 PM   #35 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,232
Thanks: 106
Thanked 773x in 333 posts
Quote:
Originally Posted by Cooleyvol View Post
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.

Quote:
Originally Posted by HustlinOwl View Post
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Other Mods:
StatsLab11
19th Century: Schedules, FaceGen
BBCards: Full list of known templates
- Fictional Cards: 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 07-26-2011, 04:09 PM   #36 (permalink)
Minors (Triple A)
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 290
Thanks: 52
Thanked 67x in 31 posts
While updating the player development, I get this error

Quote:
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
sdodd is offline   Reply With Quote
Old 07-27-2011, 10:59 AM   #37 (permalink)
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 599
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by sdodd35@yahoo.com View Post
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.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 07-27-2011, 12:00 PM   #38 (permalink)
Minors (Triple A)
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 290
Thanks: 52
Thanked 67x in 31 posts
Quote:
Originally Posted by BleedingCubbyBlue View Post
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 is offline   Reply With Quote
Old 07-27-2011, 10:09 PM   #39 (permalink)
Minors (Triple A)
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 290
Thanks: 52
Thanked 67x in 31 posts
No didn't work
sdodd is offline   Reply With Quote
Old 07-28-2011, 12:45 AM   #40 (permalink)
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 24
Thanks: 0
Thanked 2x in 2 posts
Having some issues here: Admin - StatsLab for OOTP12

Any help would be appreciated...thanks
JoeyBats is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:46 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.1
Copyright © 2013 Out of the Park Developments