BOSI v2.001 released

CommishJoe · 07-15-2004, 11:31 PM

http://www.bosicentral.com . If you haven't installed yet, just download the main file. The patch is for those who have already installed and need to upgrade.

v2.001
-- Changed the table types from Inno DB to MyISAM. One server had a MAJOR issue with Inno, so we didn't want to take the chance of the same thing happening to others. You'll need to run the upgrade_2001.sql script in PhPMyAdmin(or other MySQL tool) to make these changes. No data will be lost.

-- Changed the schedule importer. Since the table types changed, child tables aren't cleaned up after a record from the master table is deleted. Code was added to delete from bosi_SCHEDULE_INNINGS first, then bosi_SCHEDULE_GAME, then bosi_SCHEDULE.

-- Added the draft order report to the Reports menu

-- Added a home link on the main menu to get you to the index page

-- Changed the HOME link in the admin menu to go to the index page (news).

-- Added some code to the career importer resetting the default PhP execution time limit. Some customers were having issues with it timing out.

Another Mike D · 07-16-2004, 08:51 AM

Good to hear, Joe. One quick question...has the MVP/Cy Young thing been fixed? I'd love to edit it in the CSVs myself, but I'd have to do it everytime it generated new CSVs I think. Again, good job fixing the database issues.

CommishJoe · 07-16-2004, 09:06 AM

BAH! I was in such a hurry to get the DB table types changed that I forgot this issue. I'll get it into v2.002.

Another Mike D · 07-16-2004, 09:09 AM

Quote:

Originally Posted by CommishJoe

BAH! I was in such a hurry to get the DB table types changed that I forgot this issue. I'll get it into v2.002.

No prob, it's just for vain types like me who like to see all the awards after their studs...

CommishJoe · 07-16-2004, 09:12 AM

The info is being stored, just not reported. Markus stores both batter and pitcher of the year awards in the same field. I wasn't expecting that

octones · 07-16-2004, 09:36 AM

Is the database upgrade script released yet?

CommishJoe · 07-16-2004, 10:44 AM

From v1 to v2? No. I had to re-structure the DB from Inno to MySQL so that is what this release centered around. I hate giving up Inno, but it's just not stable enough

I will be working on the upgrade script this weekend and hope to have it released by late next week.

GoldenGlove · 07-17-2004, 01:52 PM

I may have missed something, but how do you updated to version 2 if you are using the central server. Currently ISBL is using version 1, but we have since switched to OOTP6.

CommishJoe · 07-17-2004, 05:14 PM

Quote:

Originally Posted by GoldenGlove

I may have missed something, but how do you updated to version 2 if you are using the central server. Currently ISBL is using version 1, but we have since switched to OOTP6.

I will be upgrading the central server. I should be done in about a week.

GoldenGlove · 07-17-2004, 08:51 PM

Thank you.

A.J. Holz · 07-18-2004, 01:19 AM

Thanks for all your great work on this Joe, looks like it's going to be fantastic and every bit a "must-have" as BOSI v1 was for OOTP5.

JQLorenz · 07-25-2004, 02:48 PM

Joe,

Was the BOSI CSV exporter ever fixed for v2?
I wrote a development script and noticed that the vsL and vsR for some fields were identical and wrong for some ratings (contact being one)

CommishJoe · 07-25-2004, 03:13 PM

Quote:

Originally Posted by JQLorenz

Joe,

Was the BOSI CSV exporter ever fixed for v2?
I wrote a development script and noticed that the vsL and vsR for some fields were identical and wrong for some ratings (contact being one)

Download the one on BOSI Central. If it didn't fix the issue, let me know.

07-15-2004, 11:31 PM	#1 (permalink)
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,009 Thanks: 30 Thanked 69x in 40 posts	BOSI v2.001 released http://www.bosicentral.com . If you haven't installed yet, just download the main file. The patch is for those who have already installed and need to upgrade. v2.001 -- Changed the table types from Inno DB to MyISAM. One server had a MAJOR issue with Inno, so we didn't want to take the chance of the same thing happening to others. You'll need to run the upgrade_2001.sql script in PhPMyAdmin(or other MySQL tool) to make these changes. No data will be lost. -- Changed the schedule importer. Since the table types changed, child tables aren't cleaned up after a record from the master table is deleted. Code was added to delete from bosi_SCHEDULE_INNINGS first, then bosi_SCHEDULE_GAME, then bosi_SCHEDULE. -- Added the draft order report to the Reports menu -- Added a home link on the main menu to get you to the index page -- Changed the HOME link in the admin menu to go to the index page (news). -- Added some code to the career importer resetting the default PhP execution time limit. Some customers were having issues with it timing out. __________________ Joe Question to fiance -- How much do you love me? Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.

