Duplicated mail service resource creation

Resolution

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.