Announcement

Collapse
No announcement yet.

How do I reset postcount to 1 after prune all threads/posts?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    This is the way the tables work. The values are auto-incremented and not reset when you delete posts. Yoou cantry manually editing the post and thread tables to reset the next auto-increment field.

    Leave a comment:


  • f1db
    started a topic How do I reset postcount to 1 after prune all threads/posts?

    How do I reset postcount to 1 after prune all threads/posts?

    I've used PRUNE for all threads and posts and after that a REPAIR TABLES and UPDATE COUNTERS to clean up everything.
    So, now I have 0 threads and 0 posts but when I create a new thread with a new post, the post# still increasing the old value.
    Is there any table (or tables) that I can update it manually to reset post# to 1?
    Thanks,
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X