Plesk

SEO Toolkit is stuck on domain’s overview page: Site Audit is in progress. Please wait until it has been completed.

Symptoms

Note: In some cases, such a task might cause inconsistency in Plesk database by adding extra value into dom_param table

Cause

Inconsistency in the database caused by the longtask removal.

SEO Toolkit stores information about running audits to the database and updates them only when the longtask have finished running, or failed.

Resolution

  1. Connect to the server via SSH/RDP

  2. Create a Plesk database backup

  3. Find the affected domain's ID:

    # plesk db "SELECT d.id, d.name FROM domains d WHERE d.name = 'example.com';"
    +----+-------------+
    | id | name |
    +----+-------------+
    | 13 | example.com |
    +----+-------------+

  4. Remove the ext-xovi-site_audit_state parameter related to this domain from the database:

    # plesk db "DELETE FROM dom_param WHERE param = 'ext-xovi-site_audit_state' AND dom_id = 13;"