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

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Out of the Park Baseball 17 > OOTP 17 - Online Leagues

OOTP 17 - Online Leagues Want to create or join an OOTP 17 online league? This is the right forum for you.

Reply
 
Thread Tools
Old 05-17-2016, 03:37 PM   #1
SDSUBaseball
Bat Boy
 
Join Date: Feb 2009
Posts: 8
Thanks: 0
Thanked 0x in 0 posts
Issues moving to OOTP17

Our league made the move to 17 this offseason and we have run into a couple issues. I was wondering if anyone else encountered these issues and if they found fixes.

I can't update the online reports. I get a database error.

GMs can't make use of all their money available for FA. Owners are rejecting offers even though they still have money available.

Any help would be appreciated.
SDSUBaseball is offline   Reply With Quote
Old 05-17-2016, 05:17 PM   #2
Cool Papa Bell
Minors (Double A)
 
Cool Papa Bell's Avatar
 
Join Date: Jun 2006
Posts: 145
Thanks: 3
Thanked 15x in 11 posts
We had some issues in the NAPBBP as well, one of which was the league reports on our website. Not sure what webhost you're using, but check your on-line league settings to make sure they match what you had before. For some reason, 17 started naming them in all small letters napbbp rather than all caps NAPBBP that it was before. Not sure if that is the same issue you are having, but it did mess up updating the league reports on-line as well as file uploads and downloads. Hope that helps!

League Website
NAPBBP

NAPBBP TV
https://www.twitch.tv/napbbp_commish

Stats, Standings, History
BNN Home Page

League Forum
The NAPBBP Chronicles ? Index page
__________________
"About race, I'm going to say this. If you're green or purple or whatever color, you can play for me if I think you can help this ballclub.That's all I'm going to say about race."
Leo Durocher, New York Giants manager, 1946
Cool Papa Bell is offline   Reply With Quote
Thank you for this post:
TGH-Adfabre (08-28-2016)
Old 05-17-2016, 07:51 PM   #3
SDSUBaseball
Bat Boy
 
Join Date: Feb 2009
Posts: 8
Thanks: 0
Thanked 0x in 0 posts
The settings seem the same. This is what i get:
Code:
Successfully unpacked the reports.tar.gz file...

Successfully touched table reports
Successfully touched table reports_content_a
Successfully touched table reports_content_b
Successfully touched table reports_content_c
Successfully touched table reports_content_d
Successfully touched table reports_content_e
Successfully touched table reports_content_f
Successfully touched table reports_content_g
Successfully touched table reports_content_h
Successfully touched table reports_content_i
Successfully touched table reports_content_j
Successfully touched table reports_content_k
Successfully touched table reports_content_l
Successfully touched table reports_content_m
Successfully touched table reports_content_n
Successfully touched table reports_content_o
Successfully touched table reports_content_p
Successfully touched table reports_content_q
Successfully touched table reports_content_r
Successfully touched table reports_content_s
Successfully touched table reports_content_t
Successfully touched table reports_content_u
Successfully touched table reports_content_v
Successfully touched table reports_content_w
Successfully touched table reports_content_x
Successfully touched table reports_content_y
Successfully touched table reports_content_z
Opened  reports file reports_1.txt...{query} Database Error : 1054 : Unknown  column 'md5hash' in 'field list' : SELECT id, md5hash FROM reports WHERE  (type="b" AND name="league_100_home") LIMIT 1
SDSUBaseball is offline   Reply With Quote
Old 05-20-2016, 04:32 PM   #4
Eddie Paxil
Major Leagues
 
Eddie Paxil's Avatar
 
Join Date: May 2007
Location: Kentucky
Posts: 368
Thanks: 57
Thanked 86x in 67 posts
I've run into the same issue as SDSU baseball. All my info stayed the same. Any ideas would be appreciated?
__________________
Eddie Paxil

OOTP since 2007
Commissioner of the OMLB
GM of the OMLB New Jersey Pioneers
Eddie Paxil is offline   Reply With Quote
Old 05-20-2016, 04:52 PM   #5
Cool Papa Bell
Minors (Double A)
 
Cool Papa Bell's Avatar
 
Join Date: Jun 2006
Posts: 145
Thanks: 3
Thanked 15x in 11 posts
Sorry guys, wish I could help but doesn't appear that my webhost uses the same file format as maybe yours does. When I ftp my reports.tar.gz to the website, I need to rename it to NAPBBP.tar.gz in order to unzip and update the reports on the site. My issue came from version 17 changing it to small letters from version 15 that we were using which was in caps. It sounds like there is a similar type of issue with the upgrade but you probably need to get with your webhost to find out what it is.

