Duplicate entry error in db

[Boofo]

Can anyone tell me why this is happening all of a sudden when I new user tried to register? I am using vb 4.1.3, if that helps.

Invalid SQL:
INSERT INTO userfield
        (field7, field8, field5, userid)
VALUES
        ('Off', 'http://www.google.com', 'x.xxxxxx@xxxxxxx.net', 19);

MySQL Error   : Duplicate entry '19' for key 1
Error Number  : 1062

NOTE: I x'd out the user's email address.

[HMBeaty]

Possibly a conflicting modification? (But for some reason I doubt that :P)

SO, after a quick google search....

https://vborg.vbsupport.ru/showthread.php?t=188592

But, I'm thinking that's not the problem you're having, as you probably have more than 19 members lol.

[Boofo]

Nope, 19. I fly under the radar.

I think I found the issue. It was my fault and hopefully is fixed now. I deleted a couple of users a while back and reset the autoincrement value. I forgot about the userfield table and it seems the last 2 registrations have picked up from the old userfields rows.

Oh, and thank you for the reply.