How can I improve Broken Link Checker?

Fix (or explain how to) MySQL messages in error_log

[20-Jan-2011 05:24:43] WordPress database error MySQL server has gone away for query UPDATE wp_blc_links SET url = '{url path to static page}', first_failure = '0000-00-00 00:00:00', last_check = '2011-01-20 05:24:43', last_success = '2011-01-20 05:24:43', last_check_attempt = '2011-01-20 05:24:43', check_count = 0, final_url = '{same path}', redirect_count = 0, log = '=== HTTP code : 200 ===\n\nHTTP/1.1 200 OK\r\nDate: Thu, 20 Jan 2011 05:24:43 GMT\r\nServer: Apache mod_fcgid/2.3.5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635\r\nX-Powered-By: PHP/5.2.15\r\nCache-Control: no-cache, must-revalidate, max-age=0\r\nPragma: no-cache\r\nExpires: Wed, 11 Jan 1984 05:00:00 GMT\r\nLast-Modified: Thu, 20 Jan 2011 03:36:17 GMT\r\nVary: Accept-Encoding\r\nContent-Type: text/html;charset=UTF-8\r\n\r\n\nLink is valid.', http_code = 200, request_duration = 0.090698, timeout = 0, result_hash = '200|0|0|d9ec510e2c6d37a2ba2df7081db96d95', broken = 0, false_positive = 0, may_recheck = 1, being_checked = 0, status_text = '', status_code = '' WHERE link_id=14 made by do_action_ref_array, call_user_func_array, wsBrokenLinkChecker->cron_check_links, wsBrokenLinkChecker->work, blcLink->check, blcLink->save

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Quibbler shared this idea  ·   ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Quibbler commented  · 

        More follow up:
        [20-Jan-2011 05:24:55] WordPress database error MySQL server has gone away for query SELECT RELEASE_LOCK('blc_lock') made by do_action_ref_array, call_user_func_array, wsBrokenLinkChecker->cron_check_links, wsBrokenLinkChecker->work, wsBrokenLinkChecker->release_lock, WPMutex->release

      • Quibbler commented  · 

        Follow up in case it helps
        [20-Jan-2011 05:24:55] WordPress database error MySQL server has gone away for query SELECT links.*
        FROM wp_blc_links AS links
        WHERE
        (
        ( last_check_attempt < '2011-01-19 05:24:55' )
        OR
        (
        (broken = 1 OR being_checked = 1)
        AND may_recheck = 1
        AND check_count < 3
        AND last_check_attempt < '2011-01-20 04:54:55'
        )
        )
        AND EXISTS (
        SELECT 1 FROM wp_blc_instances AS instances
        WHERE
        instances.link_id = links.link_id
        AND ( instances.container_type IN ('dummy', 'page', 'post', 'comment', 'blogroll') )
        AND ( instances.parser_type IN ('link', 'image', 'plaintext-url', 'metadata', 'url_field') )
        )

        ORDER BY last_check_attempt ASC
        LIMIT 30 made by do_action_ref_array, call_user_func_array, wsBrokenLinkChecker->cron_check_links, wsBrokenLinkChecker->work, wsBrokenLinkChecker->get_links_to_check

      Feedback and Knowledge Base