History Runtime Error 11 - Page 2

Jonzard · 02-29-2004, 05:59 PM

hey Killebrew, Hammer, and maybe Nukester, any signs of solving this problem?

Nukester · 02-29-2004, 09:30 PM

I really dont know what the answer could be. The -1.#IO error and the gaps between the players are the only problems Ive run into.

Killebrew · 03-01-2004, 04:03 PM

I had one idea I PMed - one player, Eugene Holt, had some strange stats that might be the cause of the divide by 0 error. I don't have a lot of confidence in this solution though, it's just that he is the only player in the entire csv that had played in the playoffs yet had 0 IP. Longshot but I am thinking that maybe the OOTP History does not have the same validation logic working on the post season stats as the season stats.

Jonzard · 03-01-2004, 06:18 PM

Nope neither work

I still suspect it has to do with Duncanalfred476 when its determining team for each game.

I would like any solution possible to this! Otherwise our league loses its history, which would be a shame.

Killebrew · 03-01-2004, 09:12 PM

Quote:

Originally posted by Jonzard
Nope neither work

I still suspect it has to do with Duncanalfred476 when its determining team for each game.

I would like any solution possible to this! Otherwise our league loses its history, which would be a shame.

You are likely correct about the error being related to Duncanalfred476 - I guess it is his html being generated when the app craps out? If so, at what point in the html page does it stop at?

Jonzard · 03-02-2004, 01:54 AM

its not the html generation, It is during IMPORTING stats

Killebrew · 03-02-2004, 02:46 AM

Quote:

Originally posted by Jonzard
its not the html generation, It is during IMPORTING stats

Hmm, that is interesting considering I was able to import these CSV files into an Access MDB

. As I had no problems doing those steps I just assumed it was during the html output stage. That means the csv files are fine, but the games html files are probably causing the problem - feel free to email these (zipped) to me if you want, no promises for a solution but I can go through some steps. The OOTP html files don't need the player pages, so the zipped file should not be too big.

Hammer755 · 03-02-2004, 08:16 AM

Sorry for not responding sooner Janzard, but I've had the same results. The CSV imported fine and I haven't seen any weird data.

Jonzard · 03-02-2004, 02:25 PM

Processing Trade Info...
Calculating pitching stats for each team
DuncanAlfred476

thats where it errors out

YOU WANT ALL THE HTML FILES except players? Do you want all the box scores too?

Hammer755 · 03-02-2004, 02:37 PM

Quote:

Originally posted by Jonzard
Processing Trade Info...
Calculating pitching stats for each team
DuncanAlfred476

thats where it errors out

YOU WANT ALL THE HTML FILES except players? Do you want all the box scores too?

Jonzard, that sounds eerily like a problem that I ran into that Killebrew helped me squash, but you did not have the same problem that I did. Let me look again this evening. Maybe I overlooked something.

Killebrew · 03-02-2004, 05:20 PM

Quote:

Originally posted by Jonzard
Processing Trade Info...
Calculating pitching stats for each team
DuncanAlfred476

thats where it errors out

YOU WANT ALL THE HTML FILES except players? Do you want all the box scores too?

Jonzard - the html files without the players or box scores.

Hammer: Yeah, this is sounding more familiar now...

Jonzard · 03-04-2004, 05:45 PM

ITS SOLVED!

I recieve this email

"Good news Jon - there is a fix specifically for your issue that is on
the way from the developer of OOTP History, Jeff Cato. I explained the problem and FWed the files you sent me to him and he discovered the problem in the app. As for when the app fix is done I cannot promise anything as that is Jeff's decision, but in the meantime you could try a workaround fix I did based on Jeff's instructions."

The file was sent to me in email... but for those who get this problem in the future, there WILL be a fix in the program everyone!

