For every league I have, Catobase eventually stops working

ctorg · 05-18-2005, 09:32 AM

It's the Win Shares. Apparently if something is amiss in the database regarding the manager fields, it has errors with Win Shares calculation. Or something like that. Whatever it is, every single league I have run with OOTP6 using Catobase has eventually had Win Shares crap out, and I've had to turn the feature off. An error message about a null integer or something comes up, and when it's done making the pages, some or all players for that season have no Win Shares records.

I don't have MS Access, so I can't fix the database itself. I would bring it to work, but the computer I play on 1) has no internet access and 2) has a broken CD-R drive, so transporting large files is not very possible right now.

Do other people commonly see this issue come up? I know others have had the problem, but I'm trying to gauge how common it is. I also don't know why it happens or if it can be prevented by taking measures ahead of time.

Sometimes it takes quite a few seasons for it to happen, sometimes just a few, so I wanted to differentiate between people who sim a lot of seasons and people who haven't done so.

Melo · 05-18-2005, 09:39 AM

I voted option #2. I haven't used it a whole lot because when I did something always went wrong. It seems that some people have no probs and others do. It just seems to be too high a maintenance program for my taste.

DaveHorn · 05-18-2005, 09:58 AM

CTorg - those USB flash drives are getting down right dirt cheap now days. Especially the smallest size which is all the would be required to hold a zipped mdb file. Of course, a new CDR would only cost around $50 or so tops too. So maybe that doesn't help much.

rem · 05-18-2005, 10:21 AM

I don't run Catobase that much but I've never had a problem.

Chappy · 05-18-2005, 05:10 PM

How far down the line does this usually happen to you? I've gone as far as 30 years without seeing this...

SandMan · 05-18-2005, 08:56 PM

Over 600 seasons played - no problem that I could not fix. But again I am a programmer by trade and have used access for about 14 years. I have had small problems and I feel that the design of the program is not great. I don't believe a program should blow up if there are data problems. Maybe log the problem, skip the record and keep processing. The program started small and grew to what it is today. It needs an overhaul for sure.....

sporr · 05-22-2005, 05:27 PM

I've seen this one, but more troubling is this one that has prevented Catobase from being used at all in several leagues that I'm in.

Spindel · 05-27-2005, 04:53 AM

I had this problem recently. I started the league last year.

reslfc · 05-29-2005, 10:52 PM

Quote:

Originally Posted by sporr

I've seen this one, but more troubling is this one that has prevented Catobase from being used at all in several leagues that I'm in.

I encountered that problem trying to run Catobase for a league I'm in. Very frustrating.

plannine · 06-02-2005, 08:18 AM

Don't use Winshares, Don't have a problem (also dont use Minor league stats, pictures, logos). Only have 30 players in the Top rankings. Started with (Historical Players) 1901, now up to 2041 (fictional - couldnt stop with 2000 as planned!!!)

ctorg · 10-17-2005, 09:06 AM

Just wondering if anyone has ever come up with a reliable way to fix this other than turning off Win Shares, which is what I've had to do.

SandMan · 10-17-2005, 09:20 AM

Quote:

Originally Posted by ctorg

Just wondering if anyone has ever come up with a reliable way to fix this other than turning off Win Shares, which is what I've had to do.

Your problem is easy to fix, but requires ACCESS to maintain a table... Someone should write a simple table maintenance program for this database. 99% of the problems have a simple fix, once you know the problem and the table it is in. As you stated almost all are winshare related.

ctorg · 10-17-2005, 11:51 AM

Quote:

Originally Posted by SandMan

Your problem is easy to fix, but requires ACCESS to maintain a table... Someone should write a simple table maintenance program for this database. 99% of the problems have a simple fix, once you know the problem and the table it is in. As you stated almost all are winshare related.

Is there a quick Access fix as a one time shot? I have the database open in Access at work now, but I'm not sure what fields need fixing.

