Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 11-18-2014, 11:51 AM   #241
Greeney03
Minors (Triple A)
 
Greeney03's Avatar
 
Join Date: Apr 2010
Posts: 232
StatsLab crashes when I update Developement. Anyone know how to fix this?
__________________
CBL Commissioner & GM of San Diego Surf Dawgs
Greeney03 is offline   Reply With Quote
Old 11-18-2014, 11:59 AM   #242
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,644
Quote:
Originally Posted by Greeney03 View Post
StatsLab crashes when I update Developement. Anyone know how to fix this?
Unfortunately, the current version of the development tool tends to cause crashes when you have very large leagues with large player pools. There are certain settings in PHP configuration which can either alleviate it or exacerbate it. Your ability to adjust those settings is dependent on your web host.
__________________
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 11-18-2014, 01:23 PM   #243
MBarrett
All Star Reserve
 
MBarrett's Avatar
 
Join Date: Oct 2012
Location: Canada
Posts: 627
Quote:
Originally Posted by fhomess View Post
It may be that you need to expand permissions on the StatsLab uploads directory so that StatsLab can manipulate the files there.
I'm not sure how or where to do this. Can you provide more instruction please?
MBarrett is offline   Reply With Quote
Old 11-18-2014, 02:23 PM   #244
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,644
Quote:
Originally Posted by MBarrett View Post
I'm not sure how or where to do this. Can you provide more instruction please?
I will send you a PM.
__________________
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 12-28-2014, 12:01 PM   #245
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by fhomess View Post
Unfortunately, the current version of the development tool tends to cause crashes when you have very large leagues with large player pools. There are certain settings in PHP configuration which can either alleviate it or exacerbate it. Your ability to adjust those settings is dependent on your web host.
I am having a similar issue, I get a 500 server error when I run some processes.

I now load the sql files manually because, if I hit the auto-load button I get the 500 error the first time, but it "completes" if I hit it again...sometimes. but I have no idea what the long term effects of hitting that button twice per load does

the development run 500's out every time.

but the strange thing is, everything seems to actually run, statslab doesn't think so, but we have yet to find something that doesn't update.

I have full server access, whatever php settings need to be changed, can be changed
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 12-30-2014, 09:21 PM   #246
byzeil
Hall Of Famer
 
byzeil's Avatar
 
Join Date: Aug 2009
Location: NJ, US
Posts: 2,006
Quote:
Originally Posted by Greeney03 View Post
Need help importing our draft class to StatsLab.

I'm getting this error when I upload draft.csv,

Only *.csv files are permitted
Please note that you may receive this error message if you have the file open while uploading.
Sorry your file was not uploaded
Return to the draft admin page

I don't have Excel,etc opened.
I am having this same problem. Any luck figuring out how to get these to work?

Files are .csv files and I don't have them open by any other program.
byzeil is offline   Reply With Quote
Old 12-30-2014, 09:48 PM   #247
byzeil
Hall Of Famer
 
byzeil's Avatar
 
Join Date: Aug 2009
Location: NJ, US
Posts: 2,006
Quote:
Originally Posted by byzeil View Post
I am having this same problem. Any luck figuring out how to get these to work?

Files are .csv files and I don't have them open by any other program.
I booted up my old windows 7 machine and was able to load the file fine. It appears to be something do with my windows 8 installations.
byzeil is offline   Reply With Quote
Old 12-31-2014, 12:42 AM   #248
Tiesenberg
Major Leagues
 
Join Date: Nov 2002
Posts: 307
Export Tracker Not Working

MLB Pro has recently run into a problem with our export tracker.

Link to Export Tracker: Export Tracker - StatsLab for OOTP15

Yet having double checked, our league file can indeed be downloaded at: mlb | MLB Pro Pro.lg.tar.gz

We are unsure of what settings might have been changed which have caused this problem.

Other current settings include:

League File Name: MLB Pro.lg.tar.gz
League File Path: http://www.mlb-pro.com/lgfiles
Export File Path: http://www.mlb-pro.com/lgexports

Any help would be greatly appreciated.
Tiesenberg is offline   Reply With Quote
Old 12-31-2014, 10:55 PM   #249
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
try setting your league file name as

MLB%20Pro.lg.tar.gz
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 01-01-2015 at 12:02 AM.
jazzrack is offline   Reply With Quote
Old 01-01-2015, 12:24 PM   #250
USF
All Star Starter
 
USF's Avatar
 
Join Date: Oct 2011
Location: Maple, ON - Canada
Posts: 1,084
I just downloaded the version for OOTP15.
Anyone that has been using an older version of statslab for an older version of OOTP; just has to overwrite the statslab folder on your server with the new files contained in the statslab folder upon download. You don't have to touch dbopen and config files since they are already running properly.
All of the instructions state (NEW INSTALL) - but the above information applies to (UPGRADES). It all sounds trival but, for those that are not cumfy with servers and such this might help you.

