BOSI Question

Raderick · 07-31-2006, 04:13 AM

I'm trying to install a copy of BOSI on my computer, and I am where it asks me to go into PHPMyAdmin and import the tables.sql table. When I click on SQL, the option to browse for the file is not available. It might be this way because I'm using an updated version than when this was released.

Any help would be awesome!

UKrookie · 07-31-2006, 12:21 PM

If you select your database then select import the browse option is available.

Raderick · 08-01-2006, 07:50 AM

Quote:

Originally Posted by UKrookie

If you select your database then select import the browse option is available.

Thanks for catching that. However, when I attempt to import, it only takes in 3 of the 26 databases.

UKrookie · 08-01-2006, 10:25 AM

Quote:

However, when I attempt to import, it only takes in 3 of the 26 databases.

Not sure what the '26 databases' are, tables.sql should create 68 tables in your bosi database.

Here are the original instalation notes provided with bosi perhaps they will help...http://www.ootpsimleagues.com/BOSI%2...ion%20Help.htm

Raderick · 08-01-2006, 08:20 PM

Quote:

Originally Posted by UKrookie

Not sure what the '26 databases' are, tables.sql should create 68 tables in your bosi database.

Here are the original instalation notes provided with bosi perhaps they will help...http://www.ootpsimleagues.com/BOSI%2...ion%20Help.htm

I too don't know where I got 68 databases from. I must have been too tired or something.

Raderick · 08-04-2006, 08:48 PM

When I import, it still only imports three tables.

Raderick · 08-11-2006, 11:03 PM

Bump

Raderick · 08-13-2006, 09:53 PM

Now I know there has to be some of you who know Php enough to help me out here.

DaveHorn · 08-22-2006, 10:33 AM

Been helping Cody with this issue.

The problem is newer version of MySQL that have come out since BOSI was released has issues with creating tables that set timestamp default value to null.

Chaning the sql load file so it doesn't set up timestamps with default nulls solves the problem.

Raderick · 08-23-2006, 12:25 AM

Thanks Dave!

07-31-2006, 04:13 AM	#1
Raderick Hall Of Famer Join Date: Oct 2003 Location: San Diego, California Posts: 2,737	BOSI Question I'm trying to install a copy of BOSI on my computer, and I am where it asks me to go into PHPMyAdmin and import the tables.sql table. When I click on SQL, the option to browse for the file is not available. It might be this way because I'm using an updated version than when this was released. Any help would be awesome! __________________

07-31-2006, 12:21 PM	#2
UKrookie Minors (Double A) Join Date: Dec 2002 Location: Edinburgh, Scotland Posts: 176	If you select your database then select import the browse option is available. __________________ James IBA Reference WBL Tokyo Samurai UKBL Boston Red Sox NARBL SF Giants

08-04-2006, 08:48 PM	#6
Raderick Hall Of Famer Join Date: Oct 2003 Location: San Diego, California Posts: 2,737	When I import, it still only imports three tables. __________________

08-11-2006, 11:03 PM	#7
Raderick Hall Of Famer Join Date: Oct 2003 Location: San Diego, California Posts: 2,737	Bump __________________

08-13-2006, 09:53 PM	#8
Raderick Hall Of Famer Join Date: Oct 2003 Location: San Diego, California Posts: 2,737	Now I know there has to be some of you who know Php enough to help me out here. __________________

08-22-2006, 10:33 AM	#9
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Been helping Cody with this issue. The problem is newer version of MySQL that have come out since BOSI was released has issues with creating tables that set timestamp default value to null. Chaning the sql load file so it doesn't set up timestamps with default nulls solves the problem. __________________ Dave HFTC Commish

08-23-2006, 12:25 AM	#10
Raderick Hall Of Famer Join Date: Oct 2003 Location: San Diego, California Posts: 2,737	Thanks Dave! __________________