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

Coming soon: Collection Missions

  

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 06-22-2018, 09:03 AM   #301
Chappy
Hall Of Famer
 
Chappy's Avatar
 
Join Date: Dec 2001
Location: Raleigh, NC
Posts: 2,720
Thanks: 14
Thanked 16x in 13 posts
Just upgraded to statslab 18 and it doesn't seem to be sending e-mails any more (it did before). I unchecked and rechecked the subscribe box but still no e-mails.
__________________
NPBL - Commissioner - Pennsylvania Freedom
AFBL - North Carolina Aviators
Chappy is offline   Reply With Quote
Old 06-22-2018, 10:35 AM   #302
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,619
Thanks: 244
Thanked 173x in 103 posts
Is this updated for OOTP19?
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 06-30-2018, 01:23 PM   #303
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,619
Thanks: 244
Thanked 173x in 103 posts
I'm getting this error:
ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

Looked in my database, there is a ootp_sql_admin table present

However, I still have no users in the drop down and can't do anything else at this point.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 07-10-2018, 10:53 PM   #304
cheo25
Major Leagues
 
cheo25's Avatar
 
Join Date: Mar 2011
Location: Louisiana
Posts: 483
Thanks: 316
Thanked 236x in 164 posts
I keep getting the error message below on StatsLab Validator page when trying to install StatsLab

Current PHP version: 5.6.32 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.


Can someone please provide an example of what the config.txt and dbopen.php files look like (minus your password)? I have the SQL upload directory created so I probably either am not pointing it to the right place or I don't have something write in the dbopen.php file.

Thanks for any help anyone can provide.
cheo25 is offline   Reply With Quote
Old 07-25-2018, 02:42 PM   #305
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,619
Thanks: 244
Thanked 173x in 103 posts
Quote:
Originally Posted by cheo25 View Post
I keep getting the error message below on StatsLab Validator page when trying to install StatsLab

Current PHP version: 5.6.32 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.


Can someone please provide an example of what the config.txt and dbopen.php files look like (minus your password)? I have the SQL upload directory created so I probably either am not pointing it to the right place or I don't have something write in the dbopen.php file.

Thanks for any help anyone can provide.


Same issue.


Sent from my iPhone using Tapatalk
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 08-16-2018, 05:38 PM   #306
Tiesenberg
Minors (Triple A)
 
Join Date: Nov 2002
Posts: 285
Thanks: 9
Thanked 34x in 17 posts
For those leagues that have players with accents in their names, do you get the accent character replaced by a "?" in StatsLab?

For example, Julian Silva's StatsLab page does not show his name properly, whereas his League Report shows up fine as seen here.

Is this a CSS fix or should I be looking elsewhere?

Thanks

Update: Configured the sql to replace accents in game and that worked. That said, if there is an easy fix within the html/css/coding of StatsLab to allow accents, that would be appreciated as well.

Last edited by Tiesenberg; 08-16-2018 at 05:49 PM.
Tiesenberg is offline   Reply With Quote
Old 01-02-2019, 01:23 PM   #307
McLite
Minors (Rookie Ball)
 
Join Date: Sep 2009
Posts: 49
Thanks: 12
Thanked 2x in 2 posts
Just saw the StatsLab 18 patch notes. Does anyone know if this "fixed issue of 2nd and 3rd place award winners appearing as actual winners" will patch up the player cards for all previous years of the league or is it just going forward from the time of the patch?

Thanks
McLite is offline   Reply With Quote
Old 01-02-2019, 06:58 PM   #308
silverwolf
Minors (Double A)
 
Join Date: Sep 2012
Posts: 166
Thanks: 32
Thanked 61x in 36 posts
Quote:
Originally Posted by McLite View Post
Just saw the StatsLab 18 patch notes. Does anyone know if this "fixed issue of 2nd and 3rd place award winners appearing as actual winners" will patch up the player cards for all previous years of the league or is it just going forward from the time of the patch?

