BOSI problem

chrisj · 10-25-2004, 11:32 PM

Trying to import this weeks stats...

When it gets to Batting & Pitching stats, a message comes up saying "In Error".

In the box, it says:
Error updating old team record for Player ID # 52962(You have an error in your SQL syntax near '' at line 1)<br>Please report the following query -- <br>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 = '2012-7-18' where PITCH_STATS_ID =

Any suggestions?

DaveHorn · 10-26-2004, 10:10 AM

Find the player with Player ID # 52962. If you don't know how, just go to any player page and then change the player id in the URL to the above URL. See where BOSI thinks this player lives because its generating a team id of null which is causing your SQL to choke. Maybe its a bogus player or something. If so, just delete that player, export your csvs again and import into BOSI.

chrisj · 10-26-2004, 09:02 PM

I'm still not getting it.

http://bosi.ootp-online.com/player.php?G_pid=52962

He was just traded to Niagara - so it took part of the import correctly, as he's been switched over to the team new. But it stopped at the pitch_stats import. I looked over the players info in the CSV, and I can't seem to figure out why. Any suggestions at all?

DaveHorn · 10-27-2004, 12:49 PM

I'm not sure if you are dealing with a bug in the BOSI code or a problem with the CSV. But in the SQL you cut & pasted, you've got two fields which are undefined and they should not be.

TEAM_ID = NULL and
PITCH_STATS_ID = blank

This could simply be a problem in one of the CSVs and if you fix the CSV and try to reimport you will be ok.

chrisj · 10-27-2004, 11:49 PM

Quote:

Originally Posted by DaveHorn

I'm not sure if you are dealing with a bug in the BOSI code or a problem with the CSV. But in the SQL you cut & pasted, you've got two fields which are undefined and they should not be.

TEAM_ID = NULL and
PITCH_STATS_ID = blank

This could simply be a problem in one of the CSVs and if you fix the CSV and try to reimport you will be ok.

Blah. I hope it's a problem with the CSV - otherwise I'm SOL, since I can't edit the SQL (it's on the OLS). Like I said though, I looked at the CSV, and the team id shouldn't be null for this guy - he has a team listed, and it should be fine. I just don't get it.

It happened after our most recent sim again, with the game player (and same error).

The problem always occurs when doing bat/pitch stats... but I don't see anything that could suggest a problem with player #8.

DaveHorn · 10-28-2004, 01:39 PM

The team id for a player is in the players.csv not the pitch stats, although I believe it must be ok there too. I'm pretty sure its imports the player first, so you would of have other errors if there wasn't a team id for the player in that file.

When the import process begins to update the pitch stats for a player, the first thing it does it go to the pitch_stats table and to lookup the current info.

Can you even access the database on the OLS??? You need to look that player up in your bosi_pitch_stats table, make sure all his entries are correct. My best guess so far that there is something fichy there.

Professor · 10-28-2004, 06:00 PM

Quote:

Originally Posted by chrisj

The problem always occurs when doing bat/pitch stats... but I don't see anything that could suggest a problem with player #8.

Chris,

I opened the file in Excell, look in cell CP9, there is a value of "-1#IO" , could that be the problem?

chrisj · 10-29-2004, 12:40 AM

Quote:

Originally Posted by DaveHorn

Can you even access the database on the OLS??? You need to look that player up in your bosi_pitch_stats table, make sure all his entries are correct. My best guess so far that there is something fichy there.

Nope... can't look it up at all. If it's not the CSV's, that's my guess too, sadly I just don't have any access.

chrisj · 10-29-2004, 12:41 AM

Quote:

Originally Posted by Professor

Chris,

I opened the file in Excell, look in cell CP9, there is a value of "-1#IO" , could that be the problem?

Tried changing it - no luck. :/

DaveHorn · 10-29-2004, 02:19 PM

I don't think that the problem there are a lot of guys that have that value in that column.

That's crazy, you can't log into the database to fix the problem. Who supports the OLS. Is that OOTP? See if they can give you access or perhaps they can look at the problem for you. Its all I can think of...

10-25-2004, 11:32 PM	#1
chrisj All Star Reserve Join Date: Feb 2002 Location: Edmonton, Alberta (but still wishing I was in Halifax, Nova Scotia, Canada) Posts: 834	BOSI problem Trying to import this weeks stats... When it gets to Batting & Pitching stats, a message comes up saying "In Error". In the box, it says: Error updating old team record for Player ID # 52962(You have an error in your SQL syntax near '' at line 1)<br>Please report the following query -- <br>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 = '2012-7-18' where PITCH_STATS_ID = Any suggestions? __________________ Canadian Baseball League -- Commissioner -- Calgary GM

10-26-2004, 10:10 AM	#2
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	Find the player with Player ID # 52962. If you don't know how, just go to any player page and then change the player id in the URL to the above URL. See where BOSI thinks this player lives because its generating a team id of null which is causing your SQL to choke. Maybe its a bogus player or something. If so, just delete that player, export your csvs again and import into BOSI. __________________ Dave HFTC Commish

10-26-2004, 09:02 PM	#3
chrisj All Star Reserve Join Date: Feb 2002 Location: Edmonton, Alberta (but still wishing I was in Halifax, Nova Scotia, Canada) Posts: 834	I'm still not getting it. http://bosi.ootp-online.com/player.php?G_pid=52962 He was just traded to Niagara - so it took part of the import correctly, as he's been switched over to the team new. But it stopped at the pitch_stats import. I looked over the players info in the CSV, and I can't seem to figure out why. Any suggestions at all? __________________ Canadian Baseball League -- Commissioner -- Calgary GM

10-27-2004, 12:49 PM	#4
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	I'm not sure if you are dealing with a bug in the BOSI code or a problem with the CSV. But in the SQL you cut & pasted, you've got two fields which are undefined and they should not be. TEAM_ID = NULL and PITCH_STATS_ID = blank This could simply be a problem in one of the CSVs and if you fix the CSV and try to reimport you will be ok. __________________ Dave HFTC Commish

10-28-2004, 01:39 PM	#6
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	The team id for a player is in the players.csv not the pitch stats, although I believe it must be ok there too. I'm pretty sure its imports the player first, so you would of have other errors if there wasn't a team id for the player in that file. When the import process begins to update the pitch stats for a player, the first thing it does it go to the pitch_stats table and to lookup the current info. Can you even access the database on the OLS??? You need to look that player up in your bosi_pitch_stats table, make sure all his entries are correct. My best guess so far that there is something fichy there. __________________ Dave HFTC Commish

10-29-2004, 02:19 PM	#10
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	I don't think that the problem there are a lot of guys that have that value in that column. That's crazy, you can't log into the database to fix the problem. Who supports the OLS. Is that OOTP? See if they can give you access or perhaps they can look at the problem for you. Its all I can think of... __________________ Dave HFTC Commish