User ID problems...
 

Can someone please explain to me how I can have a user id of 24 for a member when I only have 21 members on the board? And how do I fix it?

well, you have obviously deleted some members, right ?

No, I haven't deleted any members. My member's list shows 21, The Admin CP user find (Find All Users) shows 21. There are 21 members there. :)

maybe the others are placekeepers for an admin, mod, supermod; so that the entries are not completely empty ??

(i dont really know)

I guess I don't really follow you here. Is this normal or is there something I can and need to do to fix it? :)

I am assuming you have downloacded the source code for a forum (probably VB), and in that case I'd suggest looking through the DB ebtries to see exactly what else has been assigned to those other ID entries.

(i dont know anything about vB :ermm: )

the userid has an autoincrement function in the db, so for every user it is set up by one, but if you delete a user, the gaps won't be filled.

so if so has the userid 24 it is the 24th user which has registred on your board, but this means not, that 23 users are already registred, because if you have created a test user, and deleted this account, it was a registred member, and so the userid has a gap there now.

Is there a way to reset it to take out any gaps? I didn't add any test users or anything like that so I don't know WHERE the gaps came from. I have the same problem with my quotes. I have a 4 quote difference in there, too. There I did delete some, but it should have filled up the empty spaces. It did for a couple of quotes I deleted but not the rest. I went in to myphpadmin and couldn't find a way to delete anything (like the gaps). :)

try this query:
[sql]
ALTER TABLE user AUTO_INCREMENT = 0;
[/sql]

That didn't change anything. It still shows my 21st user (last one) with an ID of 24. :)

yes, but now when you get a new user, it will fill the gaps :)

Then if I ever do delete any users I should run this again?

How about the quotes, can the same thing be done there?

you have to do tha again, if the autoincrement is higher than the userid which becames deleted..

yes, you can use this query which every autoincremented field.

Thank you very much. I learned something I didn't know today. Looks like it's going to be a good and productive day after all. :)

Bad news...I just tried adding a quote and I still have a 4 quote difference. It didn't fill one of the gaps with the new quote. The query ran successfully. And ideas on this one? :)

the quotes are a hacked function right?
so i don't know, because i haven't included the quote hack..

normaly it should work, but maybe try to ask at the supportthread of the quotes hack.

That query for the users didn't work either. I just had a new user log on and he is number 25 now (which he is actually the 22nd member). :)

I haven't tested it, but i know it should work, firefly has posted this method on vb.com:
http://www.vbulletin.com/forum/showt...threadid=45635

and i found a thread here where it was told it works perfect...
can'T find it anymor, forgot the exact search claus

It might work on the forum table, but it didn't work on the user or quote table for some reason. :)

hmm, then there is no way....