There was at least 1 member of the league that had a file upload/download issue due to his passive/active settings but doubt that had anything to do with the report upload. Maybe try reviewing/updating your on-line league settings again?

League Website
NAPBBP

NAPBBP TV
https://www.twitch.tv/napbbp_commish

Stats, Standings, History
BNN Home Page

League Forum
The NAPBBP Chronicles ? Index page
__________________
"About race, I'm going to say this. If you're green or purple or whatever color, you can play for me if I think you can help this ballclub.That's all I'm going to say about race."
Leo Durocher, New York Giants manager, 1946
Cool Papa Bell is offline   Reply With Quote
Old 06-05-2016, 08:50 PM   #6
geoffmatt17
Minors (Triple A)
 
Join Date: Oct 2012
Location: Pennsylvania
Posts: 268
Thanks: 253
Thanked 100x in 53 posts
Quote:
Originally Posted by SDSUBaseball View Post
The settings seem the same. This is what i get:
Code:
Successfully unpacked the reports.tar.gz file...

Successfully touched table reports
Successfully touched table reports_content_a
Successfully touched table reports_content_b
Successfully touched table reports_content_c
Successfully touched table reports_content_d
Successfully touched table reports_content_e
Successfully touched table reports_content_f
Successfully touched table reports_content_g
Successfully touched table reports_content_h
Successfully touched table reports_content_i
Successfully touched table reports_content_j
Successfully touched table reports_content_k
Successfully touched table reports_content_l
Successfully touched table reports_content_m
Successfully touched table reports_content_n
Successfully touched table reports_content_o
Successfully touched table reports_content_p
Successfully touched table reports_content_q
Successfully touched table reports_content_r
Successfully touched table reports_content_s
Successfully touched table reports_content_t
Successfully touched table reports_content_u
Successfully touched table reports_content_v
Successfully touched table reports_content_w
Successfully touched table reports_content_x
Successfully touched table reports_content_y
Successfully touched table reports_content_z
Opened  reports file reports_1.txt...{query} Database Error : 1054 : Unknown  column 'md5hash' in 'field list' : SELECT id, md5hash FROM reports WHERE  (type="b" AND name="league_100_home") LIMIT 1
I have the same issue with my reports after converting. Have you figured this out yet?
__________________
United Baseball Association - San Francisco Spartans (Commish)
FOD - Miami Mutiny
PBF - Port Moresby Wigmen
SABR - Tampa Bay Rays
XFBL - New York Mets
WBL - San Cristobal Tiburones
NIZE - Milwaukee Brewers
FCB - Chicago White Sox

geoffmatt17 is offline   Reply With Quote
Old 06-05-2016, 10:04 PM   #7
anthonywvalentine
Major Leagues
 
anthonywvalentine's Avatar
 
Join Date: Jul 2010
Location: Connecticut
Posts: 391
Thanks: 95
Thanked 108x in 65 posts
Ive had to create the files, archive, and upload in game through the reports center than extract manually.

Problem is it changes the web address and puts a /news/html/ in the url. Then all images need to be fixed too. Not sure why they broke in conversions from 16.
anthonywvalentine is offline   Reply With Quote
Old 08-21-2016, 09:02 AM   #8
greenrebellion
Minors (Triple A)
 
greenrebellion's Avatar
 
Join Date: Jun 2004
Posts: 292
Thanks: 40
Thanked 57x in 15 posts
My league just converted to OOTP 17 and we are having the exact same problem when uploading reports. Anyone know how to resolve?
__________________
Commissioner of the PBDL - A promotion/relegation fictional online league.
greenrebellion is offline   Reply With Quote
Old 08-21-2016, 04:14 PM   #9
pbar25
Major Leagues
 
pbar25's Avatar
 
Join Date: Mar 2007
Posts: 340
Thanks: 17
Thanked 7x in 6 posts
Same with our league

I believe I need to log into the sql server and manually drop the previous reports tables, but I'm not positive
Attached Images
Image 
__________________
New York Mets - Asahi2 Baseball
pbar25 is offline   Reply With Quote
Old 08-25-2016, 12:47 PM   #10
Sandberg
All Star Reserve
 
Sandberg's Avatar
 
