Internal error: Unable to load object of type IPAddress with id=3: Table->select() fa

[eryan]

Hi there.

Just wanted to share our problem and solution in case it helps anyone else, and for future reference.

Product: Parallels Plesk Panel v10.0.1_build109101029.19 os_Debian 5.0
OS Linux 2.6.26-2-amd64

Problem:
When trying to add a client, we get the following error:
Internal error: Unable to load object of type IPAddress with id=3: Table->select() failed: no such row in the table

Cause:
Erroneous IP address added to a domain, then removed from Plesk IP pool

Solution:
Contacted Parallels support and (after 12 days!) someone finally managed to log in and solve it as follows:

Logged in to mysq:

mysql> select ip_address_id,dom_id from hosting ;
+---------------+--------+
| ip_address_id | dom_id |
+---------------+--------+
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |
| 3 | 1 |
+---------------+--------+
4 rows in set (0.00 sec)

mysql> select name from domains where id=1;
+----------+
| name |
+----------+
| domain.com |
+----------+

So here is the problem, the domain is mapped to an ip_address_id that does not exist.

So they mapped the domain to an existing IP Address.

mysql> update hosting set ip_address_id=4 where dom_id=1;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> delete from ip_pool where ip_address_id=3;
Query OK, 2 rows affected (0.26 sec)

root:~# /usr/local/psa/bin/domain -u domain.com -ip 192.168.0.2
SUCCESS: Update of domain 'domain.com' complete.


Outcome:
We can now add customers again.

(But we appear to have some other problems)