BOSI Initial Import Error

[Raderick]

I get the following error when I click on "Initial Import" after setting up BOSI:

Error updating league inforamtion(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 's Cup Champions',PS_Series3_Name='World Championship',PS_Series)<br>Please report the following query -- <br>update bosi_LEAGUE set Currentday=36,gamesps=150,LEAGUE_DATE='1997-2-5',WeekDay=1,BoxNumber=1501,Updated=20050704012726 ,sd=91,TeamNumbers=20,LeagueNumbers=2,RosterLimit= 25,Last_WS_Winner='',PostSeason=0,Over=0,Rookied=1 ,sdraft=0,Financial=1,FreeAgentPeriod=1,PS_Series1 _Name='League Championship',PS_Series2_Name='President's Cup Champions',PS_Series3_Name='World Championship',PS_Series4_Name='',POY_AWARD_NAME='N olen Ryan Award',BOY_AWARD_NAME='Ted Williams Award',ROOKIE_AWARD_NAME='Rookie of the Year',award4='Gold Glove',MakeLog=0,era_AVG=0.264,era_AB=166737,era_P A=184520,era_H=44057,era_D=8827,era_T=934,era_HR=5 207,era_BB=15889,era_K=30801,era_HBP=1894,HOFAvg2= 0.300,HOFEra2=3.50,CashMax=10000000,SimMinor=1,Coa ches=0,HumanTeam=0,TradeFreq=3,CurrentERA=5,InjFre q=3,Spring=1,wheredraft=0,SalaryCap=100000000,Rati ngs=1,PosFatigue=1,PS1_length=7,PS2_length=7,PS3_l ength=0,PS4_length=0,PS5_length=0,PS_rounds=0,PS_M ax_Round=2,PS_Teams_Left=0,HOFh1=3000,HOFhr1=500,H OFh2=2500,HOFw1=300,HOFs1=600,HOFw2=250,Allstar=17 8,FreeAgentRound=6,NO_ARBY=0,JUNE_DRAFT=0,COACH_FA _PERIOD=0,COACH_FA_OFFERED=0,COACH_FA_ROUND=1,AMMY _DRAFT_ROUNDS=8,MIN_SALARY=50000,PLAYOFF_MODE=0,WA IVER_PERIOD=15,SHOW_STARS=1,NEW_ENGINE=1,SCALE_ABI LITY=3,SCALE_TALENT=3,SCALE_OTHER=3,MIN_DAYS_ON_RO STER=172,REG_ROSTER=25,SEPT_ROSTER_SIZE=0,FORTY_MA N_ROSTER=1,RULE_5_DRAFT=0,FA_COMPENSATION=0,WAIVER S=1,MINOR_LEAGUE_FA=0,MINOR_OPTIONS=1,OLD_LEAGUE_D ATE='' where LEAGUE_ID = 1

The WCBL started using 6.5 during the off-season. Is that a problem?

[DaveHorn]

The apostrophe in President's Cup Champions would be a problem in the SQL clause. BOSI doesn't check for this and it typically causes problems. I would try changing the name and see what happens.

[Raderick]

Originally Posted by DaveHorn

The apostrophe in President's Cup Champions would be a problem in the SQL clause. BOSI doesn't check for this and it typically causes problems. I would try changing the name and see what happens.

That works. Thanks Dave!