Home | Webstore
Latest News: OOTP Update 20.5.47 - OOTP 20 Available - FHM 5 Available

Collection Missions for Perfect Team Released!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > 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-28-2011, 11:44 AM   #41
JoeyBats
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 25
Thanks: 0
Thanked 2x in 2 posts
Sorry for all the posts guys, didn't realize I would need moderator approval and accidentally posted a few times.

Last edited by JoeyBats; 07-28-2011 at 01:40 PM.
JoeyBats is offline   Reply With Quote
Old 07-28-2011, 12:30 PM   #42
JoeyBats
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 25
Thanks: 0
Thanked 2x in 2 posts
.

Last edited by JoeyBats; 07-28-2011 at 01:39 PM.
JoeyBats is offline   Reply With Quote
Old 07-28-2011, 01:03 PM   #43
JoeyBats
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 25
Thanks: 0
Thanked 2x in 2 posts
.

Last edited by JoeyBats; 07-28-2011 at 01:39 PM.
JoeyBats is offline   Reply With Quote
Old 07-29-2011, 09:34 PM   #44
mcarlisle21
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 157
Thanks: 2
Thanked 0x in 0 posts
I may have read this somewhere but I can't remember. For some reason, I am unable to login to my profile in StatsLab. I know my password and it was working earlier, but when I logged in as another GM, then logged out, I can't log back in as myself(commish)?
mcarlisle21 is offline   Reply With Quote
Old 07-29-2011, 09:37 PM   #45
mcarlisle21
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 157
Thanks: 2
Thanked 0x in 0 posts
It actually looks like my name doesn't match up to my profile in the utility. My password works for another GM. How can I fix this?
mcarlisle21 is offline   Reply With Quote
Old 08-01-2011, 08:22 PM   #46
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Quote:
Originally Posted by mcarlisle21 View Post
It actually looks like my name doesn't match up to my profile in the utility. My password works for another GM. How can I fix this?
You can fix this by going through CPAnel and doing php admin. Pm if you need help.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-02-2011, 03:35 PM   #47
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Running Career metrics in 12 always results in an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/career.php on line 160

Warning: Cannot modify header information - headers already sent by (output started at /home/ootpbeli/public_html/StatsLab/career.php:160) in /home/ootpbeli/public_html/StatsLab/career.php on line 229
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-03-2011, 08:53 AM   #48
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Quote:
Originally Posted by cody8200 View Post
Running Career metrics in 12 always results in an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/career.php on line 160

Warning: Cannot modify header information - headers already sent by (output started at /home/ootpbeli/public_html/StatsLab/career.php:160) in /home/ootpbeli/public_html/StatsLab/career.php on line 229
It also seems like the newest beta patch release causes all black ink/gray ink stuff to no longer work. Fhomess, can you identify the issue (Statslab side or OOTP MySQL export side) so we can report it to Markus/Andreas?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb

Last edited by cody8200; 08-03-2011 at 09:02 AM.
cody8200 is offline   Reply With Quote
Old 08-03-2011, 11:55 AM   #49
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by cody8200 View Post
Running Career metrics in 12 always results in an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/career.php on line 160

Warning: Cannot modify header information - headers already sent by (output started at /home/ootpbeli/public_html/StatsLab/career.php:160) in /home/ootpbeli/public_html/StatsLab/career.php on line 229
This is an odd place for an error.

Quote:
Originally Posted by cody8200 View Post
It also seems like the newest beta patch release causes all black ink/gray ink stuff to no longer work. Fhomess, can you identify the issue (Statslab side or OOTP MySQL export side) so we can report it to Markus/Andreas?
PM me a link to your StatsLab install with a commish password. I'm not having any trouble with the latest beta patch.

EDIT: Didn't see 12.3.22 has been released to the public.



Patch 12.3.22 does fix the issue with the fields missing from players_contract table, so the financial reports should now be working in StatsLab again.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 08-03-2011 at 12:08 PM.
fhomess is offline   Reply With Quote
Thank you for this post:
cody8200 (08-03-2011)
Old 08-03-2011, 02:09 PM   #50
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Quote:
Originally Posted by fhomess View Post
EDIT: Didn't see 12.3.22 has been released to the public.



