ModSecurity rule-set activation/update fails in Plesk: Unable to find row with id X in domains table

Connect to the Plesk server via SSH.

Create a Plesk database dump:

# plesk db dump psa > /root/psa_dump.sql

Repair the Plesk database:

# plesk repair db -y

Log in to Plesk.

Go to Tools & Settings > Web Application Firewall (ModSecurity), and click OK to update/activate the rule-set.

Note: If the error message is still shown, select another rule-set and apply the changes. Then switch back to previous rule-set.

Connect to the Plesk server via RDP.

Start a command prompt as an Administrator.

Create a Plesk database dump:

C:\> plesk db dump psa > C:\psa_dump.sql

Repair the Plesk database:

C:\> plesk repair db -y

Open the Plesk database in MySQL:

C:\> plesk db

Remove the orphaned entries:

MYSQL_WIN: DELETE i, ia FROM IisAppPools i LEFT JOIN IisAppPoolDomains ia ON i.id = ia.poolId LEFT JOIN domains d ON d.id = ia.domainId WHERE d.name IS NULL AND i.id != 1;

Log in to Plesk.

Go to Tools & Settings > Web Application Firewall (ModSecurity), and click OK to update/activate the rule-set.

Note: If the error message is still shown, select another rule-set and apply the changes. Then switch back to previous rule-set.