 |  |
Sean,
Re: optigold crash...please help!
From: brb232@acmemail.net
Date: Tuesday, November 19, 2002
Time: 4:36:17 pm
Thanks for the reply. I'm not sure if I want to try that without you on the
phone in case I really break something when I do this. Can you please send me
a number off-list where I can call you? If you perfer, you have my number.
Thanks again,
Brandon Miller
Partner
Wizzards/Magick.net
Quoting Shawn Hogan <shawn@digitalpoint.com>:
> 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
> ---------------------------------------------------
>
--------------------------------------------------
Get Your FREE E-Mail Account Today at AcmeMail.net
http://www.acmemail.net
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page
| home | |
| products | |
| services | |
| support | |
| email lists |
| optigold isp | |
| optigold isp news | |
| home inspection | |
| inspectrix | |
| java companion | |
| oracle | |
| quickdns pro | |
| search engine | |
| veterinary |
| tips | |
| employees | |
| free tools | |
| portfolio | |
| jobs | |
| contact |
888/4-DPOINTSupport:
858/452-3696