Yesterday, I lost my user table in my database, due to a bad drive.
I restored only the user table from a two day old backup, in an effort not to lose any posts.
Of course, now I've having problems with new people registering. If I delete the last person who registered (UID: 6107), One person can register, taking that UID, but then the next person who registers gets a MySQL error.
The error is on the "INSERT INTO USER" command, and the error is:
mysql error: Duplicate entry '6107' for key 1
mysql error number: 1062
It seems like vB doesn't know to increment the UID. Is there a key in the DB that I can edit to fix this problem real quick? Seems there should be a simple solution to this..
Thanks for any help
I restored only the user table from a two day old backup, in an effort not to lose any posts.
Of course, now I've having problems with new people registering. If I delete the last person who registered (UID: 6107), One person can register, taking that UID, but then the next person who registers gets a MySQL error.
The error is on the "INSERT INTO USER" command, and the error is:
mysql error: Duplicate entry '6107' for key 1
mysql error number: 1062
It seems like vB doesn't know to increment the UID. Is there a key in the DB that I can edit to fix this problem real quick? Seems there should be a simple solution to this..
Thanks for any help
Comment