Search Engine: Elastic

Article ID: 6841, created on Nov 3, 2009, last review on Apr 18, 2012

  • Applies to:
  • H-Sphere


When you go to your Parallels H-Sphere admin's panel and select the System Info tab, you get the wrong number of accounts displayed.


The user_accounts table in H-Sphere database must have gotten corrupted and you do not have necessary records  in it.


1. 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.

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF