{"id":5953917,"date":"2015-03-29T16:12:27","date_gmt":"2015-03-29T16:12:27","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/insert-form-returns-error\/"},"modified":"2016-08-22T19:09:14","modified_gmt":"2016-08-22T19:09:14","slug":"insert-form-returns-error","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/insert-form-returns-error\/","title":{"rendered":"Insert Form Returns Error"},"content":{"rendered":"<p>So the insert form works well, the record does get inserted into the sql but returns an error<\/p>\n<p>Couldn&#8217;t perform query (1400): SELECT <code><\/code> FROM Record123 WHERE <code>Number<\/code>=&#8217;5&#8242; AND <code>NameUser<\/code>=&#8217;Richard Test&#8217; AND <code>Location<\/code>=&#8217;Alabama&#8217; ORDER BY <code><\/code> DESC LIMIT 1 &#8211; Unknown column &#8221; in &#8216;field list&#8217;.<\/p>\n<p>Any ideas regarding what is going on<\/p>\n<p>https:\/\/wordpress.org\/plugins\/abase\/<\/p>\n","protected":false},"template":"","class_list":["post-5953917","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5953917","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\/5953917\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5953917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}