|
||||
|
|
OOTP 17 - Online Leagues Want to create or join an OOTP 17 online league? This is the right forum for you. |
|
Thread Tools |
05-17-2016, 03:37 PM | #1 |
Bat Boy
Join Date: Feb 2009
Posts: 8
|
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. |
05-17-2016, 05:17 PM | #2 |
Major Leagues
Join Date: Jun 2006
Posts: 415
|
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 |
05-17-2016, 07:51 PM | #3 |
Bat Boy
Join Date: Feb 2009
Posts: 8
|
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 |
05-20-2016, 04:32 PM | #4 |
Major Leagues
Join Date: May 2007
Location: Fort Wayne, Indiana
Posts: 411
|
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 Commissioner of the NBBU GM of theNBBU Hoboken Knickerbockers Follow the NBBU Dynasty Thread Here. |
05-20-2016, 04:52 PM | #5 |
Major Leagues
Join Date: Jun 2006
Posts: 415
|
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 |
06-05-2016, 08:50 PM | #6 | |
Major Leagues
Join Date: Oct 2012
Location: Pennsylvania
Posts: 305
|
Quote:
__________________
United Baseball Association - San Francisco Spartans (Commish) FOD - Miami Mutiny PBF - Port Moresby Wigmen SABR - Tampa Bay Rays FCB - Chicago White Sox FSL - Oklahoma City Red Hawks |
|
06-05-2016, 10:04 PM | #7 |
All Star Reserve
Join Date: Jul 2010
Location: Connecticut
Posts: 647
|
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. |
08-21-2016, 04:14 PM | #9 |
Major Leagues
Join Date: Mar 2007
Posts: 343
|
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
__________________
New York Mets - Asahi2 Baseball |
08-25-2016, 12:47 PM | #10 | |
All Star Reserve
|
Quote:
Asahi2 is having the same issues. I've tried everything and now am exploring how to upload manually. |
|
08-25-2016, 01:10 PM | #11 |
All Star Reserve
Join Date: Dec 2007
Posts: 515
|
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.
|
08-26-2016, 12:08 AM | #12 |
Major Leagues
Join Date: Mar 2007
Posts: 343
|
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 |
08-28-2016, 09:59 AM | #13 | ||
Hall Of Famer
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
|
Quote:
Quote:
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. |
||
08-28-2016, 10:33 AM | #14 |
Hall Of Famer
Join Date: Sep 2007
Posts: 2,599
|
Sorry to hear that, that is a rough mistake.
__________________
You mock me, therefore I am My wife |
09-05-2016, 04:36 PM | #15 |
Major Leagues
Join Date: May 2007
Location: Fort Wayne, Indiana
Posts: 411
|
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 Commissioner of the NBBU GM of theNBBU Hoboken Knickerbockers Follow the NBBU Dynasty Thread Here. |
Bookmarks |
|
|