Important info for those who have converted from AWBS

[Troy]

We've just migrated a fairly sizable database from AWBS to WHCMS, and discovered that an Apostrophe in any of the customer data in AWBS caused the record to not import into WHMCS, while the customer's domains and hosting packages did import.

 

Thus, we ended up with active hosting packages and domains in WHMCS with no customer records - and as a result no billing.

 

I've alerted Matt to the problem via a support ticket, but wanted to also post here so that folks who've converted from AWBS can look for orphaned records:

 

Here are two simple queries to check your WHMCS database for missing customers:

 

Hosting packages with no customer:

 

select * from tblhosting

where userid not in

(select id from tblclients)

 

Domains with no customer:

 

select * from tbldomains

where userid not in

(select id from tblclients)

[openmind]

Has this now been fixed?