Issues moving to OOTP17

SDSUBaseball · 05-17-2016, 03:37 PM

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.

Cool Papa Bell · 05-17-2016, 05:17 PM

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

SDSUBaseball · 05-17-2016, 07:51 PM

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

Eddie Paxil · 05-20-2016, 04:32 PM

I've run into the same issue as SDSU baseball. All my info stayed the same. Any ideas would be appreciated?

Cool Papa Bell · 05-20-2016, 04:52 PM

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

geoffmatt17 · 06-05-2016, 08:50 PM

Quote:

Originally Posted by SDSUBaseball

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?

anthonywvalentine · 06-05-2016, 10:04 PM

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.

greenrebellion · 08-21-2016, 09:02 AM

My league just converted to OOTP 17 and we are having the exact same problem when uploading reports. Anyone know how to resolve?

pbar25 · 08-21-2016, 04:14 PM

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

Sandberg · 08-25-2016, 12:47 PM

Quote:

Originally Posted by greenrebellion

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.

rutri01 · 08-25-2016, 01:10 PM

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.

pbar25 · 08-26-2016, 12:08 AM

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

Painmantle · 08-28-2016, 09:59 AM

Quote:

Originally Posted by SDSUBaseball

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

TGH-Adfabre · 08-28-2016, 10:33 AM

Sorry to hear that, that is a rough mistake.

Eddie Paxil · 09-05-2016, 04:36 PM

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."

05-17-2016, 03:37 PM	#1
SDSUBaseball 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
Cool Papa Bell 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-20-2016, 04:32 PM	#4
Eddie Paxil 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
Cool Papa Bell 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

08-21-2016, 09:02 AM	#8
greenrebellion Minors (Triple A) Join Date: Jun 2004 Posts: 292	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.*

06-05-2016, 10:04 PM	#7
anthonywvalentine 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
pbar25 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 Attached Images __________________ New York Mets - Asahi2 Baseball

08-25-2016, 01:10 PM	#11
rutri01 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
pbar25 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, 10:33 AM	#14
TGH-Adfabre 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
Eddie Paxil 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.