Contribution [HowTo] One-step SQL query to fix IP address assignment issues

[Bernard T]

Hi everyone,

mods: if this is wrong section for this post, please move it.

After a big migration from two older Plesk servers to a new Plesk 12 server I had to fix IP address assignment problems found by Plesk Webserver Configuration Troubleshooter in our server configs.
Since there is a manual 2-steps process described in KB http://kb.odin.com/en/113475, I made a new SQL query which will do everything in one step.

I thought someone else would be interested for it, so I decided to share it:

UPDATE IpAddressesCollections
    LEFT JOIN DomainServices ON IpAddressesCollections.ipCollectionId = DomainServices.ipCollectionId
    LEFT JOIN domains ON DomainServices.dom_id = domains.id
    LEFT JOIN dom_param ON dom_param.dom_id = domains.id
SET ipAddressId = cast(dom_param.val as char)
WHERE IpAddressesCollections.ipAddressId = 0
    AND dom_param.param LIKE 'ip%_addr_id'

I hope it will be useful to someone else, maybe you can update it to the subject KB.