Invision Forums Member Number - How to reset the member number ?

free web hosting
Free Web Hosting, No Ads > Have your say > General Talk

Invision Forums Member Number - How to reset the member number ?

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

Reply

Hamtaro
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.

Reply

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

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

Reply

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.)

Reply

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 ?

Reply

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.

Reply

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.

Reply

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 . sad.gif

Reply

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.

Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. ipb member number - 51.87 hr back. (1)
  2. ipb remove inactive member forum - 93.80 hr back. (1)
Similar Topics

Keywords : invision forums member reset member

  1. Get Paid To Post On Forums? - Links, Resources for Pay for Writing, Earn from Forums (17)
    Get Paid to Post on Forums I have seen these all over, could people maybe give me a
    short list on where I could post on forums and get paid? I am a freelance writer, and I know this
    is one option. I tried searching it, but word of mouth always works best. Thanks in advance!
    Note: Please move if needed, I wasn't sure if I should do it in the Make Money forum, or not.
    At Trap17.com - This very site, You get paid in terms of CREDITS. These credits are used to keep up
    your Web Hosting account (which we give for FREE). The Web Hosting is of top ...
  2. I'm A Hosted Member... Right? [resolved] - I got my hosting request accepted, but where's my account? (11)
    I already had my account closed (which means accepted) but I can't post in the members' only
    forum! How come? Please help me....
  3. Which Forums Would You Prefer? - Good for people creating communities... (13)
    I'm using InvisionFree board... I wanna know what others think about other boards and their
    reasons for it......
  4. Get A Hosting Space With Post In This Forums ? - (1)
  5. Downloading From The Forums - (4)
    I hope this is the right place for this. I tried searching a couple of different ways, but
    didn't find anything. I guess this would be for an admin, but if anybody knows the answer.... I
    saw an e-book I wanted to download from the forum, everytime I try to, I get a board message telling
    me something about I don't have access for this. What do I have to do to be able to download
    attachments from the forums?...
  6. Hello Everybody (new Member) - (6)
    Hello everybody. i am a new member. Hope your help much. Thanks...
  7. Which Forums Should I Use - (2)
    I am going to get hosted again in the near future. i do not feel like going through that hassle of a
    home page and stuff. I was wondering what is the best forum that can be installed from Fantastico in
    the Cpanel. In your opinion which is the best. I have already tried phpbb and i liked it. But i
    would also like to know about any other ones that might be good. If you have an example of one of
    the other forums please leave a link so i may check it out. Thanks....
  8. Flashback - Trap17 - 5 Years Ago - Before the Free Hosting and Forums! (7)
    Flashback... Well I was browsing Archive.org and figured what the heck... so I typed in Trap17
    and WOW. Would you believe what a long way we have come with the main page and stuff. Also the
    quality, if I had seen the main page back in 2001 or 2002 before July 25... it looked bad and looked
    like a crappy hosting. But like anything else over time it gets better and we improve on our
    mistakes. /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> And
    thats what made Trap17.com the place it is today. And what was with that red spider web an...
  9. Daylight Savings Time - Reset tonight (17)
    Just in case there are questions about it, this is a reminder to check the Clock settings of your
    computer and also the Time Zone settings on all of the Forums you attend. Some Forums do not allow
    for Timezone and Daylight Savings Time to be adjusted automatically....
  10. Do You Ever Feel Like Giving It All Up? - Forums, websites, the internet... (15)
    I've made all sorts of online friends in the past, and I got bored and just moved on. Now
    there's a new group and I just don't know. Maybe it's because I've spent this
    Saturday night having a few drinks and sitting on the internet with nothing to do. Does anyone else
    ever feel like just giving it all up? I feel like I am stuck in a rut. I haven't learned
    anything new design wise lately, either. That usually makes all of this exciting again. Has anyone
    else ever thought like this? What did you do about it? I'm such a nerd. /sad.gif" style="...
  11. Changing Webhosts - I won't leave the forums, though. (2)
    Hello all, I will soon be looking at some paid web hosting. I loved every minute of being with
    Trap17 and I would like to say that I will not be leaving the forums. I enjoy reading some of the
    material on this site and I have adopted it as one of my often visited communities. Also, a big
    thanks goes out to buffaloHELP for helping me when I made a mistake and approving me for hosting.
    Trap17 is a great web hosting solution and I am surprised that not many people know about it. But
    anyways, not too sure that too many people really care as this thread was directed more towa...
  12. Rate The Person Who Posted Before You - rate them on what you think, and how good they are to the forums (2)
    I have seen this on other forums where someone starts a topic and the person who posts after that
    will rate the person before them...make sence?? ok well if it does why not give it a try? So
    since there is noone for me to rate i will not rate anyone >_ /laugh.gif"
    style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif" /> *edit* gunna be more
    descriptive on the rating... you can give them a #/10 and also give a reason why you give this
    number rating so high, or so low....explain why you like them, maybe even what you know about
    them...etc *edit*...
  13. Activex Error Messages? And Popups? - Are these normally on the forums? (2)
    While browsing the trap17 forums today, two things strike me as weird. While I was hanging around
    the forum index, I get a popup from a website , which my browser claims came from this website. But
    since when did Trap17 use pop-up advertising? At the same time, the following error message
    appears: QUOTE Your current security settings prevent ActiveX from being displayed. As a
    result, this page may not work correctly. (Or something very close to that, you can't copy
    error message text.) This message popped up again while I visited a few topics, but I have ...
  14. Can You Use A Login Script To Login To Forums - from outside of the forum itself? (3)
    The title and description of this topic should tell you my basic question, but it's never enough
    detail just to read a question, so I will explain my intention. Basically, on my website I have a
    php script for users to register to my site. I then use this data to create forum accounts (I do not
    use the main forum Registration form because I cannot change it's contents and there are some
    questions I'd like to ask before registration). Later I also plan to make hidden areas that you
    need to register for to enter. Anyway, I wondered if it was possible to make ...
  15. I Must Be Confused (returning Member) - is this the same place from a year back (1)
    1) Is this or was this originally kalacreations.com run by Mstr aka Dediana87 (or close) 2) if yes
    then why doesnt my old log in of andover work 3) wow this place changed ALOT Refrain using
    expletive words! Editing your title. ...
  16. Color Codes For Forums - (3)
    Anyone here know the color code thingies for forums. you know like yyyyy is yellow or whatever, i
    need to know the codes for Gray, Black, Red, and white so please pm me if you know them...
  17. Need Some Help With Website - im a new host member but I have no idea what to do know... (2)
    was so glad My application for free hosting Package 2 was approved! I'm now at the cpanel
    site...you now http://yoursite.com/cpanel and I have noooo idea what to do next!! I want
    to make a site...I have a site saved in Frontpage...so does anyone know how to upload it or
    something...I've never did this before so I have no idea. I also would like to work with
    HTML....but how do I do this...I mean is there anywhere a place in the menus where I can upload it ?
    I'd really appreciate anyone helping me. I couldn't find a help topic anywhere on t...
  18. How Do You Make A Thingy Like Marquee - How To Do Whats On Top of TRAP17 Forums Pages (5)
    How Do You Do This: Its Like a Marque, But Acts Like a GIF, The One On the Top of TRAP17 Forum
    Pages. I Really like to know how to do this....
  19. Cool Forums! - (1)
    Look this forums! /biggrin.gif' border='0' style='vertical-align:middle' alt='biggrin.gif' />
    PLEASE REGISTER THERE!! /biggrin.gif' border='0' style='vertical-align:middle'
    alt='biggrin.gif' /> They are great how do you rate them!!...
  20. Forums Hacks - (2)
    Is there any chance of having either: http://www.phpbbhacks.com/download/248 or
    http://www.phpbbhacks.com/download/2331 this hack installed? The first one would allow
    moderators to lock a topic as they post. Saving the trouble of going back to it after posting.
    The second allows you to move a topic at the same time as you lock it (ideal for account creators).
    Thoughts?...
  21. phpnuke forums.... - (5)
    hi i get this when i access the forums admin cp Parse error: parse error in
    /home/www/ngageroms.freeownhost.com/modules/Forums/admin/index.php on line 623 code
    attached <?php /*************************************************************************** *
                                (admin) index.php *                          
     ------------------- *   begin                : Saturday, Feb 13, 2001 *   copyright        
       : (C) 2001 The phpBB Group *   email                : support@phpbb.com * *
      $Id: index.p...
  22. Suggestion: clean up the forums : - (16)
    It seemed like a good idea to me that when FNH officially merges, this forum should be cleaned up.
    With this I mean getting all non stickied posts out of the way, because the forum is filling up too
    much now (my opinion), what do you think?...
  23. Before open request hosting - remove all old inactive member - (11)
    Just a suggestion, also the members have been asking that we remove all the old inactive members
    from the forum. I feel that if you guys wanna do this, it is done before we open the request
    forum. This will make it easier to remove hosting from those who have been inactive. Thoughts?...
  24. Forums Rules & Important Information ~ Updated 12/03/05 - (0)
    Welcome To Free Nuke Hosting Index 1. Forum Rules 2. Terms of Service 3. Music Rules
    4. FAQs 5. Trading Market
    ******************************************************************** Please read carefully so that
    you do not get in trouble with the site staff.
    ********************************************************************* 1. Forum Rules
    You are not allowed to Post: Links To: Child Pornography Adult Content Torrents files
    Warez (P2P) Illegal Content Posts Should Not Include: Spam Cracks Or Ser...
  25. Stoned Devil Inc. & Free Nuke Hostin Forums? - (14)
    Might I make a suggestion regarding the recent partnership of Stoned Devil Inc. and Free Nuke
    Hosting. My suggestion is that instead of having a forum at Free Nuke Hosting and a forum at
    Stoned Devil Inc. why not just have the one? I feel that the larger community is here, at FNH
    rather than at Stoned Devil Inc. Surely it would benefit both sites if the main area where
    webhost and web design was in the same forum. Any way this is just my thoughts. What do you
    think? Haz...
  26. remove spam corner forums google rules - (1)
    Hello please remove the spam corner forums google will shut the down the ads because of the spam
    corner....
  27. Invision board VS phpbb - (84)
    which one do you like better? feel free to post your comments here! * I like IBP better,
    because it's easy to manage and other than that, it's has more modifications than Phpbb. I am using
    a 2.0.0 now, and i really like it! /smile.gif' border='0' style='vertical-align:middle'
    alt='smile.gif' /> ...
  28. New Forums - (51)
    If you want new forums to be added, please reply to this message /smile.gif' border='0'
    style='vertical-align:middle' alt='smile.gif' /> Tell me clearly the title of the forum and what
    it's about /wink.gif' border='0' style='vertical-align:middle' alt='wink.gif' /> ...
  29. PHPbb or invision? - (16)
    can somebody help me what are the benefits of both? TNX Poll added by CodeFX ...
  30. Our Blessed FNH Forums - (5)
    Uhm... Is it just me - i miss these forums, they're nicer to post in than the constricted - not nice
    layout VAIO forums... Can admin transfer the forums over? Surely he can... Oh and, plz post
    your comments and opinions below too /biggrin.gif' border='0' style='vertical-align:middle'
    alt='biggrin.gif' /> ...



Looking for invision, forums, member, number, reset, member, number

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for invision, forums, member, number, reset, member, number

*MORE FROM TRAP17.COM*
advertisement



Invision Forums Member Number - How to reset the member number ?



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE