Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 07-24-2011, 02:57 PM   #21
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 71
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, 03:43 PM   #22
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
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
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-24-2011, 03:54 PM   #23
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
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
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-24-2011, 07:19 PM   #24
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
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, 01:28 AM   #25
OpeningDay85
Minors (Single A)
 
Join Date: Apr 2011
Posts: 73
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, 01:20 PM   #26
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
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 06:31 PM.
cody8200 is offline   Reply With Quote
Old 07-25-2011, 02:42 PM   #27
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
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
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-25-2011, 06:00 PM   #28
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
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, 07:15 PM   #29
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
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, 09:39 PM   #30
hank9481
Major Leagues
 
hank9481's Avatar
 
Join Date: Jun 2002
Posts: 451
Blog Entries: 1
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, 05:27 AM   #31
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
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
Old 07-26-2011, 08:23 AM   #32
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
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, 08:49 AM   #33
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
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, 11:26 AM   #34
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 71
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, 01:20 PM   #35
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,584
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
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-26-2011, 05:09 PM   #36
sdodd
Major Leagues
 
Join Date: Jan 2011
Posts: 332
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, 11:59 AM   #37
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
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, 01:00 PM   #38
sdodd
Major Leagues
 
Join Date: Jan 2011
Posts: 332
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, 11:09 PM   #39
sdodd
Major Leagues
 
Join Date: Jan 2011
Posts: 332
No didn't work
sdodd is offline   Reply With Quote
Old 07-28-2011, 01:45 AM   #40
JoeyBats
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 27
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

Forum Jump


All times are GMT -4. The time now is 07:43 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments