[Solved] Accounts keep being auto-terminated

[d4f]

I've imported lots (thousands) of clients, hosting accounts and domains from AWBS into Hostbill, but due to tons of issues left the order queue and invoices out. Everything seemed to work nicely... well as nicely as a AWBS-borked database can get.
However since exactly ( suspend-interval + terminate-after ) as configured in the automation settings, Hostbill is beginning to simply terminate hosting accounts without prior notice or information. When manually setting them to Active again (the files still exist on the server) the account is being set to "Terminated" within minutes.

I tried
- manually running the cron with debug commands => No output relating to the issue
- creating an invoice and order for an account.  => still being terminated
- setting the account as "Active" in the database => still being terminated

The account has/had
- no invoice
- no order
- due date far in the future
- a single log entry relating to Terminating from 12 o'clock, no further entries.

Does anyone have an idea how to make the accounts actually stick to their due date without having Hostbill terminate them without any suspension period or warnign?

[d4f]

Ok, my own fault. The database had some mysterious old data none could identify. It took me plaintext SQL logging to find that the following SQL command as part of the cronjob simply marks all accounts as terminated that are in some way related to Enom SSL certificates.

UPDATE hb_accounts SET status='Terminated' WHERE status='Active' AND id IN
            (SELECT account_id FROM hb_enom_certs WHERE NOW()>cert_expires AND cert_expires!='0000-00-00 00:00:00')

Well at least I managed to give you all a good laugh with only my second post. That's something...

[BRJP]

No problems and thank you for the post!  It will help someone else for sure at some point!