CatoBase Error 3021 and 55 Problem! Please Help! - Page 2

MLBCOOTP · 02-26-2005, 02:39 PM

ok, im looking at the pitch_stats.csv file, and i sorted by IP and then by ER to see exactly where im at.

I have 747 records of players with 0 IP but have ER.

now the pitch_stats.csv file has the players broken up into VS L, VS, R, HOME, AWAY, etc.

with this info not being combined for totals, do i have to go thru all 747 records and change them???

MLBCOOTP · 02-26-2005, 05:07 PM

me and another owner have been looing thru, he figured out where to edit, and we thought we found the player that was screwing things up.

It stopped again though.

To be exact, it makes it through to Team Summary, Anaheim Angels, Positional Charts.

Maybe there is more than 1 player? Or Something else?

SandMan · 02-27-2005, 12:13 AM

If you have MS ACCESS go into the pitching table and see if you have any players with 0 IP and ERS for the season, this will be the composite records for the season. Change the record there and then just run the create html pages..... When you find the player that fits this and the pages are run without problems then just remember the player that you edited. Go to the CSV file and just enter the .333 innings to ANY of his pitching lines in the pitcher game csv file.

I forgot that I do my editing in MSACCESS first then alter the correct player in the CSV files (the CSV files only need to be changed if you plan on creating pages for multiple season). If you create pages after every season then you do not need to change the CSV file. You can just edit the info in the pitching table in CATOBASE. The downside is that this take MSACCESS to do this....

Check one more thing - FIELDING records of players with no IP but have errors. This will cause the postional chart error. If this does not work can you send me a zipped copy of your CSV files or if you have ACCESS export your FIELDING, BATTING and PITCHING tables to a CSV file and zip them to me. Send me a PM and I will give you the email address to send them to.....

This has me intrigued and if I had the files I am sure that I can fix this.....

<o> · 02-27-2005, 12:24 PM

Quote:

Originally Posted by SandMan

If you have MS ACCESS go into the pitching table and see if you have any players with 0 IP and ERS for the season, this will be the composite records for the season. Change the record there and then just run the create html pages..... When you find the player that fits this and the pages are run without problems then just remember the player that you edited. Go to the CSV file and just enter the .333 innings to ANY of his pitching lines in the pitcher game csv file.

I forgot that I do my editing in MSACCESS first then alter the correct player in the CSV files (the CSV files only need to be changed if you plan on creating pages for multiple season). If you create pages after every season then you do not need to change the CSV file. You can just edit the info in the pitching table in CATOBASE. The downside is that this take MSACCESS to do this....

Check one more thing - FIELDING records of players with no IP but have errors. This will cause the postional chart error. If this does not work can you send me a zipped copy of your CSV files or if you have ACCESS export your FIELDING, BATTING and PITCHING tables to a CSV file and zip them to me. Send me a PM and I will give you the email address to send them to.....

This has me intrigued and if I had the files I am sure that I can fix this.....

I'm having similar problems. If I zipped files and sent them to you, could you take a look at them? If so, let me know which files I need to send you.

SandMan · 02-27-2005, 12:44 PM

PM me with and I will send you my email address, zip the batting, pitching, fielding tables from the CATOBASE in CSV format, and also the CSV files from you data folder in CATOBASE for the season that has the bad record(s).

SandMan · 02-27-2005, 04:51 PM

Looking at one set of records that were sent to me I found a weird occurance of something I have not come across before. Multiple records of a player were written to the CATOBASE database, one with the correct information and another with a 0 in the year field. For those having issues check this out and I believe that the fix would be to simply delete the records since there are correct records in the table also....

Let me know if this is the issue and if it did indeed clear up with a delete of the records and a rerun of the create html pages.....

MLBCOOTP · 02-28-2005, 02:21 AM

Quote:

Originally Posted by SandMan

Looking at one set of records that were sent to me I found a weird occurance of something I have not come across before. Multiple records of a player were written to the CATOBASE database, one with the correct information and another with a 0 in the year field. For those having issues check this out and I believe that the fix would be to simply delete the records since there are correct records in the table also....

Let me know if this is the issue and if it did indeed clear up with a delete of the records and a rerun of the create html pages.....

This was indeed the problem. i deleted all Year 0 records from every table i found them in, and it created my pages.

Thanks for your help!!!

Eckstein 4 Prez · 03-01-2005, 12:04 AM

Well, I just looked through my Access tables for some Year 0 stuff, but didn't find anything. I'm not even really sure what I'm looking for in the pitching splits tables - it looks like there's a lot of IP 0 stuff there, but it can't all be a glitch - can it?

Elendil · 04-01-2005, 11:18 PM

Quote:

Originally Posted by Eckstein 4 Prez

Well, I just looked through my Access tables for some Year 0 stuff, but didn't find anything. I'm not even really sure what I'm looking for in the pitching splits tables - it looks like there's a lot of IP 0 stuff there, but it can't all be a glitch - can it?

I just had the Error 94 and looked through this. I'm pretty sure the pitch_stats.csv file is not the one that needs editing (I don't have Access). I examined previous seasons and have lots of 0 IP entries for home, away, this week, last week, etc. The overall season pitching stats are in the player_batpitch.csv file, and I edited that file. Got the same error. I'm going to poke around some more, see what I can find...

Elendil · 04-02-2005, 12:14 AM

Editing the CSV files doesn't do a darn thing, and neither do more radical measures. I tried backing up the league, then deleting the one player with earned runs and less than an inning pitched (two-thirds of an inning), then deleting the 2008 database in Catobase, re-importing the stats, and re-exporting the html pages, and I got the same error in the same location. Very frustrating.

