WordPress database error Table wpvw_slim_seo_404

  • Resolved giaco91dena

    (@giaco91dena)


    2 years, 4 months ago

    Hi,
    I’ve got this error that maybe is related to your plugin:

    [01-Jan-2023 09:52:44 UTC] WordPress database error Table ‘xqolhxyr_wp907.wpvw_slim_seo_404’ doesn’t exist for query DELETE FROM wpvw_slim_seo_404

    Do you know about it, what could be caused by, and how to fix it?

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support bb

    (@doanducanh)

    2 years, 4 months ago

    Hi @giaco91dena

    Have you been ever tried to change something directly in Database or delete slim_seo_404 table before?

    To fix this issue, please follow these steps:

    1. Go to Slim SEO Settings page
    2. Select Redirection tab
    3. Click Settings
    4. Turn OFF Enable 404 logs setting
    5. Turn ON Delete 404 logs table setting
    6. Save changes
    7. Click Settings again
    8. Turn ON Enable 404 logs setting
    9. Save changes

    We have made a sample video https://vimeo.com/786476614 so you can follow the steps easier

    • This reply was modified 2 years, 4 months ago by bb.
    Chauncey McAskill

    (@mcaskill)

    2 years, 3 months ago

    I encountered the same database error on a fresh installation of WordPress.

    The issue stems from the scheduled event:

    do_action_ref_array('delete_404_logs'),
WP_Hook->do_action, WP_Hook->apply_filters,
SlimSEO\Redirection\Loader->run_schedule,
SlimSEO\Redirection\Database\Log404->delete_older_logs

    Which does not check if the table exists.

    The table is only ever created here when visiting the Settings page:

    apply_filters('admin_print_styles-settings_page_slim-seo'),
WP_Hook->apply_filters,
SlimSEO\Redirection\Settings->enqueue

    To resolve this error, the plugin would either need to:

    • Create the table sooner such as when the Redirection module is enabled (which is enabled by default).
    • Ensure the table exists before deleting older logs (such as with "SHOW TABLES LIKE {$wpdb->slim_seo_404}".
    • Ensure “Enable 404 logs” is turned on.
    Thread Starter giaco91dena

    (@giaco91dena)

    2 years, 3 months ago

    Thank you so much!

    Plugin Support bb

    (@doanducanh)

    2 years, 3 months ago

    Thank @mcaskill for your suggestion, we have fixed it!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress database error Table wpvw_slim_seo_404’ is closed to new replies.