delete function gives database error

  • Resolved sailross

    (@sailross)


    9 years, 9 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/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author redeyedmonster

    (@redeyedmonster)

    9 years, 9 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.

    Thread Starter sailross

    (@sailross)

    9 years, 9 months ago

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

    Plugin Author redeyedmonster

    (@redeyedmonster)

    9 years, 9 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.

    Thread Starter sailross

    (@sailross)

    9 years, 9 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

    Plugin Author redeyedmonster

    (@redeyedmonster)

    9 years, 9 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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘delete function gives database error’ is closed to new replies.