Home | Webstore
Latest News: OOTP 18.8.76 Update Available - OOTP 18 Available - FHM 4 Available - MLB Manager 2017 Available Now

Announcing OOTP Baseball 19: Pre-order now, save 10%, and get early access!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 18 > 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-20-2017, 10:10 PM   #281
Winnipeg59
All Star Reserve
 
Join Date: Dec 2010
Location: Canada
Posts: 730
Blog Entries: 14
Thanks: 353
Thanked 168x in 131 posts
Have assumed an online league as Commissioner.
League uses Statslab.
Current setup is a bit flaky in a couple of areas.

I have the Admin page working OK now, but have a couple of "header issues", the first of which shows on the login page. I am not a coding person, so would love some help! And if I can get some help on this, I'll continue with the other trouble spot, but this first...
Attached Images
Image 
Winnipeg59 is offline   Reply With Quote
Old 07-21-2017, 01:57 AM   #282
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,447
Thanks: 162
Thanked 1,152x in 436 posts
You've got an issue with dbopen.php that is likely due to a formatting error of some sort when the credentials were entered. Check to make sure the quotes are all valid... some text editors insert different kinds of quotes. If that's not making sense, PM me with details and I can assist.
__________________
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-21-2017, 04:21 PM   #283
Jsmitty
Bat Boy
 
Join Date: Feb 2015
Posts: 18
Thanks: 0
Thanked 1x in 1 post
currently having a draft setup issue with statslab. 24 team league, everything is enabled and ready to go, lists and orders are in, however on the draft board itself every team in the league is showing as open-no auto in red beside their name.

not sure why it is not recognizing the human gm's. any ideas? thanks!
Jsmitty is offline   Reply With Quote
Old 07-24-2017, 09:39 PM   #284
Winnipeg59
All Star Reserve
 
Join Date: Dec 2010
Location: Canada
Posts: 730
Blog Entries: 14
Thanks: 353
Thanked 168x in 131 posts
Another rookie Statslab question.

At this time I am uploading OOTP html reports for an online league, then creating and uploading a MySQL dump for Statslab. So far so good.

Question: Is there any way to upload one set of files for both? Or point both to same set of files, to upload required info only once?
Winnipeg59 is offline   Reply With Quote
Old 08-20-2017, 07:53 AM   #285
Spindel
All Star Reserve
 
Spindel's Avatar
 
Join Date: Oct 2003
Location: Lambertville, NJ
Posts: 712
Thanks: 95
Thanked 305x in 137 posts
I'm getting ready to update from StatsLab 16 to 18. What do I do?
__________________
ULB - Commissioner, Owner of the Phoenix Fire
Home Page | Report | File | StatsLab | ULB on Twitter | ULB Forum

Simcentral.net

My MLB Uniforms
Spindel is offline   Reply With Quote
Old 08-30-2017, 11:57 AM   #286
b10wick
Minors (Triple A)
 
b10wick's Avatar
 
Join Date: Jun 2008
Location: South Jersey
Posts: 214
Thanks: 51
Thanked 16x in 13 posts
If there is anybody online who has a couple of free minutes and could help me out with an install issue I'm having, please PM me. I've never used Statslab before and first time commish, so I'm trying to follow along with the steps but I've got zero experience with SQL.
__________________
b10wick is offline   Reply With Quote
Old 09-20-2017, 02:25 PM   #287
sjgmoney
Minors (Rookie Ball)
 
Join Date: Jun 2015
Posts: 37
Thanks: 1
Thanked 4x in 3 posts
Having an issue importing a draft into StatsLab, getting duplicate players. The underlying Excel file does not have duplicates but after getting imported it does for many players (not all).

Anybody have a clue here?

Sent from my 2PS64 using Tapatalk
sjgmoney is offline   Reply With Quote
Old 12-03-2017, 09:32 PM   #288
kleric
Minors (Double A)
 
