{"id":15728023,"date":"2022-06-11T01:36:54","date_gmt":"2022-06-11T01:36:54","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-syntax-issues\/"},"modified":"2022-06-11T01:41:26","modified_gmt":"2022-06-11T01:41:26","slug":"database-syntax-issues","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-syntax-issues\/","title":{"rendered":"Database syntax issues"},"content":{"rendered":"<p>I&#8217;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 &#8211; I&#8217;m getting a lot of SQL syntax checks from this version 2.1 of the miniOrange Broken Link Checker\/Finder:<\/p>\n<blockquote><p><code>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 &#039;s Cloth size chart&#039;,&#039;404&#039;,&#039;0s&#039;), (&#039;d92860bc9a2845a22d68e0e7e6038274&#039;,&#039;https:\/...&#039; at line 1 for query INSERT INTO XXXX_moblc_link_details_table (<\/code>link_hash<code>,<\/code>link<code>,<\/code>page_title<code>,<\/code>status_code<code>,<\/code>loading_time<code>) VALUES (&#039;81beabf2527fbd2ad963ce1a0357c91d&#039;,&#039;https:\/\/example.com\/wp-content\/plugins\/woo-advanced-product-size-chart\/admin\/images\/default-chart\/cloth_size_chart.png&#039;,&#039;Women&#039;s Cloth size chart&#039;,&#039;404&#039;,&#039;0s&#039;), (&#039;d92860bc9a2845a22d68e0e7e6038274&#039;,&#039;https:\/\/example.com\/wp-content\/plugins\/woo-advanced-product-size-chart\/admin\/images\/default-chart\/mens-shoes-size-chart.png&#039;,&#039;Men&#039;s Shoes Size Chart&#039;,&#039;404&#039;,&#039;1s&#039;), (&#039;7e409ab4a7f0599289e10a694d02fe17&#039;,&#039;https:\/\/example.com\/wp-content\/plugins\/woo-advanced-product-size-chart\/admin\/images\/default-chart\/women-shoes-size-image.jpg&#039;,&#039;Women&#039;s Shoes Size Chart&#039;,&#039;404&#039;,&#039;0s&#039;) ON DUPLICATE KEY UPDATE<\/code>status_code<code>= VALUES(status_code); made by do_action_ref_array(&#039;moblc_scan_cron_hook&#039;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, MOBLC_Cron-&gt;moblc_scan_cron_hook_exec, MOBLC_Cron-&gt;check_links_from_pages<\/code><\/p><\/blockquote>\n<p>Any ideas of the fix?<\/p>\n<p>[gist with the un-mangled-by-support-forum text at https:\/\/gist.github.com\/rbairwell\/8742ea0f515acfbc2556ef985d0ba222 ]<\/p>\n","protected":false},"template":"","class_list":["post-15728023","topic","type-topic","status-publish","hentry","topic-tag-broken-images","topic-tag-broken-links","topic-tag-dead-links"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15728023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":3,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15728023\/revisions"}],"predecessor-version":[{"id":15728026,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/15728023\/revisions\/15728026"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=15728023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}