Join Date: Dec 2001
Location: Minneapolis, MN
Posts: 528
Blog Entries: 1
Thanks: 5
Thanked 7x in 6 posts
Quote:
Originally Posted by greenrebellion View Post
My league just converted to OOTP 17 and we are having the exact same problem when uploading reports. Anyone know how to resolve?
Pretty frustrating that there isn't an easy button for this. It seems like anyone who has resolved their issues disappears from these threads...I have to believe someone has figured this out and would be willing to help?

Asahi2 is having the same issues. I've tried everything and now am exploring how to upload manually.
Sandberg is offline   Reply With Quote
Old 08-25-2016, 01:10 PM   #11
rutri01
All Star Reserve
 
rutri01's Avatar
 
Join Date: Dec 2007
Posts: 515
Thanks: 96
Thanked 35x in 28 posts
I had issues an the NABL and contacted Allsim who is my provider. He had to do something/change something and it works fine now. But it wasn't as easy/instant as passed upgraded with the html for me.
__________________
Rich
Commish:
TMBU GM: CT Crosscutters
NABL GM: North Shore Honu
FEBL GM: Wisconsin Capitals
email:

Former commish of AHIBA and NABL
rutri01 is offline   Reply With Quote
Old 08-26-2016, 12:08 AM   #12
pbar25
Major Leagues
 
pbar25's Avatar
 
Join Date: Mar 2007
Posts: 340
Thanks: 17
Thanked 7x in 6 posts
upgrading league to ootp17
Step 1: navigate via ftp to your league's report folder; delete the entire contents of your reports folder (after verifying you don't have anything important that you personally stored within it for whatever reason, or back it up)

Step 2: rebuild your php script files via game/game settings/online league/online league settings/create php server script files
You will need to enter in the correct information in order to build the correct script files. Create a brand new sql database.

Step 3: after creating your 3 script files upload them into your reports folder which should be empty

Step 4: upload your reports
__________________
New York Mets - Asahi2 Baseball
pbar25 is offline   Reply With Quote
Old 08-28-2016, 09:59 AM   #13
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,025
Thanks: 612
Thanked 2,187x in 1,759 posts
Quote:
Originally Posted by SDSUBaseball View Post
Our league made the move to 17 this offseason and we have run into a couple issues. I was wondering if anyone else encountered these issues and if they found fixes.

I can't update the online reports. I get a database error.

.
Any help would be appreciated.
Ok, I had this issue, you need to go into your cpanel and dump the old reports files. Then re-load reports as usual and they will work. From my Site provider:

Quote:
" You need to drop all the tables in the reports database via cPanel > phpMyAdmin. After that, run your reports again and they should work fine.
"

WARNING be sure you are dropping the correct files. I mistakenly dumped the wrong files and inadvertently deleted my Forum of 3 years and 18 Seasons in an online league. Once I dropped the correct files it worked fine, but I had no backup for my forum and my only recourse to save it was pay for a data mining recovery ($200+), so needless to say my forum is gone and we moved to Slack full time LOL

I would highly recommend backing everything up before trying this fix
__________________
“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

Last edited by Painmantle; 08-28-2016 at 10:02 AM.
Painmantle is offline   Reply With Quote
Thank you for this post:
TGH-Adfabre (08-28-2016)
Old 08-28-2016, 10:33 AM   #14
TGH-Adfabre
Hall Of Famer
 
Join Date: Sep 2007
Posts: 2,545
Thanks: 968
Thanked 594x in 475 posts
Sorry to hear that, that is a rough mistake.
__________________
You mock me, therefore I am
My wife
TGH-Adfabre is offline   Reply With Quote
Old 09-05-2016, 04:36 PM   #15
Eddie Paxil
Major Leagues
 
Eddie Paxil's Avatar
 
Join Date: May 2007
Location: Kentucky
Posts: 368
Thanks: 57
Thanked 86x in 67 posts
I haven't resolved the issues with the "easier" and more common way to do the reports. That still isn't working for me.

Here's what I've done now:

1. Go to league settings/ online league/ then "create/ upload reports"
2.Select which reports you want to create, I recommend breaking them up vertically not horizontally, if you intend to do this in parts
3. Now Create Reports
4. Next Page Create Archive
5. Now go to the site's Cpanel
6. Go Files/ File Manager
7. Select Web Root then click Go
8. go game/ lgreports/ find reports.tar.gz and choose extract on top.
9. it'll create a "news" file go in there and move the reports files from in there out to lgreports, but still within their respective folders like "players."
__________________
Eddie Paxil

OOTP since 2007
Commissioner of the OMLB
GM of the OMLB New Jersey Pioneers
Eddie Paxil 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 07:12 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