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

  • 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,

  • #2
    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.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X