WordPress Database Error

  • Resolved yateendra88

    (@yateendra88)


    3 years, 6 months ago

    Hi,
    I am getting below errors very frequently which causes error file to grow at faster rate. Could you please help with this ?

    [10-May-2021 17:27:19 UTC] WordPress database error Unknown column ‘broken_link_scanned’ in ‘where clause’ for query SELECTlink_id,post_id,post_type,clean_url,raw_url,anchorFROM wp_wpil_report_links WHEREbroken_link_scanned= 0 ANDlocation` = ‘content’ LIMIT 10 made by do_action_ref_array(‘wpil_broken_link_check_cron’), WP_Hook->do_action, WP_Hook->apply_filters, Wpil_Error::performCronErrorChecks, Wpil_Error::cronLinkScan, Wpil_Error::getReportLinksToCheck
    [10-May-2021 17:27:22 UTC] WordPress database error Unknown column ‘broken_link_scanned’ in ‘where clause’ for query SELECT link_id, post_id, post_type, clean_url, raw_url, anchor FROM wp_wpil_report_links WHERE broken_link_scanned = 0 AND location = ‘content’ LIMIT 10 made by do_action_ref_array(‘wpil_broken_link_check_cron’), WP_Hook->do_action, WP_Hook->apply_filters, Wpil_Error::performCronErrorChecks, Wpil_Error::cronLinkScan, Wpil_Error::getReportLinksToCheck`

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

  • Hi @yateendra88,

    Thank you for contacting us.

    Could you please confirm the PHP version you are currently running and the plugin version? Also, please attempt to reinstall the plugin and clear logs to check if the error keeps showing.

    Best,
    Jonathan S

    Thread Starter yateendra88

    (@yateendra88)

    PHP Version: 7.2.34
    Wordpress version: 5.7.1
    I have updated all the plugins, cleared all caches, deactivated and reactivated all the plugins.

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @yateendra88,

    Are you using the “Link Whisper Free” plugin or its premium version? The table name in the above error points to the mentioned plugin and it isn’t related to Broken Link Checker.

    I could notice the Link Whisper plugin has “broken_link_scanned” options too. Could we know which exact variable or the query in the above-shared log you think points to the Broken Link checker plugin?

    Kind Regards,
    Nithin

    Thread Starter yateendra88

    (@yateendra88)

    Hi Nithin,

    Yes, I am using Premium version of Link Whisper Plugin. I have scanned for Broken Link but did not found one. Count is 0. Anyway I have updated my plugin and WordPress to the latest version. Post that restarted all my plugins and cleared cache. This resolved my issue. Since then I don’t see any new error in log file. So I assume everything is fine now.

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @yateendra88

    I hope you are doing well.

    Thank you for the update, sometimes it is a temporary issue caused by any cache like Object caching.

    I am marking this as resolved, feel free to ping us any time you need.

    Best Regards
    Patrick Freitas

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress Database Error’ is closed to new replies.