Patch 12.3.22 does fix the issue with the fields missing from players_contract table, so the financial reports should now be working in StatsLab again.
Finance reports now work perfectly. I'll pm my info shortly.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-04-2011, 12:51 PM   #51
HustlinOwl
Minors (Single A)
 
Join Date: Apr 2010
Posts: 68
Thanks: 45
Thanked 2x in 2 posts
Receiving following error with newest patch?

Quote:
ERROR in players_career_batting_stats:
insert ignore into `players_career_batting_stats` VALUES (5402, 2011, 85, 0, 104, 9, 3, 0, 19, 4, 8, 21, 0, 6, 4, 1, 1, 0, 3, 0, 0, 0, 2, 0, 1, 0, 0, 0, 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 '' at line 1

Warning: Cannot modify header information - headers already sent by (output started at /home/osdkootp/public_html/StatsLab/db_update.php:220) in /home/osdkootp/public_html/StatsLab/db_update.php on line 315
HustlinOwl is offline   Reply With Quote
Old 08-04-2011, 07:21 PM   #52
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Thanks: 10
Thanked 4x in 4 posts
Quote:
Originally Posted by sdodd35@yahoo.com View Post
While updating the player development, I get this error
I am getting the same error when trying to update development. Server times out everytime no matter if I try to do one league at a time or all of them. Did you ever get this fixed?
patriotcoach is offline   Reply With Quote
Old 08-05-2011, 03:25 PM   #53
mcarlisle21
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 157
Thanks: 2
Thanked 0x in 0 posts
I get the following error when trying to update one part of the utility (dev). The rest loads fine. Any ideas?



Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@ootpwbl.com 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 ootpwbl.com Port 80
mcarlisle21 is offline   Reply With Quote
Old 08-05-2011, 04:16 PM   #54
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 184
Thanks: 10
Thanked 4x in 4 posts
Quote:
Originally Posted by mcarlisle21 View Post
I get the following error when trying to update one part of the utility (dev). The rest loads fine. Any ideas?



Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@ootpwbl.com 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 ootpwbl.com Port 80
This is the same error I am getting as well
patriotcoach is offline   Reply With Quote
Old 08-05-2011, 08:17 PM   #55
Phatman
Minors (Double A)
 
Phatman's Avatar
 
Join Date: Jun 2011
Posts: 112
Thanks: 18
Thanked 35x in 19 posts
I am geting an error in my exports.

ERROR: No League File Found at: "/home/Fictional_League/public_html/game/lgfile/Fictional_League.tar.gz"

Last edited by Phatman; 08-08-2011 at 05:29 PM.
Phatman is offline   Reply With Quote
Old 08-08-2011, 02:17 PM   #56
mcarlisle21
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 157
Thanks: 2
Thanked 0x in 0 posts
Not rushing, just bumping in case someone who could help missed it.
mcarlisle21 is offline   Reply With Quote
Old 08-10-2011, 07:25 PM   #57
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,854
Blog Entries: 1
Thanks: 49
Thanked 83x in 55 posts
Two questions: For the export tracker, it says "/game/lgexports/vMLB.lg.tar.gz" because my file is vMLB.tar.gz, how do I stop it from assuming there's a .lg at the end?

What SQL files do I have to upload after every sim and which ones every year, etc.?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 08-10-2011, 07:49 PM   #58
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Quote:
Originally Posted by molarmite View Post
Two questions: For the export tracker, it says "/game/lgexports/vMLB.lg.tar.gz" because my file is vMLB.tar.gz, how do I stop it from assuming there's a .lg at the end?

What SQL files do I have to upload after every sim and which ones every year, etc.?
I can only answer the second part. You need to upload all SQL files needed ( the ones listed in the PDF) after every sim. Should only be 10 megs or so when zipped up. You need to run everything except for career metrics and player development and similarity scores after every sim. Run all 3 on the last day of the baseball year (before the end of the actual year)
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-10-2011, 07:59 PM   #59
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Does Statslab work in a scouting league? I watched one of the videos fidel put together on how to install StatsLab, but about 1 min in he said something about how if you are in a scouting league, that statslab is not applicable. Is this true? If so, are there other tools and utilities that mirror it?
almo is offline   Reply With Quote
Old 08-11-2011, 12:03 AM   #60
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Hello..I got through the installation of stats lab...its just that my screens look weird. Is this how everybody elses looks?
Attached Images
Image 
almo 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 10:52 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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