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 Offseason 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-28-2011, 12:44 PM   #41 (permalink)
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 24
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 02:40 PM.
JoeyBats is offline   Reply With Quote
Old 07-28-2011, 01:30 PM   #42 (permalink)
Minors (Rookie Ball)
 
Join Date: Jul 2011
Posts: 24
Thanks: 0
Thanked 2x in 2 posts
.

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

Last edited by JoeyBats; 07-28-2011 at 02:39 PM.
JoeyBats is offline   Reply With Quote
Old 07-29-2011, 10:34 PM   #44 (permalink)
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 155
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)?
__________________
Matt Carlisle
---------------------------------
WBL - Commish/Florida Marlins
Check out the WBL's IOLD profile!

MLSB - Oakland Athletics
mcarlisle21 is offline   Reply With Quote
Old 07-29-2011, 10:37 PM   #45 (permalink)
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 155
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?
__________________
Matt Carlisle
---------------------------------
WBL - Commish/Florida Marlins
Check out the WBL's IOLD profile!

MLSB - Oakland Athletics
mcarlisle21 is offline   Reply With Quote
Old 08-01-2011, 09:22 PM   #46 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,129
Thanks: 1,355
Thanked 807x in 362 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, 04:35 PM   #47 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,129
Thanks: 1,355
Thanked 807x in 362 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, 09:53 AM   #48 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,129
Thanks: 1,355
Thanked 807x in 362 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 10:02 AM.
cody8200 is offline   Reply With Quote
Old 08-03-2011, 12:55 PM   #49 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,265
Thanks: 114
Thanked 844x in 349 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
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

Last edited by fhomess; 08-03-2011 at 01:08 PM.
fhomess is offline   Reply With Quote
Thank you for this post:
cody8200 (08-03-2011)
Old 08-03-2011, 03:09 PM   #50 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,129
Thanks: 1,355
Thanked 807x in 362 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, 01:51 PM   #51 (permalink)
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, 08:21 PM   #52 (permalink)
Minors (Double A)
 
Join Date: Apr 2002
Posts: 174
Thanks: 10
Thanked 2x in 2 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, 04:25 PM   #53 (permalink)
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 155
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
__________________
Matt Carlisle
---------------------------------
WBL - Commish/Florida Marlins
Check out the WBL's IOLD profile!

MLSB - Oakland Athletics
mcarlisle21 is offline   Reply With Quote
Old 08-05-2011, 05:16 PM   #54 (permalink)
Minors (Double A)
 
Join Date: Apr 2002
Posts: 174
Thanks: 10
Thanked 2x in 2 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, 09:17 PM   #55 (permalink)
Minors (Rookie Ball)
 
Phatman's Avatar
 
Join Date: Jun 2011
Posts: 45
Thanks: 6
Thanked 0x in 0 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"
__________________
Boston Captains

United Baseball League

Last edited by Phatman; 08-08-2011 at 06:29 PM.
Phatman is offline   Reply With Quote
Old 08-08-2011, 03:17 PM   #56 (permalink)
Minors (Double A)
 
mcarlisle21's Avatar
 
Join Date: Jun 2003
Posts: 155
Thanks: 2
Thanked 0x in 0 posts
Not rushing, just bumping in case someone who could help missed it.
__________________
Matt Carlisle
---------------------------------
WBL - Commish/Florida Marlins
Check out the WBL's IOLD profile!

MLSB - Oakland Athletics
mcarlisle21 is offline   Reply With Quote
Old 08-10-2011, 08:25 PM   #57 (permalink)
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,836
Blog Entries: 1
Thanks: 47
Thanked 82x in 54 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[/SIZE]

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


molarmite is offline   Reply With Quote
Old 08-10-2011, 08:49 PM   #58 (permalink)
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,129
Thanks: 1,355
Thanked 807x in 362 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, 08:59 PM   #59 (permalink)
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 341
Thanks: 2
Thanked 3x in 3 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, 01:03 AM   #60 (permalink)
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 341
Thanks: 2
Thanked 3x in 3 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
 
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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:49 PM.


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