Cannot add additional domain: Error: Dependent row(s) 'Certificates.id = xx' isn't found for 'IP_Addresses.ssl_certificate_id = xx'.

Created:

2017-04-24 22:03:28 UTC

Modified:

2017-08-16 15:59:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot add additional domain: Error: Dependent row(s) 'Certificates.id = xx' isn't found for 'IP_Addresses.ssl_certificate_id = xx'.

Applicable to:

  • Plesk for Windows

Symptoms

Cannot add additional domain with the following error:

Error: Dependent row(s) 'Certificates.id = 17' isn't found for 'IP_Addresses.ssl_certificate_id = 17'.

The certificate with ID 17 was assigned to the subscription'ss IP address, however there is no such certificate in Certificates table:

mysql> select ip_address, ssl_certificate_id, default_domain_id from IP_Addresses where ip_address="203.0.113.2";
+---------------+--------------------+-------------------+
| ip_address | ssl_certificate_id | default_domain_id |
+---------------+--------------------+-------------------+
| 203.0.113.2 | 17 | 442 |
+---------------+--------------------+-------------------+
1 row in set (0.00 sec) mysql> select * from Certificates where id = 17;
Empty set (0.00 sec)

Cause

Database inconsistency

Resolution

Browse to Tools & Settings > IP Addresses >203.0.113.2 and assigned existing certificate

Have more questions? Submit a request
Please sign in to leave a comment.