History Runtime Error 11

Jonzard · 02-16-2004, 01:16 PM

Runtime error 11, division by zero

Anyone know where this is coming from? And how to fix it when I run OOTPHist.

Jonzard · 02-16-2004, 02:31 PM

more specifically, this happens when im importing stats... its a pitcher who is being calculated, and I get the error

Sandstorm3 · 02-16-2004, 03:08 PM

are you using the newest version? This is an error I got in pervisus versions, but I thought Cato had fixed it in the last release. it happens when a pitcher has an infinate ERA. You can edit stats using MS Access, but I was never able to get it to continue unless I deleted the player from the data base for that season

Jonzard · 02-16-2004, 08:25 PM

im using 4.1, as im using OOTP4, but it worked both of the last two years without this problem

Jonzard · 02-17-2004, 05:01 PM

and if no one knows how to fix this.... is there another way to do it, cause i dont have access

Killebrew · 02-17-2004, 06:55 PM

You don't need Access, as this is a problem in the CSV files.
The problem: There is a 99% chance this is an error where a pitcher has zero innings pitched and gets 1 or more runs scored against him. It might have occured in the postseason or with one team if he played on multiple teams. What you have to do is look at the scv file within MS Excel and search the IP column for 0's. When you find a 0 check if the earned run column is 1 or greater, is yes then change the 0 to 0.1 or some low amount, this will get rid of the error.

This is a pretty rare error but it comes up more frequently with leagues that do more trading during the season, and leagues that have very large rosters and a high volumes of FA pickups/releases throughout the year.

Jonzard · 02-18-2004, 12:10 AM

umm which CSV file?

Jonzard · 02-18-2004, 12:30 AM

oh yea, and it says "duncanfred476" is where the error occured

and when i look at his stats in the game he doesnt have 0IP and 1+ER.

He in fact pitched 1 scoreless inning, and in the minors he pitched 15+ innings at both levels he pitched at.

Killebrew · 02-18-2004, 03:15 AM

Quote:

Originally posted by Jonzard
umm which CSV file?

The one with the pitchers stats - I think it is called pitchstats.csv.

Regarding the player the app stopped on - check him first, then the player right before and after him in the csv file. Remember that if the player played on multiple teams or if he played in the post season you will need to check multiple rows for the same pitcher.

Jonzard · 02-18-2004, 12:10 PM

HMMM, when i look this up, im not seeing anything like this....
nothing with 0IP and 1+ER

and to find the player # do i look it up in the player csv?

Killebrew · 02-18-2004, 12:38 PM

Quote:

Originally posted by Jonzard
to find the player # do i look it up in the player csv?

I don't have the files here but I would imagine so yes.

Jonzard · 02-18-2004, 12:50 PM

So i am not finding anything with this guy involving an infinite ERA.... so if anyone knows another reason its doing this, or perhaps would like to examine my CSV files themselves.... please let me know

Killebrew · 02-18-2004, 03:23 PM

Quote:

Originally posted by Jonzard
So i am not finding anything with this guy involving an infinite ERA.... so if anyone knows another reason its doing this, or perhaps would like to examine my CSV files themselves.... please let me know

Feel free to email the zipped pitcherstats.csv to me - please PM me for an email addie and I can look at this in the next few days. If anyone else can help before then that would be a good option as well

.

Nukester · 02-19-2004, 12:40 AM

In the file "player_batpitch.csv" do a search for:

-1.#I0 or somthing like that. I usually just change it to 0.

Another problem can creep up on you also.....In the "players.csv" file, make sure wordwrap is off and that every player only has one line. If a player has more than one line, the import will crash on that file.

The first fix is whats happening with you now though..........

Jonzard · 02-19-2004, 03:12 AM

-1.#IO

thats what I found, and replaced with 0,
unfortunately, that did not work... I got the same problem

Hammer755 · 02-19-2004, 11:35 AM

Quote:

Originally posted by Killebrew
Feel free to email the zipped pitcherstats.csv to me - please PM me for an email addie and I can look at this in the next few days. If anyone else can help before then that would be a good option as well.

I'll take a look at this too if you PM me for an e-mail addy. I had similar problems, and Killebrew helped me out a ton, so I would be more than willing to 'Pay It Forward'.

Nukester · 02-19-2004, 09:50 PM

Did you replace all ? There may be more than one guy with that problem. I have 28 seasons of my league in Cato's OOTP4 util and those are the only two problems Ive ever encountered.

