Domains list is empty: a.ownerName is null

Symptoms

• Domains list keeps loading but nothing is shown, it is empty. The following error might me shown:

  PLESK_ERROR: Internal error ;-P
  TypeError: a.ownerName is null

• Plesk repair utility detect database inconsistency:

  # plesk repair db -n
  […]
  Inconsistency in the table ‘domains’ for the column cl_id: Wrong customer ID for the additional domain with ID 113 …………….. [ERROR]
  Inconsistency in the table ‘domains’ for the column cl_id: No rows in the table ‘clients’ with id = 0 ………………………….. [ERROR]

  The id from the above error might be different from “0”.

Cause

Database inconsistency.

Resolution

1. Connect to the server via SSH or via RDP;

2. Create Plesk database backup;

3. Reveal domains owned by wrong client with id 0:

   # plesk db “select * from domains where cl_id = 0”

4. Set all affected domains with wrong client id to be owned by Plesk admin:

   # plesk db “update domains set cl_id = 1 where cl_id = 0”

As an alternative, restore the latest working database dump as described in the article.

Additional information

Domains list is empty: Inconsistency in the table ‘dom_param’ for the column dom_id: No rows in the table ‘domains’