View Poll Results: Have you experienced the problem described in the first post?
I have run Catobase a lot, and I have had the problem	8	14.55%
I haven't run Catobase a lot, and I have had the problem	8	14.55%
I have run Catobase a lot, and I haven't had the problem	25	45.45%
I haven't run Catobase a lot, and I haven't had the problem	14	25.45%
Voters: 55. You may not vote on this poll

05-18-2005, 09:32 AM	#1
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	For every league I have, Catobase eventually stops working It's the Win Shares. Apparently if something is amiss in the database regarding the manager fields, it has errors with Win Shares calculation. Or something like that. Whatever it is, every single league I have run with OOTP6 using Catobase has eventually had Win Shares crap out, and I've had to turn the feature off. An error message about a null integer or something comes up, and when it's done making the pages, some or all players for that season have no Win Shares records. I don't have MS Access, so I can't fix the database itself. I would bring it to work, but the computer I play on 1) has no internet access and 2) has a broken CD-R drive, so transporting large files is not very possible right now. Do other people commonly see this issue come up? I know others have had the problem, but I'm trying to gauge how common it is. I also don't know why it happens or if it can be prevented by taking measures ahead of time. Sometimes it takes quite a few seasons for it to happen, sometimes just a few, so I wanted to differentiate between people who sim a lot of seasons and people who haven't done so. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

05-18-2005, 09:58 AM	#3
DaveHorn All Star Starter Join Date: Aug 2003 Posts: 1,146	CTorg - those USB flash drives are getting down right dirt cheap now days. Especially the smallest size which is all the would be required to hold a zipped mdb file. Of course, a new CDR would only cost around $50 or so tops too. So maybe that doesn't help much. __________________ Dave HFTC Commish

05-18-2005, 10:21 AM	#4
rem Hall Of Famer Join Date: Jul 2003 Location: College Park, Md. Posts: 5,024	I don't run Catobase that much but I've never had a problem. __________________ OTBA: Washington Filibusters CLBR: Minnesota Twins 2005 Winner of LL's Pick the Loser Contest! - 15-0

05-18-2005, 05:10 PM	#5
Chappy Hall Of Famer Join Date: Dec 2001 Location: Raleigh, NC Posts: 2,721	How far down the line does this usually happen to you? I've gone as far as 30 years without seeing this... __________________ NPBL - Pennsylvania Freedom AFBL - North Carolina Aviators MLB-Pro - Kansas City Royals

05-18-2005, 09:39 AM	#2
Melo All Star Starter Join Date: Nov 2003 Location: Where the baned reside Posts: 1,428	I voted option #2. I haven't used it a whole lot because when I did something always went wrong. It seems that some people have no probs and others do. It just seems to be too high a maintenance program for my taste.

05-18-2005, 08:56 PM	#6
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Over 600 seasons played - no problem that I could not fix. But again I am a programmer by trade and have used access for about 14 years. I have had small problems and I feel that the design of the program is not great. I don't believe a program should blow up if there are data problems. Maybe log the problem, skip the record and keep processing. The program started small and grew to what it is today. It needs an overhaul for sure.....

05-22-2005, 05:27 PM	#7
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	I've seen this one, but more troubling is this one that has prevented Catobase from being used at all in several leagues that I'm in.

05-27-2005, 04:53 AM	#8
Spindel All Star Reserve Join Date: Oct 2003 Location: NJ Posts: 763	I had this problem recently. I started the league last year. __________________ Union League Baseball Commissioner

06-02-2005, 08:18 AM	#10
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 572	Don't use Winshares, Don't have a problem (also dont use Minor league stats, pictures, logos). Only have 30 players in the Top rankings. Started with (Historical Players) 1901, now up to 2041 (fictional - couldnt stop with 2000 as planned!!!)

10-17-2005, 09:06 AM	#11
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Just wondering if anyone has ever come up with a reliable way to fix this other than turning off Win Shares, which is what I've had to do. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils