{"id":14483501,"date":"2021-05-26T05:16:22","date_gmt":"2021-05-26T05:16:22","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-error-47\/"},"modified":"2021-05-26T05:17:20","modified_gmt":"2021-05-26T05:17:20","slug":"sql-error-47","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-error-47\/","title":{"rendered":"SQL error"},"content":{"rendered":"<p>Hello,<\/p>\n<p>Company recently bought this plugin, and all is fine, but one thing. This error popped up:<\/p>\n<p><code>[STDERR] WordPress errore sul database 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;)  LEFT JOIN wpnq_cjtoolbox_plus_block_pintype pt ON blocks.<\/code>id<code>= pt.<\/code>bloc&#8230;&#8217; at line 1 per la query SELECT blocks.id,blocks.owner,blocks.name,blocks.pinPoint,blocks.location,blocks.links,blocks.expressions,0 as blocksGroup FROM wpnq_cjtoolbox_blocks blocks LEFT JOIN wpnq_cjtoolbox_block_pins pins0 ON blocks.id = pins0.blockId AND pins0.pin=&#8217;categories&#8217; AND pins0.value IN(  )  LEFT JOIN wpnq_cjtoolbox_plus_block_pintype pt ON blocks.<code>id<\/code>= pt.<code>blockId<\/code>WHERE ( ( ( backupId IS NULL ) AND ( state = &#8220;active&#8221; ) ) AND ( ( pt.pinName = &#8216;category&#8217; AND pt.invert = 1  ) ) AND ( (  ( pins0.pin IS NULL ) AND ( pins0.value IS NULL ) ) ) ); fatta da require(&#8216;wp-blog-header.php&#8217;), require_once(&#8216;wp-includes\/template-loader.php&#8217;), do_action(&#8216;template_redirect&#8217;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, CJTBlocksCouplingController-&gt;initCoupling, CJTBlocksCouplingController-&gt;getBlocks, CJTCouplingModel-&gt;getPinsBlocks, apply_filters(&#8216;cjt-blocks-coupling-model-blocks-queue&#8217;), WP_Hook-&gt;apply_filters, CJTPlusHooksCJTBlockAssignmentNegative-&gt;_blocksQueue`<\/p>\n<p>Any help would be appreciated.<\/p>\n","protected":false},"template":"","class_list":["post-14483501","topic","type-topic","status-publish","hentry","topic-tag-mysql","topic-tag-sql","topic-tag-sql-syntax"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14483501","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":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14483501\/revisions"}],"predecessor-version":[{"id":14483502,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/14483501\/revisions\/14483502"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=14483501"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}