New Release broken upgrade

  • Resolved justin-bigscoots

    (@justin-bigscoots)


    3 days ago

    The new release causes an infinite loop firing thousands of ALTER database queries

    query() wp-content/plugins/broken-link-checker/legacy/includes/admin/db-upgrade.php:408
    delta() wp-content/plugins/broken-link-checker/legacy/includes/admin/db-upgrade.php:64
    make_schema_current() wp-content/plugins/broken-link-checker/legacy/includes/admin/db-upgrade.php:26
    upgrade_database() wp-content/plugins/broken-link-checker/legacy/init.php:243


    WordPress database error Duplicate entry '' for key 'url_hash' for query ALTER TABLE     21514_blc_links ADD UNIQUE KEY url_hash (url_hash) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta



    | 1437069 | REDAC | localhost | REDAC| Query   | 16   | Waiting for table metadata lock | ALTER TABLE 21514_blc_links MODIFY COLUMN url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL | 0.000    |
    | 1437070 | REDAC| localhost | REDAC| Query   | 15   | Waiting for table metadata lock | ALTER TABLE 21514_blc_links MODIFY COLUMN url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL | 0.000    |
    | 1437071 | REDAC| localhost | REDAC| Query   | 14   | Waiting for table metadata lock | ALTER TABLE 21514_blc_links MODIFY COLUMN url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL | 0.000    |
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Saurabh – WPMU DEV Support

    (@wpmudev-support7)

    2 days, 11 hours ago

    Hello @justin-bigscoots,

    I am sorry that you had to face the issue. The issue that you are noticing is related to an already reported bug on which the BLC devs are already working. However, I am afraid at the moment, I will not be able to confirm an exact ETA as to when the fix will be released.

    In the meantime, you can revert to the previous version of the BLC plugin, or in the current version you can navigate to “Local >> Settings >> Advanced” and click on “Recheck all pages” which is a temporary workaround.

    Once the fix is released, it is also going to be described in the changelog found at https://wordpress.org/plugins/broken-link-checker/#developers

    Kind Regards,
    Saurabh

    Plugin Support Williams – WPMU DEV Support

    (@wpmudevsupport3)

    2 days, 4 hours ago

    Hi @justin-bigscoots ,

    We got an update from the team.

    A new version has been released for the Broken Link Checker; the version is 2.4.10.

    Could you please update/install this version and let us know if you face further issues?

    I hope to hear back from you soon.
    Best Regards,
    Williams Valerio

    Thread Starter justin-bigscoots

    (@justin-bigscoots)

    2 days, 1 hour ago

    Seems that resolves it thank you.

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

You must be logged in to reply to this topic.