Just a FYI - Jason

Last edited by USF; 01-01-2015 at 12:25 PM.
USF is offline   Reply With Quote
Old 01-01-2015, 01:49 PM   #251
USF
All Star Starter
 
USF's Avatar
 
Join Date: Oct 2011
Location: Maple, ON - Canada
Posts: 1,084
Question #1:
When I "send update" email to all GMs, there exists a GM' email that is no longer involved in the league. How do I go about removing that email? I checked in the "Manager" screen and that person and that email doesn't show up anywhere.
Question #2:
Also in the "Manager" screen a certain GMs email is always changed to another teams email after every update. I went into the OOTP 15 game and the emails are correct for both teams. Is there a way to prevent the emails from switching between these two teams?
Thanks!
Jason
USF is offline   Reply With Quote
Old 03-09-2015, 10:07 AM   #252
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
Can I get some help on this, I keep getting this error:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/paramoun/sqldump/dbopen.php on line 2

Not sure what is causing this but my code is below:

<?php
$db = mysql_connect(‘localhost’,’paramoun_commish','pass word') or die('Could not connect:'.mysql_error());
mysql_select_db('paramoun_StatsLab’);
?>


Anyone see something off?
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 03-20-2015, 04:37 PM   #253
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,644
I've posted a version of StatsLab compatible with OOTP16.

See the StatsLab Wiki for download links.
__________________
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 03-24-2015, 04:30 PM   #254
CT-Sox-Fan
Minors (Double A)
 
Join Date: Sep 2006
Posts: 129
Up and running with the new 16 version for MLBD. Everything looks fine. Thanks for the quick service!
__________________
---------------------------------
Dave A.

MLBD- Toronto Blue Jays GM
CT-Sox-Fan is offline   Reply With Quote
Old 03-30-2015, 02:11 AM   #255
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
I finally got all my time-out issues solved, worked well for about a month now, all of a sudden everybody is rated 1. I even rebuilt the whole thing and still

http://clb.ootpwiki.info/StatsLab
Attached Images
Image Image 
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 03-30-2015 at 02:16 AM.
jazzrack is offline   Reply With Quote
Old 03-30-2015, 12:28 PM   #256
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,644
Check the players_batting.mysql.sql and players_pitching.mysql.sql files and verify that ratings are actually getting in there. I believe I've seen this behavior in the past after leagues upgraded to new versions but didn't update the MySQL dump configuration, and OOTP spit out all 0's (zeros) for ratings.
__________________
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 03-30-2015, 11:33 PM   #257
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by fhomess View Post
Check the players_batting.mysql.sql and players_pitching.mysql.sql files and verify that ratings are actually getting in there. I believe I've seen this behavior in the past after leagues upgraded to new versions but didn't update the MySQL dump configuration, and OOTP spit out all 0's (zeros) for ratings.
thank you sir!

When I was having a slow sim issue & I rebuilt the file I must have started with a base that was older than our use of statslab.
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 04-06-2015, 12:22 PM   #258
McLite
Minors (Single A)
 
McLite's Avatar
 
Join Date: Sep 2009
Posts: 72
Quote:
Originally Posted by byzeil View Post
I booted up my old windows 7 machine and was able to load the file fine. It appears to be something do with my windows 8 installations.
Is this the only fix? Having the same issue.
McLite is offline   Reply With Quote
Old 04-14-2015, 06:05 PM   #259
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Just an fyi. the 16 version does not have the installation and how to for the draft pdf's in it

I'm guessing the 15 version text still applies?
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino
Painmantle is offline   Reply With Quote
Old 04-16-2015, 08:17 AM   #260
CT-Sox-Fan
Minors (Double A)
 
Join Date: Sep 2006
Posts: 129
Draft list issue

Frank,

We have completed 5 rounds of the draft in OOTP16 using your 16 version of StatsLab and today when ready to export the picks and import into the game, all of the picks except for the first pick are blank. Our entire draft looks like it has been rolled back to the 2d pick.

I'm the only one with Admin access to StatsLab and I haven't even gone to that page for a week because we'd finished the on line picks.

Any idea what might have happened and if so is there any way to recover.

I did export the list as .csv and it does in fact show only one pick made, so it's not an issue with not being able to find the players listed.

Thanks for your help in advance. We are stuck right now as it's time to run the in game draft

Dave
__________________
---------------------------------
Dave A.

MLBD- Toronto Blue Jays GM
CT-Sox-Fan is offline   Reply With Quote
Reply

Bookmarks


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 01:00 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments