Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Unable to load object of type IPAddress with id=8  (Read 5921 times)

0 Members and 1 Guest are viewing this topic.

anju

  • Guest
Unable to load object of type IPAddress with id=8
« on: October 22, 2013, 06:51:56 am »
This issue is caused by an inconsistency in the Parallels Plesk Panel database. Orphan entries (referred to as IP addresses) remain attached to the Plesk administrator IP pool when the IP addresses are removed from the system.


You can fix the issue by using the following steps.

-----> Access the mysql

-----> Select the psa database

-----> Find the IP addresses using the following query.


mysql> select ip_pool.id,ip_pool.ip_address_id,IP_Addresses.id from ip_pool left join IP_Addresses on ip_pool.ip_address_id=IP_Addresses.id where IP_Addresses.id is NULL;
+----+---------------+------+
| id | ip_address_id | id   |
+----+---------------+------+
|  1 |             5 | NULL |
|  1 |             6 | NULL |
|  1 |             7 | NULL |
|  1 |            30 | NULL |
|  1 |            31 | NULL |
|  1 |            33 | NULL |
|  1 |            34 | NULL |
+----+---------------+------+


-----> Remove orphan entries using a query similar to the query below:

mysql> delete from ip_pool where ip_address_id in (5,6,7,30,31,33,34);