Reset Table ID Numbers

  • Resolved oxign

    (@oxign)


    10 years, 3 months ago

    Hi Tobias,

    I have a WP multisite setup with many sites that use the exact same tables. I need to ensure all these tables have the same ID. This is because I use a single child style sheet for all sites, and it includes the tables ID’s.

    So I found that after importing the wrong tables into one of these sites, deleting them, and then re-importing the correct tables, the ID for the tables had changed. I also could not change the ID to the ID I wanted. A message said “Saving successful: The table was saved successfully, but the table ID could not be changed!”

    I’m assuming the ID I want to use has been stored somewhere in the SQL and thus I can’t use it.

    Is there a way to get around this?

    Cheers. Steve

    https://www.ads-software.com/plugins/tablepress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi Steve,

    thanks for your post, and sorry for the trouble.
    The table ID can only be changed if there’s no other table with that ID at the same time. I assume that that was not the case when you got that error message.

    Regardless, resetting the last inserted ID (which dictates what the next used ID will be) can indeed be reset. For details on that, please see this post: https://www.ads-software.com/support/topic/table-number?replies=10#post-3964264

    Regards,
    Tobias

    Thread Starter oxign

    (@oxign)

    No need to be sorry, Tobias, you have a great plugin!

    I missed that post so thank you. I actually discovered that the Last_ID is also editable in the Multisite/Sites/Name of site/Settings and therefore I didn’t use phpmyadmin to make the edit.

    Even though I had deleted all the tables I was left with this

    {“last_id”:74,”table_post”:{“1″:7209,”2″:7280,”3″:7281,”4″:7282,”5”:7283,etc.}}

    which I changed to

    {“last_id”:0,”table_post”:{}}

    After re-importing my tables everything has now been reset and my tables start from ID1

    Thanks so much for your help.

    Cheers. Steve

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    yes, that’s what I meant ?? Good to hear that this worked!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Reset Table ID Numbers’ is closed to new replies.

Tags