{"id":11692963,"date":"2019-07-02T13:42:16","date_gmt":"2019-07-02T13:42:16","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-syntax-error-18\/"},"modified":"2019-07-02T13:42:16","modified_gmt":"2019-07-02T13:42:16","slug":"sql-syntax-error-18","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-syntax-error-18\/","title":{"rendered":"SQL syntax error"},"content":{"rendered":"<p>This may be a multi-site only issue or it may possibly affect all versions.  I haven&#8217;t tested it on a single site version of WordPress.<\/p>\n<p>I just ran all my updates on WordPress and the plugin so everything is up to date as of this writing.<br \/>\nWordpress 5.2.2<br \/>\nHFCM 1.1.3<\/p>\n<p>Here is the database error I am getting:<br \/>\n&#8220;You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#8216;IF&#8217; at line 1\t&#8221;<br \/>\nError Code 1064<\/p>\n<p>The error is coming from the SQL statement in the main plugin file in the hfcm_options_install() function.<\/p>\n<p>If I remove that sql statement (the table is already there&#8230;) the error goes away.<\/p>\n","protected":false},"template":"","class_list":["post-11692963","topic","type-topic","status-publish","hentry","topic-tag-hfcm","topic-tag-sql-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11692963","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":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/11692963\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=11692963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}