Unable to install Plesk updates: Some database entries related to Panel IP addresses are corrupted

Follow

Comments

4 comments

  • Avatar
    Trevor Lorkings

    Plesk 17.0.17 #54
    CentOS Linux 7.5.1804 (Core)

    I get the warning "Some database entries related to Panel IP addresses are corrupted." and have run the DB code which shows no entries for ipAddressId=0, so there are no orphaned records.

    When I run
    select * from IpAddressesCollections
    there are 16 rows of data where ipAddressId is either 1 or 2.

  • Avatar
    Ivan Postnikov

    Hello @Trevor,

    in this case, ipAddressId is not meant to be 0, have used the query (select * from IpAddressesCollections where ipAddressId not in (select id from IP_Addresses);) or modified it somehow?

  • Avatar
    Trevor Lorkings

    Thank you @Ivan

    This is what I get when running the query command. This is the first time I've ever been into SSH to run any plesk db commands so I don't know how to modify anything. I spend most of my time on Windows servers so the SSH command line is alien to me.

  • Avatar
    Ivan Postnikov

    Hi @Trevor, I am glad to know that my advice helped.

Please sign in to leave a comment.

Have more questions? Submit a request