WordPress database error Table ‘wp_advaipbl_activity_log’ doesn’t

  • Resolved martje65

    (@martje65)


    4 months, 2 weeks ago

    If you go to wp-admin/admin.php?page=advaipbl_settings_page&tab=logs&sub-tab=audit_log and the Activity Logging is currently Inactive you will get an error in your logfiles.

    Backend log: WordPress database error Table ‘wp_advaipbl_activity_log’ doesn’t exist for query SELECT * FROM wp_advaipbl_activity_log ORDER BY timestamp DESC LIMIT 20 OFFSET 0 made by do_action(‘toplevel_page_advaipbl_settings_page’), WP_Hook->do_action, WP_Hook->apply_filters, ADVAIPBL_Main->settings_page_content, ADVAIPBL_Admin_Pages->settings_page_content, ADVAIPBL_Admin_Pages->display_audit_log_tab, ADVAIPBL_Audit_Logger->get_logs\n, referer: wp-admin/admin.php?page=advaipbl_settings_page&tab=logs&sub-tab=security_log
    Backend log: WordPress database error Table ‘wp_advaipbl_activity_log’ doesn’t exist for query SELECT COUNT(id) FROM wp_advaipbl_activity_log made by do_action(‘toplevel_page_advaipbl_settings_page’), WP_Hook->do_action, WP_Hook->apply_filters, ADVAIPBL_Main->settings_page_content, ADVAIPBL_Admin_Pages->settings_page_content, ADVAIPBL_Admin_Pages->display_audit_log_tab\n, referer: wp-admin/admin.php?page=advaipbl_settings_page&tab=logs&sub-tab=security_log|

    Advanced IP Blocker: 8.7.2
    PHP: 8.2.29
    WordPress: 6.9

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author IniLerm

    (@inilerm)

    4 months, 2 weeks ago

    Hi @martje65,

    Thank you so much for the detailed bug report and the stack trace! You are absolutely right; the plugin was attempting to query the logging table (wp_advaipbl_activity_log) on that specific admin tab even when the feature was inactive or the table hadn’t been created yet.

    I have just implemented a fix in our development branch to check for the table’s existence before running any queries, which will prevent these errors entirely. This patch will be included in the next release (v8.7.3), which I plan to push within the next 24-48 hours after final testing.

    Temporary Workaround: In the meantime, you can stop these errors from filling up your logs by temporarily enabling the “Activity Audit Log” option in the Settings tab. Enabling it triggers the table creation, which satisfies the query requirements even if you disable it afterward (since the table structure will remain in the database).

    Thanks again for helping us improve Advanced IP Blocker!

    Best regards,

    IniLerm

    Plugin Author IniLerm

    (@inilerm)

    4 months, 2 weeks ago

    Hi @martje65,

    Version 8.7.3 is now available and fixed.

    Thank you.

    Thread Starter martje65

    (@martje65)

    4 months, 2 weeks ago

    Thanks for the update @inilerm , it works

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.