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
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	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? __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

12-03-2004, 08:30 PM	#2
rem Hall Of Famer Join Date: Jul 2003 Location: College Park, Md. Posts: 5,024	Buy a laptop which gives you battery backup. __________________ OTBA: Washington Filibusters CLBR: Minnesota Twins 2005 Winner of LL's Pick the Loser Contest! - 15-0

12-04-2004, 01:19 AM	#3
jmm8356 All Star Starter Join Date: Jul 2004 Location: Lafayette IN (by way of Tonawanda NY) Posts: 1,673	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
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	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
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	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 __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

12-04-2004, 11:56 PM	#6
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	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
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	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 __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

12-05-2004, 10:03 AM	#8
jmm8356 All Star Starter Join Date: Jul 2004 Location: Lafayette IN (by way of Tonawanda NY) Posts: 1,673	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! )