Cato Errors - Need a Cato Guru

Cyclone792 · 12-12-2005, 05:30 PM

Well, I've actually officially given up on this one particular league file, I think. I'm in the process of attempting to get a fully functional CatoBase up for an online league, but am not able to get past one of our early seasons due to multiple errors. In the last year I've tried multiple attempts at a fix and have tried virtually everything that's ever been posted to the best of my ability. Unfortunately, none of it has worked.

So my one last ditch effort is a massive plea for help. Would any Cato gurus be willing to download that end of season league file and give it a shot to run CatoBase with it? The season was ran with OOTP5 so that may or may not be an issue. I even tried importing that league file into 6.5 to run Cato, but that didn't work either. Maybe I'm missing something, or maybe the file is just corrupt, I don't know.

The file is located at our site's main page ... http://www.potd.simleaguecentral.com ... in one of the menus on the left side of the screen, there's a series of links for Previous POTD Season Files. The file in question would be the POTD 2005 (OOTP5) season file.

Thanks in advance ... and any help is definitely appreciated!

Cyclone792 · 12-12-2005, 05:50 PM

More information which may help ...

1) There is at least one instance in that 2005 season where a player (Raul Lazpita) was traded twice on the same day.

2) A shortstop named Larry Riker pitched in a game and retired nobody, yet gave up earned runs. I've read of the errors associated with that so I just wiped Riker out of the league entirely and tried it, but that didn't work (Riker is still in the league under the file that can be downloaded off the league's web site).

Those are two errors that may be causing problems, but the problem is I don't know how to properly fix them. Not only that, but I'm not sure if those are the only errors causing problems or if there are others as well.

Another edit: I've gotten 2003 and 2004 season files to work without any problems, as have Mike and Christina (I see you reading this thread, Mike!). They have also gotten 2006-2009 to work without any problems ... nobody yet has tried 2010-2013. It just boggles my mind how this one particular season in 2005 seems to have something all fouled up.

Qrusher14242 · 12-12-2005, 07:44 PM

Good luck, Im on my second season in cato and when creating the Main League pages for that year, it gives me a E_FAIL error. All the other pages created fine, except for those. Ill try and run the 2005 tonight.

Cyclone792 · 12-13-2005, 07:27 AM

Thanks, Qrusher, let me know if you find anything.

Update for any who wishes to help ... I'm receiving many of the same errors for the 2010 file that I'm receiving for the 2005 file. First it'll ask me for a league.html file when importing the stats, then when creating the the HTMLs I'll get that Error 3021. I've determined that there has been players that have been traded multiple times on the same day. How do I effectively get into the CSVs to fix the bug?

f.montoya · 12-13-2005, 08:25 AM

Quote:

Originally Posted by Cyclone792

Thanks, Qrusher, let me know if you find anything.

Update for any who wishes to help ... I'm receiving many of the same errors for the 2010 file that I'm receiving for the 2005 file. First it'll ask me for a league.html file when importing the stats, then when creating the the HTMLs I'll get that Error 3021. I've determined that there has been players that have been traded multiple times on the same day. How do I effectively get into the CSVs to fix the bug?

Try opening the lalltrans.txt, find the trades in question and move them to a different day. Then rename the lalltrans.txt to ltrans.txt and give it a go. If you think the trade dates are screwing things up then edit them. If it doesn't work, then you'll know that wasn't causing the problem.

Not sure if this helps but thought I'd throw that in.

f.montoya · 12-13-2005, 08:28 AM

Oh, hopefully you have backups of your mdb before you encountered these problems so you can try the above. If you are using the same mdb, I'm afraid it's a lost cause.

Cyclone792 · 12-13-2005, 03:34 PM

I'm gonna edit some of the trade dates for guys that were dealt twice in one day and see what happens. Right now I'm not even bothering to get a complete database setup ... I'm just trying to test each season to see if it will actually work. Right now five outta seven seasons are good to go, but two of them are giving me errors.

Cyclone792 · 12-13-2005, 04:36 PM

Fixed all the trades so players traded on the same day were all moved to the next day and there's no repeats. However, it's still not working. I'm getting a couple errors on the import alone ...

1) Field Players.Trade cannot be zero length string
2) Asking me to put the league.html file in the data folder