SandMan · 04-02-2005, 07:12 PM

You actually need to edit the MDB tables in access. For the pitching records, winshares gets messed up if the pitcher had these two combined - 0 IP/ Greater than 0 ERS. The csv files are broken down into situational stats and have no bearing on the error that CATOBASE gets unless the players TOTAL stats are 0 IP with earned runs.....

Elendil · 04-03-2005, 12:44 PM

Quote:

Originally Posted by SandMan

You actually need to edit the MDB tables in access. For the pitching records, winshares gets messed up if the pitcher had these two combined - 0 IP/ Greater than 0 ERS. The csv files are broken down into situational stats and have no bearing on the error that CATOBASE gets unless the players TOTAL stats are 0 IP with earned runs.....

Right... Actually, there are no players with exactly 0 IP and earned runs. I do have one player with two-thirds of an inning pitched and earned runs. Apparently that's enough to cause the error. Unfortunately I don't have Access.

Elendil · 04-08-2005, 07:45 AM

Well, because of this problem I had to junk this league. It would be nice if later versions of Catobase were to fix this problem. :-/

02-26-2005, 02:39 PM	#21
MLBCOOTP Minors (Double A) Join Date: Sep 2003 Posts: 111	ok, im looking at the pitch_stats.csv file, and i sorted by IP and then by ER to see exactly where im at. I have 747 records of players with 0 IP but have ER. now the pitch_stats.csv file has the players broken up into VS L, VS, R, HOME, AWAY, etc. with this info not being combined for totals, do i have to go thru all 747 records and change them??? __________________ http://www.mlbcootp.us/

02-26-2005, 05:07 PM	#22
MLBCOOTP Minors (Double A) Join Date: Sep 2003 Posts: 111	me and another owner have been looing thru, he figured out where to edit, and we thought we found the player that was screwing things up. It stopped again though. To be exact, it makes it through to Team Summary, Anaheim Angels, Positional Charts. Maybe there is more than 1 player? Or Something else? __________________ http://www.mlbcootp.us/

03-01-2005, 12:04 AM	#28
Eckstein 4 Prez Hall Of Famer Join Date: Dec 2002 Location: The OC Posts: 6,358	Well, I just looked through my Access tables for some Year 0 stuff, but didn't find anything. I'm not even really sure what I'm looking for in the pitching splits tables - it looks like there's a lot of IP 0 stuff there, but it can't all be a glitch - can it? __________________ Looking for an insomnia cure? Check out my dynasty thread, The Dawn of American Professional Base Ball, 1871.

04-02-2005, 12:14 AM	#30
Elendil Hall Of Famer Join Date: Dec 2003 Location: the dynasty forum Posts: 2,318	Editing the CSV files doesn't do a darn thing, and neither do more radical measures. I tried backing up the league, then deleting the one player with earned runs and less than an inning pitched (two-thirds of an inning), then deleting the 2008 database in Catobase, re-importing the stats, and re-exporting the html pages, and I got the same error in the same location. Very frustrating. __________________ Heaven is kicking back with a double Talisker and a churchwarden stuffed with latakia. Last edited by Elendil; 04-02-2005 at 12:59 PM.

04-08-2005, 07:45 AM	#33
Elendil Hall Of Famer Join Date: Dec 2003 Location: the dynasty forum Posts: 2,318	Well, because of this problem I had to junk this league. It would be nice if later versions of Catobase were to fix this problem. :-/ __________________ Heaven is kicking back with a double Talisker and a churchwarden stuffed with latakia.

02-27-2005, 12:13 AM	#23
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	If you have MS ACCESS go into the pitching table and see if you have any players with 0 IP and ERS for the season, this will be the composite records for the season. Change the record there and then just run the create html pages..... When you find the player that fits this and the pages are run without problems then just remember the player that you edited. Go to the CSV file and just enter the .333 innings to ANY of his pitching lines in the pitcher game csv file. I forgot that I do my editing in MSACCESS first then alter the correct player in the CSV files (the CSV files only need to be changed if you plan on creating pages for multiple season). If you create pages after every season then you do not need to change the CSV file. You can just edit the info in the pitching table in CATOBASE. The downside is that this take MSACCESS to do this.... Check one more thing - FIELDING records of players with no IP but have errors. This will cause the postional chart error. If this does not work can you send me a zipped copy of your CSV files or if you have ACCESS export your FIELDING, BATTING and PITCHING tables to a CSV file and zip them to me. Send me a PM and I will give you the email address to send them to..... This has me intrigued and if I had the files I am sure that I can fix this.....

02-27-2005, 12:44 PM	#25
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	PM me with and I will send you my email address, zip the batting, pitching, fielding tables from the CATOBASE in CSV format, and also the CSV files from you data folder in CATOBASE for the season that has the bad record(s).

02-27-2005, 04:51 PM	#26
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Looking at one set of records that were sent to me I found a weird occurance of something I have not come across before. Multiple records of a player were written to the CATOBASE database, one with the correct information and another with a 0 in the year field. For those having issues check this out and I believe that the fix would be to simply delete the records since there are correct records in the table also.... Let me know if this is the issue and if it did indeed clear up with a delete of the records and a rerun of the create html pages.....

04-02-2005, 07:12 PM	#31
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	You actually need to edit the MDB tables in access. For the pitching records, winshares gets messed up if the pitcher had these two combined - 0 IP/ Greater than 0 ERS. The csv files are broken down into situational stats and have no bearing on the error that CATOBASE gets unless the players TOTAL stats are 0 IP with earned runs.....