Domain hosting settings can't be opened in Plesk: Internal error: Full path is undefined. Inconsistency in the table 'domains' for the column id: No rows in the table 'hosting' with dom_id

Symptoms

• The following error is displayed when running plesk repair db on the server:

# plesk repair db
Inconsistency in the table 'domains' for the column id: No rows in
the table 'hosting' with dom_id ='11'

• The ID mentioned in the error message does not exist in the hosting table, but it does have a record in the domains table:

MYSQL_LIN: select * from hosting where dom_id=11;
Empty set (0.00 sec)

select name from domains where id=11;
+---------------+
| name |
+---------------+
| example.com |
+---------------+
1 row in set (0.000 sec)

• Trying to access Domains > example.com > Hosting Settings menu of the affected domain fails:

PLESK_ERROR: Internal error: Full path is undefined.
Message Full path is undefined.
File Webspace.php
Line 399
Type PleskFatalException

• The example.com domain's status is Disabled

Cause

Database inconsistency - there is missing record from the hosting table.

Resolution

1. Connect to the server via SSH

2. Make a copy of psa database:

# plesk db dump psa > "psa.sql.$(date +'%Y-%m-%d_%T').backup"

3. Run a Plesk database check and repair the inconsistencies in the database:

# plesk repair db -v -y