Jonzard · 02-20-2004, 12:22 AM

yup replaced all, there was only like 1 or 2 anyway

Jonzard · 02-22-2004, 11:47 PM

any progress guys?

Carlton · 02-25-2004, 11:20 PM

When this is figured out, it should really be stickied...as it may be rare but it is the most common Cato's problem...and frustrating when it happens after 20+ years

02-16-2004, 01:16 PM	#1
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	History Runtime Error 11 Runtime error 11, division by zero Anyone know where this is coming from? And how to fix it when I run OOTPHist. __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-16-2004, 02:31 PM	#2
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	more specifically, this happens when im importing stats... its a pitcher who is being calculated, and I get the error __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-16-2004, 03:08 PM	#3
Sandstorm3 Minors (Double A) Join Date: Apr 2003 Location: West Seneca, NY Posts: 157	are you using the newest version? This is an error I got in pervisus versions, but I thought Cato had fixed it in the last release. it happens when a pitcher has an infinate ERA. You can edit stats using MS Access, but I was never able to get it to continue unless I deleted the player from the data base for that season __________________ "I'm very well acquainted with the seven deadly sins, I keep a busy sechdual trying to fit them in" Mr. Bad Example (Warren Zevon)

02-16-2004, 08:25 PM	#4
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	im using 4.1, as im using OOTP4, but it worked both of the last two years without this problem __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-17-2004, 05:01 PM	#5
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	and if no one knows how to fix this.... is there another way to do it, cause i dont have access __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-17-2004, 06:55 PM	#6
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	You don't need Access, as this is a problem in the CSV files. The problem: There is a 99% chance this is an error where a pitcher has zero innings pitched and gets 1 or more runs scored against him. It might have occured in the postseason or with one team if he played on multiple teams. What you have to do is look at the scv file within MS Excel and search the IP column for 0's. When you find a 0 check if the earned run column is 1 or greater, is yes then change the 0 to 0.1 or some low amount, this will get rid of the error. This is a pretty rare error but it comes up more frequently with leagues that do more trading during the season, and leagues that have very large rosters and a high volumes of FA pickups/releases throughout the year.

02-18-2004, 12:10 AM	#7
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	umm which CSV file? __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-18-2004, 12:30 AM	#8
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	oh yea, and it says "duncanfred476" is where the error occured and when i look at his stats in the game he doesnt have 0IP and 1+ER. He in fact pitched 1 scoreless inning, and in the minors he pitched 15+ innings at both levels he pitched at. __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB Last edited by Jonzard; 02-18-2004 at 12:48 AM.

02-18-2004, 12:10 PM	#10
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	HMMM, when i look this up, im not seeing anything like this.... nothing with 0IP and 1+ER and to find the player # do i look it up in the player csv? __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-18-2004, 12:50 PM	#12
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	So i am not finding anything with this guy involving an infinite ERA.... so if anyone knows another reason its doing this, or perhaps would like to examine my CSV files themselves.... please let me know __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-19-2004, 12:40 AM	#14
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,923	In the file "player_batpitch.csv" do a search for: -1.#I0 or somthing like that. I usually just change it to 0. Another problem can creep up on you also.....In the "players.csv" file, make sure wordwrap is off and that every player only has one line. If a player has more than one line, the import will crash on that file. The first fix is whats happening with you now though..........

02-19-2004, 03:12 AM	#15
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	-1.#IO thats what I found, and replaced with 0, unfortunately, that did not work... I got the same problem __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-19-2004, 09:50 PM	#17
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,923	Did you replace all ? There may be more than one guy with that problem. I have 28 seasons of my league in Cato's OOTP4 util and those are the only two problems Ive ever encountered. Last edited by Nukester; 02-19-2004 at 10:04 PM.

02-20-2004, 12:22 AM	#18
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	yup replaced all, there was only like 1 or 2 anyway __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-22-2004, 11:47 PM	#19
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	any progress guys? __________________ For a scientist must indeed be freely imaginative and yet skeptical, creative and yet a critic. There is a sense in which he must be free, but another in which his thought must be very precisely regimented; there is poetry in science, but also a lot of bookkeeping. — Sir Peter B. Medawar FTB

02-25-2004, 11:20 PM	#20
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	When this is figured out, it should really be stickied...as it may be rare but it is the most common Cato's problem...and frustrating when it happens after 20+ years __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"