1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by eryan, Dec 12, 2010.

  1. eryan

    eryan Guest

    0
     
    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)
     
Loading...