"Replace the pitch_game.csv file you have with this one and the import should work - you may need to start the DB over if the previous crash corrupted it's data. The problem was that the app ignored the first game stats for traded players and Duncan had his single inning in that 1st game before he was traded. I changed his game by game stats to be 2/3 innings in game 1 and 1/3 inning in game 2 so the divide by zero error should be gone now.

Best,
Killebrew"

Thanks to everyone that helped me, including Killebrew

hopefully this will get stickied so everyone knows a fix is coming for this most common problem.

Killebrew · 03-04-2004, 05:58 PM

Good news Jon, and full credit goes to the developer Jeff Cato for solving this one - thanks Jeff, hope you don't mind the publicity.

About an update: I let my enthusiasm get the best of me here, those sorts of decisions are completely up to Jeff. Regardless of that, it's great news for all of us that he is still enthusiastic about his OOTP History program.

02-29-2004, 05:59 PM	#21
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	hey Killebrew, Hammer, and maybe Nukester, any signs of solving 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 Last edited by Jonzard; 03-01-2004 at 06:28 PM.

03-01-2004, 06:18 PM	#24
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	Nope neither work I still suspect it has to do with Duncanalfred476 when its determining team for each game. I would like any solution possible to this! Otherwise our league loses its history, which would be a shame. __________________ 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

03-02-2004, 01:54 AM	#26
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	its not the html generation, It is during IMPORTING stats __________________ 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

03-02-2004, 02:25 PM	#29
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	Processing Trade Info... Calculating pitching stats for each team DuncanAlfred476 thats where it errors out YOU WANT ALL THE HTML FILES except players? Do you want all the box scores too? __________________ 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

03-04-2004, 05:45 PM	#32
Jonzard Hall Of Famer Join Date: Jun 2003 Location: Minnesota Posts: 3,647	FIX! ITS SOLVED! I recieve this email "Good news Jon - there is a fix specifically for your issue that is on the way from the developer of OOTP History, Jeff Cato. I explained the problem and FWed the files you sent me to him and he discovered the problem in the app. As for when the app fix is done I cannot promise anything as that is Jeff's decision, but in the meantime you could try a workaround fix I did based on Jeff's instructions." The file was sent to me in email... but for those who get this problem in the future, there WILL be a fix in the program everyone! "Replace the pitch_game.csv file you have with this one and the import should work - you may need to start the DB over if the previous crash corrupted it's data. The problem was that the app ignored the first game stats for traded players and Duncan had his single inning in that 1st game before he was traded. I changed his game by game stats to be 2/3 innings in game 1 and 1/3 inning in game 2 so the divide by zero error should be gone now. Best, Killebrew" Thanks to everyone that helped me, including Killebrew hopefully this will get stickied so everyone knows a fix is coming for this most common 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-29-2004, 09:30 PM	#22
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,923	I really dont know what the answer could be. The -1.#IO error and the gaps between the players are the only problems Ive run into.

03-01-2004, 04:03 PM	#23
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	I had one idea I PMed - one player, Eugene Holt, had some strange stats that might be the cause of the divide by 0 error. I don't have a lot of confidence in this solution though, it's just that he is the only player in the entire csv that had played in the playoffs yet had 0 IP. Longshot but I am thinking that maybe the OOTP History does not have the same validation logic working on the post season stats as the season stats.

03-02-2004, 08:16 AM	#28
Hammer755 Hall Of Famer Join Date: Dec 2001 Location: Houston, TX Posts: 2,348	Sorry for not responding sooner Janzard, but I've had the same results. The CSV imported fine and I haven't seen any weird data.

03-04-2004, 05:58 PM	#33
Killebrew Hall Of Famer Join Date: Dec 2001 Posts: 3,326	Good news Jon, and full credit goes to the developer Jeff Cato for solving this one - thanks Jeff, hope you don't mind the publicity. About an update: I let my enthusiasm get the best of me here, those sorts of decisions are completely up to Jeff. Regardless of that, it's great news for all of us that he is still enthusiastic about his OOTP History program.