Unable to enable ModSecurity: Unable to find row xxx with id in domains table

Symptoms

• Impossible to enable ModSecurity with the following error message:

  PLESK_ERROR: Failed to install the ModSecurity rule set: Unable to find row with id 11 in domains table.
  Unable to use the current ModSecurity rule set and to roll back to the previous version because they contain invalid rules.

• There is no domain with such ID:

  C:> C:>plesk db “select * from domains where id=11”
  C:>

Cause

Orphaned records in psa.IisAppPools

Resolution

1. Connect to the server via RDP

2. Create Plesk database backup

3. Check if there is an orphaned record:

   MYSQL_WIN: mysql> select id from IisAppPools where ownerId=11;
   +—–+
   | id |
   +—–+
   | 188 |
   +—–+

4. Remove the record:

   MYSQL_WIN: mysql> delete from IisAppPools where ownerId=11;