SymptomsWhen you go to your Parallels H-Sphere admin's panel and select the System Info tab, you get the wrong number of accounts displayed.
CauseThe user_accounts table in H-Sphere database must have gotten corrupted and you do not have necessary records in it.
Resolution1. Log into your control panel box as cpanel.
2. Enter the H-Sphere database with the corresponding password:
# psql hsphere wwwuser
3. Run the following query:
> DELETE FROM accounts WHERE id NOT IN (SELECT account_id FROM user_account) AND deleted is not NULL;
4. Log into your CP box as root.
5. Restart your CP.