PleskDBException error in Plesk

This article applies to 123-reg servers.

This article will explain what to do if you get a PleskDBException error in Plesk Panel.

PleskDBException

If you see the following error in Hosting Services > Domains > Manage Hosting

Internal error: Unable to find service node for web service on domain with id=7

Message Unable to find service node for web service on domain with id=7
File PhDomainBase.php
Line 775
Type PleskDBException

Please note: Updating Plesk will NOT solve this problem.

To resolve the issue you can use this SQL query to fix it with the IP from the client's pool:

mysql> update ip_pool, clients, IpAddressesCollections, domains, DomainServices, IP_Addresses set
ipAddressId=IP_Addresses.id where DomainServices.ipCollectionId =
IpAddressesCollections.ipCollectionId and domains.id=DomainServices.dom_id and clients.id=domains.cl_id and
ipAddressId not in (select id from IP_Addresses) and IP_Addresses.id =
ip_pool.ip_address_id and pool_id = ip_pool.id;

In the case of missing ipCollections:

mysql> select dom_id, DomainServices.type, DomainServices.ipCollectionId, ip_address_id, name as
domain_name, login as owner_login from DomainServices, domains, clients, ip_pool where
ipCollectionId not in (select IpAddressesCollections.ipCollectionId from IpAddressesCollections) and
domains.id=DomainServices.dom_id and clients.id = domains.cl_id and ip_pool.id = clients.pool_id and
DomainServices.type="web" group by ipCollectionId;

+--------+------+----------------+---------------+-------------+-------------+
| dom_id | type | ipCollectionId | ip_address_id | domain_name | owner_login |
+--------+------+----------------+---------------+-------------+-------------+
| 52     | web  |            106 |             2 | forward.tld | gd          |
| 55     | web  |            113 |             1 | domain.tld  | admin       |
+--------+------+----------------+---------------+-------------+-------------+


mysql> insert into IpAddressesCollections (ipCollectionId, ipAddressId) values (106,2),(113,1);

Once you have fixed the database records you will need to recreate the Apache config files:

# /usr/local/psa/admin/sbin/httpdmng --reconfigure-all

Answer options

Your feedback was successfully added.

Answer tracking

Track

Watch the content of this article for changes.