E
eryan
Guest
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)
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)