Domains all marked as active

[erwin123]

I have like many the problem thar sometimes domains are marked as expired although they are really active.

This happens when a domain is expired and you get it out of quarantaine manually.

If you forget to move the domain in WHMCS to 'Active' the customer might lose his domain because it is never invoiced again.

 

I thought to be clever and run a Mysql query to move all 'Expired' domains to active and let the domainsync of my registrar sort it out.

Unfortunatly for domains that are long expired it reports back 'This domain is not in your account, please transfer it".

The status remains active.

 

Now I have 3500 domains with due/renewal date 00/00/0000 or something like 15/03/2014.

I fear that for all these domains a invoice will be created tonight wich would cause mayhem.

 

What mysql query could I run that sets all domains with say a renewal date < then 01/01/2016 to expired?

 

Any other suggestions for this mess?

 

I do have a backup but I have a very busy site and there are lots of domains registred in the time I tried to solve this manually....

[brian!]

did you resolve this issue?