I can use an almanac to get the league.html file, but I'm not sure if that's a proper fix or not. The first error I'm getting with Players.Trade is something that I don't have a clue how to fix. Any help?

EDIT: I've read that with MS Access you can get into the database and fix errors. Any way to access those areas to fix necessary errors if one doesn't have Access?

halofan26 · 12-13-2005, 09:24 PM

WHERE IS CATO WHEN YOU NEED HIM? If anyone out there has a fix for this i would gretly appreciate it as i have given up and passed it to Jason in hopes that he can get it.......

Qrusher14242 · 12-14-2005, 01:13 AM

Tried running the 2005 file and got that same error when importing the ltrans file. Then got the invalid use of null error when starting the HTML pages. Dunno whats up. Sorry

Cyclone792 · 12-14-2005, 03:43 PM

Thanks for taking a look, Q.

Any other help/suggestions from anybody would be greatly appreciated ...

Qrusher14242 · 12-15-2005, 01:05 AM

i got this error after the null error:

Error 3021: Either BOF or EOF is True or the current Record has been deleted. Request operation requires a current record. has occured

It was working on:
Team Summary Positional Charts
Alcatraz Island Jail Break

Not sure if that helps

halofan26 · 12-15-2005, 09:56 AM

thanks a ton for trying Q.......hopefully someone will come up with something so that me and Jason arent forced to go on a killing spree

theasfl · 12-15-2005, 06:25 PM

Im having a problem with my 2005 league file (2nd year), players are getting left off the draft history page, can anyone tell me what to do?

12-12-2005, 05:30 PM	#1
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	Cato Errors - Need a Cato Guru Well, I've actually officially given up on this one particular league file, I think. I'm in the process of attempting to get a fully functional CatoBase up for an online league, but am not able to get past one of our early seasons due to multiple errors. In the last year I've tried multiple attempts at a fix and have tried virtually everything that's ever been posted to the best of my ability. Unfortunately, none of it has worked. So my one last ditch effort is a massive plea for help. Would any Cato gurus be willing to download that end of season league file and give it a shot to run CatoBase with it? The season was ran with OOTP5 so that may or may not be an issue. I even tried importing that league file into 6.5 to run Cato, but that didn't work either. Maybe I'm missing something, or maybe the file is just corrupt, I don't know. The file is located at our site's main page ... http://www.potd.simleaguecentral.com ... in one of the menus on the left side of the screen, there's a series of links for Previous POTD Season Files. The file in question would be the POTD 2005 (OOTP5) season file. Thanks in advance ... and any help is definitely appreciated! __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates Last edited by Cyclone792; 12-12-2005 at 05:36 PM.

