Deleted what I that was an orphaned table. now seeing errors in log

  • Resolved mesmer7

    (@mesmer7)


    1 year, 5 months ago

    Yesterday I ran Plugin Garbage Collector. It told me that wp_wfWafFailures was an orphaned table. So I deleted it. Now I’m seeing the following errors in my log

    [05-Jun-2023 13:30:34 UTC] WordPress database error Table 'mesmer17_wp1.wp_wfWafFailures' doesn't exist for query SELECT
    id,
    failures.rule_id,
    throwable AS latest_throwable,
    UNIX_TIMESTAMP(latest_occurrence) AS latest_occurrence,
    occurrences
    FROM
    wp_wfWafFailures failures
    JOIN (
    SELECT
    rule_id,
    MAX(id) AS max_id,
    MAX(timestamp) AS latest_occurrence,
    COUNT(*) AS occurrences
    FROM
    wp_wfWafFailures
    GROUP BY
    rule_id
    ) aggregate ON failures.id = aggregate.max_id made by do_action_ref_array('wordfence_processAttackData'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::processAttackData, wordfence::loadWafFailures

    and

    [05-Jun-2023 15:23:25 UTC] WordPress database error Table 'mesmer17_wp1.wp_wfWafFailures' doesn't exist for query DELETE FROM wp_wfWafFailures WHERE timestamp < DATE_SUB(NOW(), INTERVAL 1 DAY) made by do_action_ref_array('wordfence_daily_cron'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::dailyCron, wordfence::purgeWafFailures

    Can Wordfence recreate the table or do I have to do it manually? If I have to do it, how?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @mesmer7, thanks for your question.

    Deactivating the plugin in WordPress > Plugins > Installed Plugins, even with?Keep all Wordfence tables and data selected from the pop-up, and activating it again should recreate the table.

    I hope that helps you out!
    Peter.

    Thread Starter mesmer7

    (@mesmer7)

    Yes, that appears to have worked. Thanks.

    Plugin Support wfpeter

    (@wfpeter)

    No worries, glad that helped. If you have further Wordfence questions in future by all means start up a new topic any time and we’ll be happy to help out!

    Peter.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Deleted what I that was an orphaned table. now seeing errors in log’ is closed to new replies.