- Plesk Onyx for Windows
When creating a new account in WHMCS the following error appears:
Error code: 2204. Error message: Unable to update hosting preferences. Dependent row(s) 'Certificates.id = 4'
Inconsistency in Plesk database.
- Log in to the server via RDP
Create a backup of
psadatabase with reference to How to backup/restore a Plesk database dump
Login to Plesk database and find IP addresses with broken references on SSL certificates:
MYSQL_WIN: plesk db
mysql> select ip_address from IP_Addresses where ssl_certificate_id not in (select id from certificates);
- Update attributes for IP addresses from the output above. Go to Plesk > Tools&Settings > IP Addresses > [IP from the output of command above] and click OK .