Join Date: Dec 2003
Location: Denver, CO
Posts: 153
Thanks: 2
Thanked 1x in 1 post
Trying to upgrade to v18 version of StatsLab. If I replace the whole folder, I get these errors all over every page:

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/<snip>/ttbl/StatsLab/manager_records.php on line 14

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/<snip>/ttbl/StatsLab/manager_records.php on line 15

If I leave v16 version of StatsLab in place, then just copy over, say, the manager_records.php file, I still get the exact same error.

Any help anyone?
Thanks.
kleric is offline   Reply With Quote
Old 12-04-2017, 12:49 PM   #289
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,447
Thanks: 162
Thanked 1,152x in 436 posts
You need to update the dbopen.php file in your sql uploads folder, too.
__________________
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-04-2017, 12:52 PM   #290
kleric
Minors (Double A)
 
Join Date: Dec 2003
Location: Denver, CO
Posts: 153
Thanks: 2
Thanked 1x in 1 post
Quote:
Originally Posted by fhomess View Post
You need to update the dbopen.php file in your sql uploads folder, too.

With what info?
kleric is offline   Reply With Quote
Old 12-04-2017, 12:53 PM   #291
kleric
Minors (Double A)
 
Join Date: Dec 2003
Location: Denver, CO
Posts: 153
Thanks: 2
Thanked 1x in 1 post
Quote:
Originally Posted by kleric View Post
With what info?

AH nevermind, I see what changed. Thanks!
kleric is offline   Reply With Quote
Old 12-04-2017, 03:17 PM   #292
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,447
Thanks: 162
Thanked 1,152x in 436 posts
Quote:
Originally Posted by kleric View Post
AH nevermind, I see what changed. Thanks!
For those who don't... StatsLab18 has a new version of dbopen.php. You should be able to copy the settings from your previous dbopen.php to the new one and then install that one in the uploads folder.
__________________
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-26-2017, 01:38 PM   #293
b10wick
Minors (Triple A)
 
b10wick's Avatar
 
Join Date: Jun 2008
Location: South Jersey
Posts: 214
Thanks: 51
Thanked 16x in 13 posts
Is there anybody who would be willing to go in and fix my StatsLab errors I'm receiving for me? I'd be willing to send some money to help compensate for your time. I'm not very savvy when it comes to this stuff and I started receiving an error out of nowhere.

ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/thesala/public_html/StatsLab/nav_functions.php on line 371

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/thesala/public_html/StatsLab/nav_functions.php on line 679

If interested, please PM me.
__________________
b10wick is offline   Reply With Quote
Old 02-19-2018, 08:52 AM   #294
CT-Sox-Fan
Minors (Double A)
 
Join Date: Sep 2006
Posts: 114
Thanks: 1
Thanked 5x in 5 posts
Not all draft pool players showing up

When I import the draft pool, I get a message that it uploaded 1200 players. When I then Generate Auto Draft List, it only adds 531 players and I have this message. I get a similar message with uploading the draft order and the draft eligible players. The 3 screen images of the messages are included below.

No idea if it's significant but the 531 players loaded seem to be the lower end of the potential scale of players in the draft. None of the "future star" players are loaded.
Attached Images
Image Image Image 
__________________
---------------------------------
Dave A.

MLBD- Boston Red Sox GM and Commissioner, http://mlbdreamsootpsim.com

PCBL - Clearwater Beachcombers
CT-Sox-Fan is offline   Reply With Quote
Old 02-19-2018, 09:46 AM   #295
CT-Sox-Fan
Minors (Double A)
 
Join Date: Sep 2006
Posts: 114
Thanks: 1
Thanked 5x in 5 posts
NVM. Exported the SQL files with replace accents checked, regenerated and all is well.
__________________
---------------------------------
Dave A.

MLBD- Boston Red Sox GM and Commissioner, http://mlbdreamsootpsim.com

PCBL - Clearwater Beachcombers
CT-Sox-Fan 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:47 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 - 2018, vBulletin Solutions, Inc.
Copyright © 2015 Out of the Park Developments