WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. sailross
    Member
    Posted 2 months 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 2 months 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 2 months ago #

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

  4. redeyedmonster
    Member
    Plugin Author

    Posted 2 months 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 2 months 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 2 months 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.

Reply

You must log in to post.

About this Plugin

About this Topic