WordPress Toolkit maintenance fails with error: Vulnerability changes does not contain

Symptoms

• One of the following error messages is logged in /var/log/plesk/panel.log:

  ERR [extension/wp-toolkit] An error occurred during update of vulnerability database: Vulnerability changes does not contain

  OR

  ERR [extension/wp-toolkit] An error occurred during update of vulnerability database: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint fai led: Vulnerabilities.vulnerabilityId, query was: INSERT INTO "Vulnerabilities" ("vulnerabilityId", "productType", "productSlug", "productNamePremium", "title", "description", "directUrl", "affectedVersions" , "cvssScore", "disclosedAt", "cve", "exploited", "fingerprint", "mitigations", "riskRank") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

• Running the maintenance WP Toolkit maintenance task manually from Tools & Settings > Scheduled Tasks triggers the error.

Cause

Extension bug with ID EXTWPTOOLK-10397 has been confirmed.

Note: Consider subscribing to this article in order to get notified when the fix is released or check for the bug ID in the Plesk Changelog.

Resolution

Until the new version is released, the following workaround is recommended:

1. Connect to the server via SSH

2. Make a backup of the psa database:

   # plesk db dump psa > psa_dump.sql

3. Remove the necessary line from the database:

   # plesk db "DELETE FROM ModuleSettings WHERE name = 'vulnerabilityDatabaseEncodedIndicatorPhrase'"