WordPress.org

Forums

Edit Any Table
[resolved] delete function gives database error (6 posts)

  1. sailross
    Member
    Posted 1 year ago #

    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/

  2. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. sailross
    Member
    Posted 1 year ago #

    I've have made a print screen form structure, but no possibilities to attach to this post.

  4. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. sailross
    Member
    Posted 1 year ago #

    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

  6. redeyedmonster
    Member
    Plugin Author

    Posted 1 year ago #

    OK - The reason for your issue is that you have named a column INDEX which is a reserved word - change the column name to myindex or something else and all will be ok.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Edit Any Table
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic