Inspiron 0 Report post Posted May 19, 2005 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 Share this post Link to post Share on other sites
Hamtaro 0 Report post Posted May 19, 2005 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. Share this post Link to post Share on other sites
Inspiron 0 Report post Posted May 20, 2005 How do I start ?I have no knowledge in SQL...Step by step guide is very much appreciated.. Thanks Hamtaro in advance.. Share this post Link to post Share on other sites
hype 0 Report post Posted May 20, 2005 Go to AdminCP => SQL Management => SQL ToolboxScroll 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.) Share this post Link to post Share on other sites
Inspiron 0 Report post Posted May 20, 2005 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 ? Share this post Link to post Share on other sites
guangdian 0 Report post Posted October 21, 2005 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. Share this post Link to post Share on other sites
Ao)K-General 0 Report post Posted October 21, 2005 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. Share this post Link to post Share on other sites
Gyad 0 Report post Posted October 21, 2005 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 . Share this post Link to post Share on other sites
michaelper22 0 Report post Posted January 5, 2007 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. Share this post Link to post Share on other sites