Plesk “Domains” list is empty

If you click into Plesk and find your Domains list is empty, but Subscriptions is still populating, then chances are you have some orphaned domain aliases.  If, however, both the Domains list and Subscriptions lists are empty, you probably have some domains tied to customers that do not exist.

For the missing customer issue, i.e. Subscriptions and Domains are both empty, the following article explains how to fix:

https://kb.plesk.com/en/123469

If, however, only Domains is empty, and your FireFox or Google Chrome Developer Tools debugger mentions a null JavaScript element, check your domain_aliases table with this query on the psa database:

SELECT domain_aliases.dom_id
FROM domain_aliases
LEFT OUTER JOIN domains
 ON domains.id = domain_aliases.dom_id
 WHERE domains.id IS NULL;

This will reveal domain ID numbers that *SHOULD* exist in the domains table; i.e.:

SELECT * FROM domains WHERE id = '###'

should produce a result if you insert the domain id number in for ###.  If you find that they don’t actually exist, remove the corresponding entries from the domain_aliases table:

DELETE FROM domain_aliases WHERE dom_id ='###';

One Reply to “Plesk “Domains” list is empty”

Leave a Reply to MOWS Cancel reply

Your email address will not be published. Required fields are marked *