8 replies to this topic

[Inspiron]

Hi,
I've just created a new forum..
I've also create many test accounts to make sure my groups are working with its permissions.
Now these test accounts takes up "member number".
When I remove these test account, the "member number" don't seem to reset, instead it keeps raising..
So in the end, there's a huge gap in member number before the next real member.

I'm wondering anyone knows how to reset this member number thing so the gaps are removed.
Board is Invision version 1.3

[Hamtaro]

Well, the member number, I believe, is an auto increment number in the MySQL database. So, you would have to run this query:

ALTER TABLE table_name AUTO_INFREMENT=#

Set table_name to the name of the table with the member data in it. And set # to the number that you need to reset it to.

[Inspiron]

How do I start ?
I have no knowledge in SQL...

Step by step guide is very much appreciated.. Thanks Hamtaro in advance..

[hype]

Go to AdminCP => SQL Management => SQL Toolbox

Scroll down to the very end and there's a text area input there.

Copy the code posted by Hamtaro and paste it into the box, then run the query by click the submit or whatever it is( I forgotten the name of it.)

[Inspiron]

I couldn't find the option "SQL Management => SQL Toolbox"
I'm using the free remote forum provided and hosted by Invision itself..
Is there another way of doing it ?

[guangdian]

i'm afraid you can not do something with that.
it hiden in the mysql database,.how you will change it from that/
you can not i think.

[Ao)K-General]

Those are really old. I wish we could get a better version of IPB. But I think thats the best it will go. It sucks really.

[Gyad]

Yeah, I don't think you can change the number then. You could always just register for another account. Its one of those free ones right?
And yes, it does suck that IPB asked Fantastico to removed 1.3 from it and changed it to 1.2 .

[michaelper22]

If you are using one of the freely hosted forums, they might not provide you with the SQL Toolbox (which I must say s pretty neat). Generally they won't give several other advanced features either.