Deleting Rows

  • Resolved c7movieman

    (@c7movieman)


    8 years, 7 months ago

    Hello,
    I’ve been using the plugin now for a while and it is great. Recently, when I add a new row, the row is not automatically given an ID number and the delete button does not appear. So I am unable to delete the new rows. (Older rows do have the delete function on the grid)

    I read through the troubleshooting information about no edit and editcap, but am still not able to remove the new rows. (I can also create new rows with id’s directly in the SQL database, but not delete).

    Do you know what could be causing this issue? I need these new rows without id’s deleted, but the option isn’t there. Any help is appreciated. Thanks!

    https://www.ads-software.com/plugins/wp-db-table-editor/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter c7movieman

    (@c7movieman)

    Just as an update, i rebuilt the database in SQL, I was able to remove the row I needed. The issue still stands that when I add a new row in WordPress, a unique ID isn’t assigned and then am unable to delete the row.

    Although I’ve found a workaround, I’m curious if there is a simple fix from something I did wrong.

    Thank you though!

    Plugin Author bobbysmith007

    (@bobbysmith007)

    It sounds like maybe your table does not have autoincrement set for the ID? the plugin mostly expects there to be an id (big)int AUTO_INCREMENT PRIMARY KEY column. You can write code to make it work without it, but you will need custom save functions if you do not have that column.

    If this is not the case can you paste the schema for the table that is malfunctioning here please?

    Plugin Author bobbysmith007

    (@bobbysmith007)

    I closed this but feel free to seek further help if you need it

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Deleting Rows’ is closed to new replies.