Unable to open SSL Certificates menu in Plesk: Unable to find row with id 0 in certificates table

Symptoms

• Unable to open Tools & Settings > SSL/TLS Certificates in Plesk:
  

  PLESK_ERROR: Unable to find row with id 0 in certificates table

• Plesk repair DB failed with the same error:
  

  CONFIG_TEXT: Assigning the default SSL/TLS certificate to the IP address ..... [FAILED]
  - Unable to find row with id 0 in certificates table.

Cause

Database inconsistency

Resolution

1. Connect to the server via SSH
2. Create Plesk database backup
3. Connect to Plesk database:
   

   # plesk db

4. Run the following query to list current certificates:

   MYSQL_LIN: select id, name from certificates;
   +----+---------------------------------------------+
   | id | name                                        |
   +----+---------------------------------------------+
   |  1 | Backup sign certificate                     |
   |  2 | example.com                                 |
   +----+---------------------------------------------+

5. Choose one of the certificates ID to temporary set as default and then run the following query to add it to the database:
   

   MYSQL_LIN: insert into misc values ('default_certificate_id', 2);