For Linux:
For FreeBSD:
To resolve this problem you need to make some change in H-Sphere DB.
To run SQL queries against the H-Sphere system database, you need to log into H-Sphere system database:
1. Log in as root on the CP server:
$ su -
2. Log in as the cpanel user:
# su -l cpanel
3. Connect to the system database:
# psql -d hsphere wwwuser
4. Run the following SQL queries:
# begin;
# update plan_iresource set plan_id=-plan_id where plan_id =
and type_id=2 and new_type_id=1000 and new_mod_id='signup';
# commit;
5. Restart CP.
a. If plan and user creation works OK, you'll need to delete backuped data:
begin;
delete from plan_iresource where plan_id =-and type_id=2
and new_type_id=1000 and new_mod_id='signup';
commit;
b. If something goes wrong, rollback changes:
begin;
update plan_iresource set plan_id=-plan_id where plan_id =-
and type_id=2 and new_type_id=1000 and new_mod_id='signup';
commit;
Note: Replace "" by your plan id.
