Symptoms
Unable to create a backup of the WordPress database in Plesk, the following warning appears in Plesk:
PLESK_WARN: Warning: mysql “wordpress_db” @[email protected] to execute SQL: Table ‘wordpress_db.qwerty_wfVulnScanners’ doesn’t exist in engine. SQL query: SHOW FULL COLUMNS IN [email protected][email protected]
Cause
Inconsistency in tables of Wordfence Security plugin.
Resolution
Contact Wordfence Security plugin developers.
As a workaround, go to Domains > example.com > WordPress > select instance > Plugins and remove the Wordfence Security plugin:
If the issue persists, delete the remained tables:
- Log in to Plesk
- Go to Domains > example.com > Databases and click phpMyAdmin:
- In phpMyAdmin select the table from the warning message > click Drop > OK:
with