Domains are absent from Plesk UI after license downgrade

Symptoms

1. After license downgrade, for example from Web Host Edition to Web Pro Edition, some domains are absent from Plesk user interface at Websites & Domains.

2. The following warnings could be found at Tools & Settings > License Management.

   Warning: Resellers management is turned off but you have several resellers(1).
   Warning: Customers management is turned off but you have several customers(1).

3. There are subscriptions which do not belong to the Admin account in Plesk:

   # plesk db
   mysql> select d.name as 'Domain name',c.pname as 'Owner Name' from domains d join clients c on d.cl_id=c.id;
   +--------------+-------------+
   | Domain name | Owner Name |
   +--------------+-------------+
   | example.com | Plesk_admin |
   | example3.com | reseller1 |
   | example2.com | Customer1 |
   +--------------+-------------+
   3 rows in set (0.00 sec)

Cause

Web Pro Edition does not support Reseller Management and Web Admin Edition does not support Reseller/Customer management. Plesk does not display the domains which belong to hidden Resellers or Customers.

Resolution

1. Log in to Plesk

2. Switch the license to Web Host Edition at Tools & Settings > License Management.

3. Navigate to Subscriptions and check all the subscriptions which do not belong to the Plesk Administrator account.

4. Change the subscriber of these subscriptions to the Administrator account through the button Change Subscriber.

   Note: remove resellers and customers if they are not required any more.

5. Set the previous license back at Tools & Settings > License Management > Roll Back Key.

OR

Plesk for Linux:

1. Login to the server via SSH.
2. Change the ownership of all affected subscriptions with the following command:
   

   # for subscription in `plesk bin subscription --list`; do plesk bin subscription --change-owner $subscription -owner admin; done

Plesk for Windows:

1. Login to the server via RDP.
2. Create a Plesk database backup.
3. Find affected domains with the following command:
   

   C:\> plesk db "SELECT * FROM domains WHERE cl_id <>1;"

4. Set correct ownership for domains:
   

   C:\> plesk db "UPDATE domains SET cl_id = 1 WHERE name = 'example.com';"

   Note: example.com should be replaced with an appropriate name.

Additional info

Plesk available editions and differences between them