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

Kuzma Ivanov

Updated January 13, 2026 19:09

Plesk for Windows Plesk for Linux kb: technical ABT: Group B

Applicable to:

Plesk for Linux
Plesk for Windows

Symptoms

When activating or updating ModSecurity rule-set in Plesk at Tools & Settings > Web Application Firewall (ModSecurity), the operation fails with:

PLESK_ERROR: Unable to find row with id X in domains table.

Cause

Inconsistency in the Plesk database: orphaned records exist in the psa.IisAppPools table.

Resolution

For Plesk on Linux

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.

For Plesk on Windows Server

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.