 Invision Forums Member Number, How to reset the member number ? |
|
|
|
|
  |
 May 19 2005, 03:17 PM
Post
#1
|
|
|
Trap Grand Marshal Member  Group: Members Posts: 1,205 Joined: 25-March 05 Member No.: 4,883  |
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 |
 |
 
|
|
May 19 2005, 09:53 PM
Post
#2
|
|
|
Super Member Group: Members Posts: 372 Joined: 14-October 04 Member No.: 1,736 |
Well, the member number, I believe, is an auto increment number in the MySQL database. So, you would have to run this query:
CODE 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. |
|
|
|
|
May 20 2005, 04:48 AM
Post
#3
|
|
|
Trap Grand Marshal Member Group: Members Posts: 1,205 Joined: 25-March 05 Member No.: 4,883 |
How do I start ?
I have no knowledge in SQL... Step by step guide is very much appreciated.. Thanks Hamtaro in advance.. |
|
|
|
|
May 20 2005, 07:59 AM
Post
#4
|
|
|
Legend Killer Group: Members Posts: 678 Joined: 15-April 05 From: Singapore Member No.: 5,697 |
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.) |
|
|
|
|
May 20 2005, 03:29 PM
Post
#5
|
|
|
Trap Grand Marshal Member Group: Members Posts: 1,205 Joined: 25-March 05 Member No.: 4,883 |
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 ? |
|
|
|
|
Oct 21 2005, 02:03 AM
Post
#6
|
|
|
Trap Grand Marshal Member Group: Members Posts: 1,183 Joined: 24-September 04 Member No.: 1,245 |
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. |
|
|
|
|
Oct 21 2005, 02:50 AM
Post
#7
|
|
|
Privileged Member Group: Members Posts: 524 Joined: 6-March 05 Member No.: 4,187 |
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.
|
|
|
|
|
Oct 21 2005, 02:57 AM
Post
#8
|
|
|
Super Member Group: Members Posts: 236 Joined: 4-June 05 From: in the dark abyss... Member No.: 7,868 |
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 . 
|
|
|
|
|
Jan 5 2007, 03:03 AM
Post
#9
|
|
|
-=Hybrid Bus=- Group: Members Posts: 744 Joined: 2-November 05 From: My hybrid bus (in NYC), a computer Member No.: 13,709  |
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.
|
|
|
|
