Support » Plugin: Broken Link Checker | Finder » Database syntax issues

  • Resolved Richard Bairwell

    (@rbairwell)


    I’ve noticed on my error log on my WordPress 6.0 install with WooCommerce 6.5.1, PHP 7.4.29 and MariaDB 5.5.5-10.6.8 as the database – I’m getting a lot of SQL syntax checks from this version 2.1 of the miniOrange Broken Link Checker/Finder:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's Cloth size chart','404','0s'), ('d92860bc9a2845a22d68e0e7e6038274','https:/...' at line 1 for query INSERT INTO XXXX_moblc_link_details_table (link_hash,link,page_title,status_code,loading_time) VALUES ('81beabf2527fbd2ad963ce1a0357c91d','https://example.com/wp-content/plugins/woo-advanced-product-size-chart/admin/images/default-chart/cloth_size_chart.png','Women's Cloth size chart','404','0s'), ('d92860bc9a2845a22d68e0e7e6038274','https://example.com/wp-content/plugins/woo-advanced-product-size-chart/admin/images/default-chart/mens-shoes-size-chart.png','Men's Shoes Size Chart','404','1s'), ('7e409ab4a7f0599289e10a694d02fe17','https://example.com/wp-content/plugins/woo-advanced-product-size-chart/admin/images/default-chart/women-shoes-size-image.jpg','Women's Shoes Size Chart','404','0s') ON DUPLICATE KEY UPDATEstatus_code= VALUES(status_code); made by do_action_ref_array('moblc_scan_cron_hook'), WP_Hook->do_action, WP_Hook->apply_filters, MOBLC_Cron->moblc_scan_cron_hook_exec, MOBLC_Cron->check_links_from_pages

    Any ideas of the fix?

    [gist with the un-mangled-by-support-forum text at https://gist.github.com/rbairwell/8742ea0f515acfbc2556ef985d0ba222 ]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor jayeshprajapat

    (@jayeshprajapat)

    Hi @rbairwell,

    Thank you for pointing out the issue.

    We have resolved this issue in our latest version of broken link finder/checker – 2.3

    We have also introduced the following new features in the broken link finder plugin which will help you to maintain and improve the site’s SEO.

    1. Improved Cloud scan for dead links, broken Images, broken videos, etc.
    2. Edit broken links/posts/pages and remove/fix broken links.
    3. Filter report according to response type of broken links.

    Please update your plugin to the latest version and let us know if you are facing that issue anymore.

    Thank you,
    miniOrange team

    Thread Starter Richard Bairwell

    (@rbairwell)

    I think that’s working – however, the following problems have occurred:

    * Unable to drop SQL Column

    [20-Jun-2022 20:51:42 UTC] WordPress database error Can't DROP COLUMNlink_hash; check that it exists for query ALTER TABLE xxxxx_moblc_link_details_table DROP COLUMNlink_hash, DROP COLUMNloading_timemade by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MOBLC->moblc_update_db_check, MOBLC_DATABASE->moblc_migration

    * Incorrect bad link count reported
    Although the link checker is still currently running (and has been for nearly an hour), it’s still not produced any results. The link checker Dashboard says “Your website is getting scanned for broken links. Found 14 broken links.”, but when I click on that link and am taken to the Links page, it is an empty table with “Showing 0 to 0 of 0 entries”.

    * Scanning of unwanted sections
    I turned on the debug log, and looking at the entries I see it’s been through the pages and the WooCommerce products, but it’s also working it’s way through:
    * The default charts provided by the plugin “product-size-chart-for-woo” (even though those do not appear anywhere for me)
    * All the WP Json links (/wp/v2…) – including the block pattern library at /wp/v2/block-patterns/patterns : so far it’s found 55 of those pages (which outnumber the number of pages and products on my site!)

    The WP block patterns have multiple references to external files (some 25+) so they’ll take ages to validate 🙁 Lots of checks for something I don’t use and don’t have much control over.

    * Incorrect wording on “My Account” page
    Oh, and I notice on the “My Account” page it says “Just complete the short registration below to configure miniOrange 2-Factor plugin.”

    * Annoying banner
    The “Cron is disabled. Please enable the cloud scan to scan your site.” banner is constantly at the top of the site – even though I’ve got the server crontab set to run every minute (so it’s probably getting refreshed more often then if I did have cron enabled).

    I’ll try and check back tomorrow if the scan has finished to let you know if there are any other issues.

    Thread Starter Richard Bairwell

    (@rbairwell)

    Here’s the follow up-

    After running, it seems to have completed around 22:23 with 0 dead links found… Checking the xxxxx_moblc_link_details_table table shows 17 links listed (2 external, 1 external to WordPress on the “/wp/v2/block-patterns/patterns” page, 4 on “/ithemes-security/rpc/” pages and the remainder being demo entries of the “woo-advanced-product-size-chart” plugin (had the wrong plugin name earlier: I removed that plugin some time ago).

    For the record, IThemes security creates posts with post_types of “itsec-dashboard” and “itsec-dash-card” and woo-advanced-product-size-chart uses “size-chart”

    The xxxxx_moblc_scan_status_table table is completely empty.

    However, I do see 10x 404 errors in my server log from WordPress where it tried checking the woo-advanced-product-size-chart links so something was running.

    I’m going back to using WPMU’s Broken Link Checker as the miniOrange one just seems too broken in its current state to be useful for me.

    Plugin Contributor jayeshprajapat

    (@jayeshprajapat)

    Hi @rbairwell,

    We appreciate your suggestions.

    We have fixed the following issues on our end but we will push these changes along with all other fixes.
    *Unable to drop SQL Column
    *Incorrect wording on the “My Account” page
    *Annoying banner

    Regarding the below issues.
    “Incorrect bad link count reported”
    The count shown on the scanning page is the count of all broken links in the report. You can select the type of broken links to be shown.
    The number of broken links shown in the report depends on the filter that you are using. i.e. 4xx,5xx, and others. 4xx and 5xx are checked by default.

    “Scanning of unwanted sections”
    We are scanning all published custom posts and pages. To debug more on this, can you please reach out to us through our website so that we can look into the exact issue and resolve it?

    We also provide cloud scans in our plugin. In case cron is not working on the site, you can enable the cloud option from settings.

    Please reach out to us through our website or raise a query from the plugin.

    Thank you,
    miniOrange team

    Plugin Contributor jayeshprajapat

    (@jayeshprajapat)

    Hi @rbairwell,

    We didn’t hear back from you.

    We fixed all the issues in the Broken link finder 2.3

    Please let us know if you find any other issues.

    We are closing this ticket as of now.

    In the future, if you face any issues with the plugin, feel free to reach out to us.

    You can also raise the query from the plugin or reach out to us through our website.

    Thank you,
    miniOrange team

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