Error Bosi

Crackerjack · 12-15-2004, 12:59 AM

Error processing Team # 10. Couldn't find a park with an OOTP ID of 32

I added a park 32 to the park.cvs but still get error any help?

Crackerjack · 12-15-2004, 01:16 AM

also get this

Error updating park(You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where PARK_ID = 31' at line 1)
Please report the following query --
update bosi_PARK set NAME='Washington Park',DIM_LFLINE=330,DIM_LF=350,DIM_LC=375,DIM_CF= 400,DIM_RC=375,DIM_RF=350,DIM_RFLINE=330,HGT_LFLIN E=9,HGT_LF=9,HGT_LC=9,HGT_CF=9,HGT_RC=9,HGT_RF=9,H GT_RFLINE=9,AVG=98,AVGR=97,AVGL=100,HR=101,HRR=104 ,HRL=95,DBL=88,TPL=77,PARK_TYPE=0,SURFACE=0,CAPACI TY=45000,WIND=7,WIND_DIR=7,TEMP_MAR_APR=57,RAIN_MA R_APR=11,TEMP_MAY=64,RAIN_MAY=9,TEMP_JUNE=75,RAIN_ JUNE=6,TEMP_JULY=82,RAIN_JULY=2,TEMP_AUG=74,RAIN_A UG=5,TEMP_SEP=67,RAIN_SEP=9,TEMP_OCT_NOV=60,RAIN_O CT_NOV=12| where PARK_ID = 31

Import Files

czzccr · 12-15-2004, 07:44 AM

Only thing I notice about the statement is the "|" character near the end of the statement (RAIN_O CT_NOV=12|). This is an integer field and believe it would cause the statement to fail.

I would suggest that you just run the park exporter that is included in Joe's Exporter instead of editing your park.csv file.

Crackerjack · 12-15-2004, 08:48 AM

I did use the exporters from the BOsi site.

Thats when I tried to hand change the cvs, have since taken that off but still get this.

Error processing Team # 10. Couldn't find a park with an OOTP ID of 32

czzccr · 12-15-2004, 09:14 AM

Quote:

Originally Posted by Crackerjack

I did use the exporters from the BOsi site.

Thats when I tried to hand change the cvs, have since taken that off but still get this.

Error processing Team # 10. Couldn't find a park with an OOTP ID of 32

When you open the park.csv file, is there a park with a PARK_ID of 32? If so, which link are you clicking when doing the BOSI import?

Crackerjack · 12-15-2004, 04:05 PM

There is no park 32. My guess is that the bosi hits team 10 (Twins) and for some reason is connecting it to park 32? They play at the metrodomw whicih is in the park.cvs but its like 14 or 15.

12-15-2004, 12:59 AM	#1
Crackerjack Major Leagues Join Date: Apr 2002 Posts: 362	Error Bosi Error processing Team # 10. Couldn't find a park with an OOTP ID of 32 I added a park 32 to the park.cvs but still get error any help? __________________ Cheers Bird WWW.CRACKERJACKBASEBALL.COM

12-15-2004, 01:16 AM	#2
Crackerjack Major Leagues Join Date: Apr 2002 Posts: 362	also get this Error updating park(You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where PARK_ID = 31' at line 1) Please report the following query -- update bosi_PARK set NAME='Washington Park',DIM_LFLINE=330,DIM_LF=350,DIM_LC=375,DIM_CF= 400,DIM_RC=375,DIM_RF=350,DIM_RFLINE=330,HGT_LFLIN E=9,HGT_LF=9,HGT_LC=9,HGT_CF=9,HGT_RC=9,HGT_RF=9,H GT_RFLINE=9,AVG=98,AVGR=97,AVGL=100,HR=101,HRR=104 ,HRL=95,DBL=88,TPL=77,PARK_TYPE=0,SURFACE=0,CAPACI TY=45000,WIND=7,WIND_DIR=7,TEMP_MAR_APR=57,RAIN_MA R_APR=11,TEMP_MAY=64,RAIN_MAY=9,TEMP_JUNE=75,RAIN_ JUNE=6,TEMP_JULY=82,RAIN_JULY=2,TEMP_AUG=74,RAIN_A UG=5,TEMP_SEP=67,RAIN_SEP=9,TEMP_OCT_NOV=60,RAIN_O CT_NOV=12\| where PARK_ID = 31 Import Files __________________ Cheers Bird WWW.CRACKERJACKBASEBALL.COM

12-15-2004, 08:48 AM	#4
Crackerjack Major Leagues Join Date: Apr 2002 Posts: 362	I did use the exporters from the BOsi site. Thats when I tried to hand change the cvs, have since taken that off but still get this. Error processing Team # 10. Couldn't find a park with an OOTP ID of 32 __________________ Cheers Bird WWW.CRACKERJACKBASEBALL.COM

12-15-2004, 04:05 PM	#6
Crackerjack Major Leagues Join Date: Apr 2002 Posts: 362	There is no park 32. My guess is that the bosi hits team 10 (Twins) and for some reason is connecting it to park 32? They play at the metrodomw whicih is in the park.cvs but its like 14 or 15. __________________ Cheers Bird WWW.CRACKERJACKBASEBALL.COM

12-15-2004, 07:44 AM	#3
czzccr Minors (Single A) Join Date: Dec 2002 Location: New Jersey Posts: 61	Only thing I notice about the statement is the "\|" character near the end of the statement (RAIN_O CT_NOV=12\|). This is an integer field and believe it would cause the statement to fail. I would suggest that you just run the park exporter that is included in Joe's Exporter instead of editing your park.csv file.