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
-
Reveal domains owned by wrong client with id 0:
# plesk db “select * from domains where cl_id = 0”
-
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.