SQL Problem

[kenwardc]

Hi Folks

 

My WHMCS server disk ran out of space on Sunday afternoon and, although WHMCS is on a much larger partition, the SQL Databases are all on the disk that I had the problem with. I got an error in WHMCS (we were entering transactions and new clients) and, when I realised what the problem was, and made some space available, I rebooted the server and logged back into WHMCS Admin.

 

Went back to the same customer I was looking at when the problem happened and, although from his summary screen there is a list of products and services, and his domain and invoices, when I go into his account, there are no products and services. If I click on the products and services tab, I get "Service ID Not Found".

 

Until this morning I thought that was the only issue because I could list other customers' services OK. However, I have now realised there are other issues too, such as none of the domains in any account have a Registrar listed and the pulldown box just says "None". If I go to pricing for the domains there are no registrars listed at all.

 

I have a backup every night of the database so I know I could probably restore from the Saturday night backup but, if there is a chance to correct the problem first, I'd rather do that.

 

Does anyone know whether there is a way to relink the records and correct this error?

 

Thanks in anticipation.

Chris