Thanks
The change should work for past seasons as well. My understanding of the specific code change was to look up the winner in the league_history table, instead of getting the winner from the player_awards table, which lists the top three finishers but doesn't denote the winner.
__________________
StatsPlus - Desktop tool for OOTP real-time sim integration with Slack (Windows, Mac, and Linux)
USBA - OOTP online promotion/relegation league
silverwolf is offline   Reply With Quote
Thank you for this post:
McLite (01-12-2019)
Old 01-03-2019, 12:42 PM   #309
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,300
Thanks: 66
Thanked 627x in 373 posts
Does anyone know if this works with v19?
Cooleyvol is offline   Reply With Quote
Old 01-10-2019, 09:14 AM   #310
andjbock
Hall Of Famer
 
andjbock's Avatar
 
Join Date: Jul 2003
Location: Somerville, MA, USA Bats: Right Throws: Left
Posts: 3,542
Thanks: 100
Thanked 170x in 98 posts
Need someone to provide an example path please

StatsLab Validator

Current PHP version: 7.0.33 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.


ADMINPATH|/home/ootpbiz/mysql



PHP Code:
<?php
$sqlhost 
'localhost';
$sqluser 'ootpbiz_statslab';
$sqlpass 'omitted';
$sqldb   'ootpbiz_statslab';
Attached Images
Image Image 
__________________

Last edited by andjbock; 01-10-2019 at 09:17 AM.
andjbock is offline   Reply With Quote
Old 01-10-2019, 09:47 AM   #311
andjbock
Hall Of Famer
 
andjbock's Avatar
 
Join Date: Jul 2003
Location: Somerville, MA, USA Bats: Right Throws: Left
Posts: 3,542
Thanks: 100
Thanked 170x in 98 posts
I moved dbopen.php in the mysql folder and it worked.
__________________
andjbock is offline   Reply With Quote
Old 01-10-2019, 11:37 AM   #312
andjbock
Hall Of Famer
 
andjbock's Avatar
 
Join Date: Jul 2003
Location: Somerville, MA, USA Bats: Right Throws: Left
Posts: 3,542
Thanks: 100
Thanked 170x in 98 posts
StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers ta

Anyone have any additional tips on the above error?
-I verified I am a Commish via the human_managers report (I am the only manager as well since this is a solo fic league).

-I have gone through the steps below.

-The teams & human_managers don't show up in phpMyAdmin like the ootp_sql_uers table does. Can the issue be related to this?

No Users in Login Dropdown
If you are unable to login because there are no users in the login dropdown, there are several possible reasons for this. First, make sure that you have assigned at least one human GM to a team (a commish who manages no teams is not sufficient). Then, regardless of the reason, the fix is relatively simple:

Login to phpMyAdmin or whatever database admin tool you're using for MySQL
Connect to your StatsLab database
Drop the human_managers and ootp_sql_users tables
Open StatsLab in your browser
Access the sql_file_load.php page
Load the leagues, sub_leagues, divisions, teams, and team_relations tables
Load the human_managers table (do this after loading the others)
You should now be able to access the login page with the drop down populated.
Note that this will not erase user settings or change user passwords.
__________________
andjbock is offline   Reply With Quote
Old 01-10-2019, 04:26 PM   #313
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 andjbock View Post
Anyone have any additional tips on the above error?
-I verified I am a Commish via the human_managers report (I am the only manager as well since this is a solo fic league).

-I have gone through the steps below.

-The teams & human_managers don't show up in phpMyAdmin like the ootp_sql_uers table does. Can the issue be related to this?
That error should ONLY show up if the ootp_sql_users table doesn't get created properly. The teams and human managers table shouldn't matter for that.

If you do have that table and would like me to look at it, IM me.
__________________
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 01-10-2019, 05:03 PM   #314
andjbock
Hall Of Famer
 
andjbock's Avatar
 
