Table Number

  • Resolved xecutable

    (@xecutable)


    11 years, 1 month ago

    Hi,

    I accidentally imported my tables twice from the database and though I erased the doubles, when I import a new table, the table number starts from 1260+ when the tables are 635.

    I believe that the internal counter is still reading the import I made by accident. How do I reset it?

    Regards

    http://wordpress.org/extend/plugins/tablepress/

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

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks for your post.

    Well, no, the internal counter doesn’t read the import you made by accident, but it simply does not decrease again when a table is deleted. This is to make sure that no table ID is used twice.

    If you really want to reset the counter, please do this:
    Go to http://www.example.com/wp-admin/options.php
    Scroll down to the entry with the name “tablepress_tables”. In that text field, you should see “last_id” with a number (probably 1260+) behind it. Change that number to 635, and click “Save” at the bottom of the page.

    Regards,
    Tobias

    Thread Starter xecutable

    (@xecutable)

    11 years, 1 month ago

    Thanks a lot for the fast response! Will do

    Plugin Author TobiasBg

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    ok! Let me know if it works.

    Regards,
    Tobias

    Thread Starter xecutable

    (@xecutable)

    11 years, 1 month ago

    It will work as soon as I am able to use Save. I am guessing the max_inputs_var is not high enough, and this option.php contains a ton of information.

    I am currently trying to reach my host to up the value so I can make the change and then revert it.

    Regards

    Plugin Author TobiasBg

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    ah, that can indeed be a problem 🙁 Sorry about that…

    If you can’t change it on options.php, you can change in the wp_options table, directly in the database.

    Regards,
    Tobias

    Thread Starter xecutable

    (@xecutable)

    11 years, 1 month ago

    Thanks. I did the correction via the phpmyadmin and it worked out great. Thanks for you help and I will donate by the end of the month something for your contribution to my problem.

    Regards

    Plugin Author TobiasBg

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    great that this worked! And thanks for wanting to donate, I really appreciate it!
    Meanwhile, if you want, you can rate TablePress here in the plugin directory. Thanks!

    Best wishes,
    Tobias

    Thread Starter xecutable

    (@xecutable)

    11 years, 1 month ago

    Sure will do

    Plugin Author TobiasBg

    (@tobiasbg)

    11 years, 1 month ago

    Hi,

    thanks, that’s really very nice!

    Best wishes,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Table Number’ is closed to new replies.