Issue WP-Toolkit Error

[Dork]

Server operating system version

AlmaLinux 8.10

Plesk version and microupdate number

Plesk Obsidian 18.0.71 #1

How to repair the DB Error?
[extension/wp-toolkit] An error occurred during update of vulnerability database: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed

 

[Sebahat.hadzhi]

Hello, @Dork. The issue is caused due to a bug identified with ID EXTWPTOOLK-10397, which will be fixed in one of the upcoming releases. Until the fix is introduced, please apply the following workaround:

1. Connect to the server via SSH
2. Backup the psa database
   

   plesk db dump psa > /root/psa_dump.sql

3. Remove the necessary line from the database by executing the following command:
   

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

Afterward, the vulnerability task should finish successfully.