Search Again: Re: optigold crash...please help! From: Shawn Hogan Date: Tuesday, November 19, 2002 Time: 4:24:25 pm brb232@acmemail.net wrote: > My name is Brandon Miller and this is my first post (in the last 8 months) to > this list. I have a registered version of OptiGold 2.0 with a 6,000 account > license. I tried the upgrade some time ago with no avail...hence the old > version. Here's my problem: > > Our main_menu file became corrupt and I replaced it with a previously backed > up copy. Everything is ok except for one field, the account expiration date. > All of the invoices, payments, cancels, etc. are all there and intact. For > some reason the account exp. date is wrong on almost every account. I have > tried rebuilding the indexes and it didn't help. > > Is there some way to get the databases to go back and read the account > creation date + invoicing + payments to recreate the exp. date? > > Any assistance would be extremely helpful. I can't guarantee this would work, but you could try it... Hold down the SHIFT key and click on the Expiration date field. Then go to the scripts menu and replace with a calculated result, with the following calculation: Date (Month (Establish Date) + Sum (Invoices::cMonths Credit) - Sum (Open Invoices::cMonths Credit), Day (Establish Date) + Sum (Invoices::cDays Credit) - Sum (Open Invoices::cDays Credit), Year (Establish Date)) You will need to rebuild indexes afterwards. Also, backup your data before you try it. And lastly, check out: http://www.digitalpoint.com/services/backup/ :) - Shawn ------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: optigold crash...please help! by brb232@acmemail.net on Nov 19, 2002 at 12:03:51 pm Re: optigold crash...please help! by Shawn Hogan on Nov 19, 2002 at 4:24:25 pm Re: optigold crash...please help! by brb232@acmemail.net on Nov 19, 2002 at 4:36:17 pm Re: optigold crash...please help! by Shawn Hogan on Nov 19, 2002 at 4:40:50 pm Re: optigold crash...please help! by brb232@acmemail.net on Nov 19, 2002 at 5:54:07 pm Re: optigold crash...please help! by Shawn Hogan on Nov 19, 2002 at 9:06:18 pm Re: optigold crash...please help! by Just Carl on Nov 20, 2002 at 12:27:38 pm Re: optigold crash...please help! by Just Carl on Nov 20, 2002 at 12:32:08 pm