CatoBase problem, power failure

Carlton · 12-03-2004, 08:09 PM

While processing a year, my CPU failed when the power went off, in the middle of importing...when I retried it said the year was already in the DB...I deleted all the files not in a year folder in the data what else do I need to do?

rem · 12-03-2004, 08:30 PM

Buy a laptop which gives you battery backup.

jmm8356 · 12-04-2004, 01:19 AM

Go to Database / Delete 19xx Season (19xx will be whatever your most recent season is) and it will delete all the data from that year from the database, so you can re-import cleanly.

Operation Shutdown · 12-04-2004, 12:16 PM

You could always just reload your most recent backup.

Though, jmm's suggestion would also work as long as that season is listed there. If not, you'd have to probably manually delete every field in the database for that year.

Carlton · 12-04-2004, 03:30 PM

Ok I did the backup thing...reloaded...exit
renamed it mlb
smooth...

BUT

then when creating the html pages CPU froze...UGH!!!!

What do I delete?
Or do I follow jmm's advice and say delete 19xx...and then reimport and recreate the html pages again...it froze on SS positional leaderboards

Operation Shutdown · 12-04-2004, 11:56 PM

I'd probably follow jmm's advice. Just make sure that 19xx is actually the year that you were importing when the power went out. The whole deleting every record thing was more of a joke. I can't imagine how long it'd take to do that and I'd imagine it would be painstakingly, well a pain in the ass. Though, if it's a last resort and you absolutely need it, I'd imagine it could be done.

Carlton · 12-05-2004, 12:43 AM

Yea the season is already imported, but if I create the HTML again...I know it will not finish because it was in the midst of being created, I forgot what error I got last time my CPU froze in the middle of the 5 hour create HTML process, but I am sure it will kick me out

jmm8356 · 12-05-2004, 10:03 AM

If you haven't tried it yet, I'd definitely do a Delete 19xx and then re-import that year...

Is the computer freezing up because of Catobase or because of something else? Before you start creating HTML, disable your anti-virus software (it'll go a lot faster, if nothing else) and screen saver, and make sure there aren't any scheduled tasks that will go off while Catobase is running, such as scandisk, defrag, etc.

It's also possible that your entire database was hosed by the power failure, and that you'll have to recreate the entire thing from Year 1... but I think it's more likely that your computer freezing has nothing to do with the power failure, or even Catobase at all.

12-03-2004, 08:09 PM	#1 (permalink)
Carlton Hall Of Famer Join Date: Mar 2002 Location: Troy, NY Posts: 2,734 Thanks: 52 Thanked 16x in 14 posts	CatoBase problem, power failure While processing a year, my CPU failed when the power went off, in the middle of importing...when I retried it said the year was already in the DB...I deleted all the files not in a year folder in the data what else do I need to do? __________________ "Curt's a friend of mine," Glanville said. "We used to play video games together. He killed one of my characters one time. I never forgot that."

12-03-2004, 08:30 PM	#2 (permalink)
rem Hall Of Famer Join Date: Jul 2003 Location: College Park, Md. Posts: 4,998 Thanks: 7 Thanked 7x in 5 posts	Buy a laptop which gives you battery backup. __________________ Born To Play: Commissioner, Baltimore Orioles GM MLB 93: Baltimore Orioles OTBA: Washington Filibusters 2005 Winner of LL's Pick the Loser Contest! - 15-0

12-04-2004, 01:19 AM	#3 (permalink)
jmm8356 All Star Starter Join Date: Jul 2004 Location: Tonawanda NY Posts: 1,671 Thanks: 205 Thanked 33x in 21 posts	Go to Database / Delete 19xx Season (19xx will be whatever your most recent season is) and it will delete all the data from that year from the database, so you can re-import cleanly. __________________ Jeremy from Tonawanda --- Go Cubbies! --- Unofficial Theta Tester(tm) "Oh, we got both kinds. We got country and western!" From OOTP 6: Designated for Assignment FAQ (Includes both problems and solutions! Ooooo! )

12-04-2004, 12:16 PM	#4 (permalink)
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 840 Thanks: 1 Thanked 5x in 5 posts	You could always just reload your most recent backup. Though, jmm's suggestion would also work as long as that season is listed there. If not, you'd have to probably manually delete every field in the database for that year. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

12-04-2004, 03:30 PM	#5 (permalink)
Carlton Hall Of Famer Join Date: Mar 2002 Location: Troy, NY Posts: 2,734 Thanks: 52 Thanked 16x in 14 posts	Ok I did the backup thing...reloaded...exit renamed it mlb smooth... BUT then when creating the html pages CPU froze...UGH!!!! What do I delete? Or do I follow jmm's advice and say delete 19xx...and then reimport and recreate the html pages again...it froze on SS positional leaderboards __________________ "Curt's a friend of mine," Glanville said. "We used to play video games together. He killed one of my characters one time. I never forgot that."

12-04-2004, 11:56 PM	#6 (permalink)
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 840 Thanks: 1 Thanked 5x in 5 posts	I'd probably follow jmm's advice. Just make sure that 19xx is actually the year that you were importing when the power went out. The whole deleting every record thing was more of a joke. I can't imagine how long it'd take to do that and I'd imagine it would be painstakingly, well a pain in the ass. Though, if it's a last resort and you absolutely need it, I'd imagine it could be done. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

12-05-2004, 12:43 AM	#7 (permalink)
Carlton Hall Of Famer Join Date: Mar 2002 Location: Troy, NY Posts: 2,734 Thanks: 52 Thanked 16x in 14 posts	Yea the season is already imported, but if I create the HTML again...I know it will not finish because it was in the midst of being created, I forgot what error I got last time my CPU froze in the middle of the 5 hour create HTML process, but I am sure it will kick me out __________________ "Curt's a friend of mine," Glanville said. "We used to play video games together. He killed one of my characters one time. I never forgot that."

12-05-2004, 10:03 AM	#8 (permalink)
jmm8356 All Star Starter Join Date: Jul 2004 Location: Tonawanda NY Posts: 1,671 Thanks: 205 Thanked 33x in 21 posts	If you haven't tried it yet, I'd definitely do a Delete 19xx and then re-import that year... Is the computer freezing up because of Catobase or because of something else? Before you start creating HTML, disable your anti-virus software (it'll go a lot faster, if nothing else) and screen saver, and make sure there aren't any scheduled tasks that will go off while Catobase is running, such as scandisk, defrag, etc. It's also possible that your entire database was hosed by the power failure, and that you'll have to recreate the entire thing from Year 1... but I think it's more likely that your computer freezing has nothing to do with the power failure, or even Catobase at all. __________________ Jeremy from Tonawanda --- Go Cubbies! --- Unofficial Theta Tester(tm) "Oh, we got both kinds. We got country and western!" From OOTP 6: Designated for Assignment FAQ (Includes both problems and solutions! Ooooo! )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode