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.
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).
Quote:
Originally posted by Xenon 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.
06-12-2002, 09:22 PM
User ID problems...
Linear Mode
