OOTP Developments Forums - View Single Post

John Manard · 02-14-2005, 10:42 AM

Okay I used the exporter to get CSVs after the end of my 2004 season for CATO. I had never set up Bosi yet. So i decided to do it now. When I do intial setup this is what i get ? Any thoughts?

Error inserting team(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 ',,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)' at line)<br>Please report the following query -- <br>insert into bosi_TEAM(LEAGUE_ID,OOTP_TEAM_ID,CITY,NAME,AAA_NAM E,AA_NAME,A_NAME,LEAGUE_NAME_ID,Steal,HitandRun,Bu ntHit,SPHook,Pitcha,Iw,Pinchh,Pinchr,Sq,CurStart,R otSize,CurStartAAA,CurStartAA,CurStartA,Manager,AB BREV,Dh,Human,Qualified,HumanMinor,SacBunt,Squeeze Bunt,RPHook,LLMatchup,GuardLines,CornersIn,DIVISIO N_ID)VALUES (1,1,'Baltimore','Orioles','Ottawa','Bowie ','Aberdeen',1,,,,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)

02-14-2005, 10:42 AM	#1
John Manard Minors (Single A) Join Date: Aug 2003 Location: Richmond, VA Posts: 97	Anybody have this problem with BOSI? Okay I used the exporter to get CSVs after the end of my 2004 season for CATO. I had never set up Bosi yet. So i decided to do it now. When I do intial setup this is what i get ? Any thoughts? Error inserting team(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 ',,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)' at line)<br>Please report the following query -- <br>insert into bosi_TEAM(LEAGUE_ID,OOTP_TEAM_ID,CITY,NAME,AAA_NAM E,AA_NAME,A_NAME,LEAGUE_NAME_ID,Steal,HitandRun,Bu ntHit,SPHook,Pitcha,Iw,Pinchh,Pinchr,Sq,CurStart,R otSize,CurStartAAA,CurStartAA,CurStartA,Manager,AB BREV,Dh,Human,Qualified,HumanMinor,SacBunt,Squeeze Bunt,RPHook,LLMatchup,GuardLines,CornersIn,DIVISIO N_ID)VALUES (1,1,'Baltimore','Orioles','Ottawa','Bowie ','Aberdeen',1,,,,,,,,,0,2,5,5,5,5,'Cal Ripken','BAL',1,1,0,1,,,,,,,1)