12-12-2005, 05:50 PM	#2
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	More information which may help ... 1) There is at least one instance in that 2005 season where a player (Raul Lazpita) was traded twice on the same day. 2) A shortstop named Larry Riker pitched in a game and retired nobody, yet gave up earned runs. I've read of the errors associated with that so I just wiped Riker out of the league entirely and tried it, but that didn't work (Riker is still in the league under the file that can be downloaded off the league's web site). Those are two errors that may be causing problems, but the problem is I don't know how to properly fix them. Not only that, but I'm not sure if those are the only errors causing problems or if there are others as well. Another edit: I've gotten 2003 and 2004 season files to work without any problems, as have Mike and Christina (I see you reading this thread, Mike!). They have also gotten 2006-2009 to work without any problems ... nobody yet has tried 2010-2013. It just boggles my mind how this one particular season in 2005 seems to have something all fouled up. __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates Last edited by Cyclone792; 12-12-2005 at 05:54 PM.

12-13-2005, 07:27 AM	#4
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	Thanks, Qrusher, let me know if you find anything. Update for any who wishes to help ... I'm receiving many of the same errors for the 2010 file that I'm receiving for the 2005 file. First it'll ask me for a league.html file when importing the stats, then when creating the the HTMLs I'll get that Error 3021. I've determined that there has been players that have been traded multiple times on the same day. How do I effectively get into the CSVs to fix the bug? __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates

12-13-2005, 08:28 AM	#6
f.montoya Hall Of Famer Join Date: Nov 2004 Posts: 6,077	Oh, hopefully you have backups of your mdb before you encountered these problems so you can try the above. If you are using the same mdb, I'm afraid it's a lost cause. __________________ Fidel Montoya Asahi2 Baseball League ex-Commissioner(Historical League Since 2004) Ex-Web Host Current Mod Maker??

12-13-2005, 03:34 PM	#7
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	I'm gonna edit some of the trade dates for guys that were dealt twice in one day and see what happens. Right now I'm not even bothering to get a complete database setup ... I'm just trying to test each season to see if it will actually work. Right now five outta seven seasons are good to go, but two of them are giving me errors. __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates

12-12-2005, 07:44 PM	#3
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	Good luck, Im on my second season in cato and when creating the Main League pages for that year, it gives me a E_FAIL error. All the other pages created fine, except for those. Ill try and run the 2005 tonight.

12-13-2005, 04:36 PM	#8
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	Fixed all the trades so players traded on the same day were all moved to the next day and there's no repeats. However, it's still not working. I'm getting a couple errors on the import alone ... 1) Field Players.Trade cannot be zero length string 2) Asking me to put the league.html file in the data folder I can use an almanac to get the league.html file, but I'm not sure if that's a proper fix or not. The first error I'm getting with Players.Trade is something that I don't have a clue how to fix. Any help? EDIT: I've read that with MS Access you can get into the database and fix errors. Any way to access those areas to fix necessary errors if one doesn't have Access? __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates Last edited by Cyclone792; 12-13-2005 at 04:56 PM.

12-13-2005, 09:24 PM	#9
halofan26 All Star Starter Join Date: Aug 2003 Location: Anaheim, Ca Posts: 1,491	WHERE IS CATO WHEN YOU NEED HIM? If anyone out there has a fix for this i would gretly appreciate it as i have given up and passed it to Jason in hopes that he can get it....... __________________ Mike Lambert Sim League Central President Home of the Halofan roster set THE best baseball info and fan site ever The best Angels fan site "Because i got high" - Afroman

12-14-2005, 01:13 AM	#10
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	Tried running the 2005 file and got that same error when importing the ltrans file. Then got the invalid use of null error when starting the HTML pages. Dunno whats up. Sorry

12-14-2005, 03:43 PM	#11
Cyclone792 All Star Reserve Join Date: Nov 2002 Location: Cincinnati, Ohio Posts: 572	Thanks for taking a look, Q. Any other help/suggestions from anybody would be greatly appreciated ... __________________ Jason POTD: Co-Commish and Glacier Bay Ice Pirates

12-15-2005, 01:05 AM	#12
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	i got this error after the null error: Error 3021: Either BOF or EOF is True or the current Record has been deleted. Request operation requires a current record. has occured It was working on: Team Summary Positional Charts Alcatraz Island Jail Break Not sure if that helps

12-15-2005, 09:56 AM	#13
halofan26 All Star Starter Join Date: Aug 2003 Location: Anaheim, Ca Posts: 1,491	thanks a ton for trying Q.......hopefully someone will come up with something so that me and Jason arent forced to go on a killing spree __________________ Mike Lambert Sim League Central President Home of the Halofan roster set THE best baseball info and fan site ever The best Angels fan site "Because i got high" - Afroman

12-15-2005, 06:25 PM	#14
theasfl Hall Of Famer Join Date: Apr 2004 Location: Coral Springs, FL or Orlando, FL (UCF) Posts: 7,988	Im having a problem with my 2005 league file (2nd year), players are getting left off the draft history page, can anyone tell me what to do? __________________ All-Sports Fantasy League The ASFL 22 different games, 9 sports. Please check out the website (www.theasfl.com/asfl2/). The league is free- if you're interested please fill out the signup form and/or email the commissioner. Miami Talons (ABL): 2004, 2005 & 2008 Champs