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

Vladimir Levchuk

Updated August 27, 2024 17:35

kb: technical Plesk Obsidian for Linux

Applicable to:

Plesk for Linux

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

Connect to the server via SSH
Make a copy of psa database:

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

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

# plesk repair db -v -y

If the automatic repair has failed, restore the record from daily dumps:

As a workaround:

1. Connect to the server via SSH

2. Locate the missing record in one of the daily database dumps using the ID mentioned in the error message:

# zgrep "INSERT INTO .hosting." /var/lib/psa/dumps/mysql.daily.dump.2.gz | grep 11

The required record would look similar to the following:

CONFIG_TEXT: (11,229,0,'true','false','true','false','plesk-php73-fpm','true','false','false','false','false','','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false',444,-1,-1,'false','true','true')

3. Back up the Plesk database:

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

4. Access the Plesk database and insert the recovered record:

# plesk db

mysql> insert into hosting values (11,229,0,'true','false','true','false','plesk-php73-fpm','true','false','false','false','false','','true','awstats','false',NULL,'/var/www/vhosts/example.com/httpdocs','false',444,-1,-1,'false','true','true');
Query OK, 1 row affected (0.01 sec)