Data problem

Discussion in 'Optigold ISP' started by adacomp, May 12, 2005.

0
  1. #1
    My billing clerk was browsing accounts and we found the following problem. We have had a customer in the system since 2004 and today we discovered that her data records are all blank. They were OK for the March billing as she received a bill because we have a payment. The only thing that shows up in her record is a 0 in the password field in the Cust info record. All other fields on this page are blank and all other pages are blank. When we print the Deposit report for her last deposit it shows a () (open/close paren) as her customer name,login. Date, time, check # and amount all show OK. I assume links are lost for this customer. I ran reindex but it didn't change anything. What is the next step? We are using V3.3.2
     
    adacomp, May 12, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    How are you able to determine which customer record it was exactly?
     
    digitalpoint, May 12, 2005 IP
  3. adacomp

    adacomp Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Did a find on last name "Clark" (her last name and also her login) and it showed 11 records. Scanned one at a time and it showed all Clarks in our paper files except the one which is not displaying. Printed a Deposit report for the day of her last payment and it is as stated before with every thing correct for her last payment.
     
    adacomp, May 12, 2005 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    Hmmm... that is definitely odd. You have you already tried to recover all files?
     
    digitalpoint, May 12, 2005 IP
  5. adacomp

    adacomp Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Sorry.. I have been gone for a couple of days. I have not tried to recover the files yet. I will download the latest version today. It automatically converts/recovers on an upgrade, right?
     
    adacomp, May 17, 2005 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    No, it does not do a recovery.
     
    digitalpoint, May 17, 2005 IP
  7. adacomp

    adacomp Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Ran recover on all files and problem still exists. Next suggestion?
     
    adacomp, May 23, 2005 IP
  8. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #8
    I would go to a backup in that case.
     
    digitalpoint, May 23, 2005 IP
  9. adacomp

    adacomp Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Not possible to go to backup because too much has transpired since we found the problem. Will have to add as new customer and lose the history.
     
    adacomp, May 23, 2005 IP