Join Date: Jul 2003
Location: Somerville, MA, USA Bats: Right Throws: Left
Posts: 3,542
Thanks: 100
Thanked 170x in 98 posts
Thanks I will
__________________
andjbock is offline   Reply With Quote
Old 01-10-2019, 09:32 PM   #315
andjbock
Hall Of Famer
 
andjbock's Avatar
 
Join Date: Jul 2003
Location: Somerville, MA, USA Bats: Right Throws: Left
Posts: 3,542
Thanks: 100
Thanked 170x in 98 posts
I was able to get all of the data to populate, but only on a cached chrome page. No data on opera with a vpn session or uncached firefox.


The login page still doesn't have any users in it.
StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers table and change the commish password.

http://ootp.biz/statslab/login.php
__________________

Last edited by andjbock; 01-10-2019 at 11:34 PM.
andjbock is offline   Reply With Quote
Old 03-08-2019, 02:23 PM   #316
Robmeister89
Minors (Double A)
 
Join Date: Nov 2015
Posts: 144
Thanks: 62
Thanked 42x in 18 posts
So I just did a fresh install and I'm being told 'baseball' password is not correct?
Robmeister89 is offline   Reply With Quote
Old 03-08-2019, 05:17 PM   #317
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 Robmeister89 View Post
So I just did a fresh install and I'm being told 'baseball' password is not correct?
That's still the default password. Most likely an issue with saving the password. If you need assistance IM me details and I'll take a look.
__________________
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
Thank you for this post:
Robmeister89 (03-08-2019)
Old 05-11-2019, 11:06 AM   #318
McLite
Minors (Rookie Ball)
 
Join Date: Sep 2009
Posts: 49
Thanks: 12
Thanked 2x in 2 posts
Love the program...been a staple of our online league for 50 seasons. We just upgraded to the latest version.

Two issues related to HoF voting I was hoping someone could help me with.

1. Do all batters show up as DH as ours do? In the admin screen the right position is listed and when they get inducted as well...but in the actual Voting page they don't.
2. The HoF voting section appears to still have the bug where reward winners who finished 2nd or 3rd get credited as the winner, but then the link on the HoF voting page to their StatsLab page has the correct information.
McLite is offline   Reply With Quote
Old 05-13-2019, 10:58 PM   #319
84CubsFan
Major Leagues
 
84CubsFan's Avatar
 
Join Date: Mar 2003
Posts: 367
Thanks: 0
Thanked 0x in 0 posts
Any pointers on how to fix this mess with the playoffs page?

https://www.theuqbl.com/StatsLab/playoffs.php

Three round postseason. Wild Card Round best of five. Pennant Series best of seven. Championship Series best of 7.

Statslab is reading the Pennant Series as another Wild Card round.
84CubsFan is offline   Reply With Quote
Old 05-14-2019, 03:06 PM   #320
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 McLite View Post
Love the program...been a staple of our online league for 50 seasons. We just upgraded to the latest version.

Two issues related to HoF voting I was hoping someone could help me with.

1. Do all batters show up as DH as ours do? In the admin screen the right position is listed and when they get inducted as well...but in the actual Voting page they don't.
2. The HoF voting section appears to still have the bug where reward winners who finished 2nd or 3rd get credited as the winner, but then the link on the HoF voting page to their StatsLab page has the correct information.
#1 - Your league doesn't appear to have any fielding stats in StatsLab from prior to 2028. That would be why all the players show up as DH's.

#2 - Thanks for pointing that out. I will get it fixed in a patch.

Quote:
Originally Posted by 84CubsFan View Post
Any pointers on how to fix this mess with the playoffs page?

https://www.theuqbl.com/StatsLab/playoffs.php

Three round postseason. Wild Card Round best of five. Pennant Series best of seven. Championship Series best of 7.

Statslab is reading the Pennant Series as another Wild Card round.
This will be fixed in the next patch.
__________________
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
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 04:46 PM.

 

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