07-16-2004, 08:51 AM	#2 (permalink)
Another Mike D All Star Reserve Join Date: Feb 2002 Location: atl Posts: 832 Thanks: 0 Thanked 2x in 2 posts	Good to hear, Joe. One quick question...has the MVP/Cy Young thing been fixed? I'd love to edit it in the CSVs myself, but I'd have to do it everytime it generated new CSVs I think. Again, good job fixing the database issues. __________________ San Diego Padres NexGen Baseball League Cleveland Indians United Baseball League Co-commissioner of United Baseball League

07-16-2004, 09:06 AM	#3 (permalink)
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,009 Thanks: 30 Thanked 69x in 40 posts	BAH! I was in such a hurry to get the DB table types changed that I forgot this issue. I'll get it into v2.002. __________________ Joe Question to fiance -- How much do you love me? Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.

07-16-2004, 09:12 AM	#5 (permalink)
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,009 Thanks: 30 Thanked 69x in 40 posts	The info is being stored, just not reported. Markus stores both batter and pitcher of the year awards in the same field. I wasn't expecting that __________________ Joe Question to fiance -- How much do you love me? Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.

07-16-2004, 09:36 AM	#6 (permalink)
octones Minors (Triple A) Join Date: Nov 2002 Location: Dayton, OH Posts: 226 Thanks: 0 Thanked 0x in 0 posts	Is the database upgrade script released yet? __________________

07-16-2004, 10:44 AM	#7 (permalink)
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,009 Thanks: 30 Thanked 69x in 40 posts	From v1 to v2? No. I had to re-structure the DB from Inno to MySQL so that is what this release centered around. I hate giving up Inno, but it's just not stable enough I will be working on the upgrade script this weekend and hope to have it released by late next week. __________________ Joe Question to fiance -- How much do you love me? Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.

07-17-2004, 01:52 PM	#8 (permalink)
GoldenGlove Major Leagues Join Date: Feb 2004 Posts: 339 Thanks: 0 Thanked 0x in 0 posts	I may have missed something, but how do you updated to version 2 if you are using the central server. Currently ISBL is using version 1, but we have since switched to OOTP6. __________________ ISBL - New York Yankees B.I.G. - Oakland Athletics TheMLB - Cleveland Indians

07-17-2004, 08:51 PM	#10 (permalink)
GoldenGlove Major Leagues Join Date: Feb 2004 Posts: 339 Thanks: 0 Thanked 0x in 0 posts	Thank you. __________________ ISBL - New York Yankees B.I.G. - Oakland Athletics TheMLB - Cleveland Indians

07-18-2004, 01:19 AM	#11 (permalink)
A.J. Holz All Star Reserve Join Date: Apr 2002 Location: Atlanta, GA Posts: 650 Thanks: 0 Thanked 0x in 0 posts	Thanks for all your great work on this Joe, looks like it's going to be fantastic and every bit a "must-have" as BOSI v1 was for OOTP5. __________________ NABA - Tijuana Toros / Commish ORB - Oakland Athletics (former owner) MBBA - Seattle Storm JOBL - Grand Forks Varmints (former owner) FIBB - Chicago Fire TMBU - Tulsa Tomcats (former owner) ACL - Oakland A's (former owner) ACB - Rockville Superbas

07-25-2004, 02:48 PM	#12 (permalink)
JQLorenz Minors (Double A) Join Date: Dec 2001 Location: Colorado Posts: 109 Thanks: 0 Thanked 0x in 0 posts	Joe, Was the BOSI CSV exporter ever fixed for v2? I wrote a development script and noticed that the vsL and vsR for some fields were identical and wrong for some ratings (contact being one)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode