Sign in to follow this  
Followers 0

Rearrange Topics & Members' IDs

3 posts in this topic

Posted

Hello,

I have recently performed a forum merge using the IPB converter, everything seems fine so far. But there's only 1 thing botherinng me which is the topics and members ids!

I have merged only the members, and decided to remove all the topics and posts and start a fresh start. New topics have big numbers IDs. I also want to arrange the member's ids and change some of them.

I know this might sound trivial, but I'd like to keep the community clean.

Any ideas? SQL queries to run or somthing?

Thanks in advance :)

Share this post


Link to post
Share on other sites

Posted

I think it would be better to just import the members, and then recount statistics. However... if you've already imported topics/posts and need to reset the counter, the following MySQL queries should (untested) do the trick for you, if your tables are empty:

Do note that there are other tables (mainly any table with "topic" in the title) that should likely be truncated.

As far as members, there are a few tricks to get the IDs to be continuous (I'm guessing this is what you want), but there are quite a few places where the member ID is linked at. Because of this, I'd recommend not touching these. If I remember correctly, the converter should be changing the member IDs to continuous and then link the member's old numbers. Does that make sense?

Again, I don't really recommend this and you should just let it be the way it is.

ALTER TABLE topics AUTO_INCREMENT=1;

ALTER TABLE posts AUTO_INCREMENT=1;

Share this post


Link to post
Share on other sites

Posted

Thanks a lot for your help :)

I will try the query you provided.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Who's Browsing   0 members

    No registered users viewing this page.