{"id":5050811,"date":"2014-06-28T17:37:22","date_gmt":"2014-06-28T17:37:22","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/delete-function-gives-database-error\/"},"modified":"2016-08-21T22:47:52","modified_gmt":"2016-08-21T22:47:52","slug":"delete-function-gives-database-error","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/delete-function-gives-database-error\/","title":{"rendered":"delete function gives database error"},"content":{"rendered":"<p>I have a little database table  where the first field = index and auto_increment and 2 records (testing).<\/p>\n<p>In Edit any table when I&#8217;m listing the database with 2 records with Open&#8211;&gt;Find I get 2 boxes with beneath two options DELETE OR SAVE. The SAVE Functions operates well, but the DELETE function gives an error at line 1. (Unable to delete record)<br \/>\nDELETE from tarieven where index=2.<\/p>\n<p>phpMyAdmin &#8211; 2.11.11.3<br \/>\nMySQL client version: 5.1.73<br \/>\nEdit any table : 2.0.1<\/p>\n<p>What I&#8217;m doing wrong?<\/p>\n<p>https:\/\/wordpress.org\/plugins\/edit-any-table\/<\/p>\n","protected":false},"template":"","class_list":["post-5050811","topic","type-topic","status-closed","hentry","topic-tag-delete","topic-tag-record"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5050811","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\/5050811\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5050811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}