Can't change table ID

  • Resolved chaipope

    (@chaipope)


    11 years, 1 month ago

    Hi Tobias,

    Initially I created 12 different tables for testing. Then later I removed them all and created new tables. I expect the first new table ID to start from ‘1’, but it turns out that the count continues from ’12’ and the first new table starts from ’13’.

    Then I tried changing the table ID from ’13’ to ‘1’, and I was prompted with a message

    Do you really want to change the table ID? bla bla bla…

    I clicked on OK and the table ID changes to ‘1’, but when I clicked on Save Changes and it shows me this message:

    Saving successful: The Table was saved successfully, but the table ID could not be changed!

    And my table ID revert to ’13’. How come?

    But when I tried changing it from ’13’ to ’01’, the table ID was saved successfully. Can you please do a test and see what actually goes wrong, or you deliberately design it this way for some purposes? Please enlighten. Thanks.

    https://wordpress.org/plugins/tablepress/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks for your post, and sorry for the trouble.

    This could indicate that the table with the ID 1 still exists and was not yet deleted? In that case, one can’t change the ID to that, because there can only be one table with that ID, obviously.

    I think, the best way here might be to reset TablePress, so that you can avoid all this trouble. For that, I suggest to export the tables that you want to e.g. a CSV file.
    Then, on the “Plugin Options” screen of TablePress, use the “Uninstall” button. That will delete all data (and internal settings) of TablePress. After that, activate the plugin again and re-import the CSV files. They will then have IDs starting from 1 again, and you should not have problems changing them.

    Regards,
    Tobias

    Thread Starter chaipope

    (@chaipope)

    11 years, 1 month ago

    Hi Tobias,

    That works. Thank you very much.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    great! Thanks a lot for the confirmation!

    Best wishes,
    Tobias

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    11 years, 1 month ago

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

The topic ‘Can't change table ID’ is closed to new replies.