Title: delete function gives database error
Last modified: August 21, 2016

---

# delete function gives database error

 *  Resolved [sailross](https://wordpress.org/support/users/sailross/)
 * (@sailross)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/)
 * I have a little database table where the first field = index and auto_increment
   and 2 records (testing).
 * In Edit any table when I’m listing the database with 2 records with Open–>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)
   
   DELETE from tarieven where index=2.
 * phpMyAdmin – 2.11.11.3
    MySQL client version: 5.1.73 Edit any table : 2.0.1
 * What I’m doing wrong?
 * [https://wordpress.org/plugins/edit-any-table/](https://wordpress.org/plugins/edit-any-table/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051046)
 * It is difficult to say what the problem is. I have no issues on my test database
   which is of similar design. If you could post exactly how you set up the database(
   i.e. the schema) then I will try and replicate.
 *  Thread Starter [sailross](https://wordpress.org/support/users/sailross/)
 * (@sailross)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051048)
 * I’ve have made a print screen form structure, but no possibilities to attach 
   to this post.
 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051107)
 * Unfortunately without more information it is unlikely that I can solve your problem.
   If you could copy out the field structure and the exact properties, or put your
   screenshot up on the web and provide a link.
 *  Thread Starter [sailross](https://wordpress.org/support/users/sailross/)
 * (@sailross)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051123)
 * Hereby the structure:
    Field Type Extra index smalint auto_increment object tinytext
   amount decimal(10,2) unit tinytext
 * Index
    Key name : Primary Type : Primary Cardinality : 2 Field : index Create
   index on column : 1
 * If you want more information, please email
 *  Plugin Author [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * (@redeyedmonster)
 * [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051124)
 * OK – The reason for your issue is that you have named a column INDEX which is
   a [reserved word](http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html)–
   change the column name to myindex or something else and all will be ok.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘delete function gives database error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/edit-any-table.svg)
 * [Edit Any Table](https://wordpress.org/plugins/edit-any-table/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/edit-any-table/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/edit-any-table/)
 * [Active Topics](https://wordpress.org/support/plugin/edit-any-table/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/edit-any-table/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/edit-any-table/reviews/)

## Tags

 * [delete](https://wordpress.org/support/topic-tag/delete/)
 * [record](https://wordpress.org/support/topic-tag/record/)

 * 5 replies
 * 2 participants
 * Last reply from: [redeyedmonster](https://wordpress.org/support/users/redeyedmonster/)
 * Last activity: [11 years, 9 months ago](https://wordpress.org/support/topic/delete-function-gives-database-error/#post-5051124)
 * Status: resolved