View Single Post
Old 04-10-2005, 02:10 PM   #1
DougWyatt
All Star Starter
 
DougWyatt's Avatar
 
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 =
DougWyatt is offline