BOSI Error - help needed

DougWyatt · 04-10-2005, 02:10 PM

Weird, BOSI still works (updated correctly) but we've gotten this error message the last 4 sims. With the exception of Loaiza (player 357) being no good.

Here is the error:

Error updating old team record for Player ID # 357(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 '' at line 1)
Please report the following query --
update bosi_PITCH_STATS set TEAM_ID = NULL,IP=0,IPS=0,IPF=0,AB=0,TB=0,HA=0,K=0,BF=0,RS=0 ,BB=0,G=0,GS=0,RBI=0,W=0,L=0,S=0,SA=0,DA=0,SH=0,SF =0,TA=0,HRA=0,R=0,ER=0,BK=0,CI=0,IW=0,WP=0,HP=0,GF =0,DP=0,QS=0,RL=0,RLS=0,SVO=0,BS=0,IR=0,IRS=0,RA=0 ,CG=0,SHO=0,SB=0,CS=0,HLD=0,R9=0,AVG=0,LAVG=0,RAVG =0,OBP=0,SLG=0,H9=0,K9=0,HR9=0,BB9=0,CGP=0,CERA=0, QSP=0,RSG=0,RLSP=0,SVP=0,BSVP=0,IRSP=0,GFP=0,ERA=0 ,IPPS=0,CLOSE_DATE = '2007-10-06' where PITCH_STATS_ID =

DougWyatt · 04-11-2005, 10:08 PM

Anyone ?

cibl commish · 04-12-2005, 07:42 AM

Not sure, but if it errors out on that particular player during import, check and see if he has a nickname and if so, get rid of it and try again..

04-10-2005, 02:10 PM	#1
DougWyatt All Star Starter Join Date: Dec 2003 Location: Michigan Posts: 1,117	BOSI Error - help needed Weird, BOSI still works (updated correctly) but we've gotten this error message the last 4 sims. With the exception of Loaiza (player 357) being no good. Here is the error: Error updating old team record for Player ID # 357(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 '' at line 1) Please report the following query -- update bosi_PITCH_STATS set TEAM_ID = NULL,IP=0,IPS=0,IPF=0,AB=0,TB=0,HA=0,K=0,BF=0,RS=0 ,BB=0,G=0,GS=0,RBI=0,W=0,L=0,S=0,SA=0,DA=0,SH=0,SF =0,TA=0,HRA=0,R=0,ER=0,BK=0,CI=0,IW=0,WP=0,HP=0,GF =0,DP=0,QS=0,RL=0,RLS=0,SVO=0,BS=0,IR=0,IRS=0,RA=0 ,CG=0,SHO=0,SB=0,CS=0,HLD=0,R9=0,AVG=0,LAVG=0,RAVG =0,OBP=0,SLG=0,H9=0,K9=0,HR9=0,BB9=0,CGP=0,CERA=0, QSP=0,RSG=0,RLSP=0,SVP=0,BSVP=0,IRSP=0,GFP=0,ERA=0 ,IPPS=0,CLOSE_DATE = '2007-10-06' where PITCH_STATS_ID =

04-12-2005, 07:42 AM	#3
cibl commish All Star Reserve Join Date: Jun 2003 Location: Phoenix, AZ Posts: 611	Not sure, but if it errors out on that particular player during import, check and see if he has a nickname and if so, get rid of it and try again.. __________________ Rick

04-11-2005, 10:08 PM	#2
DougWyatt All Star Starter Join Date: Dec 2003 Location: Michigan Posts: 1,117	Anyone ?