Userid problem

[lood2]

Hi
after a DB crash and repair, new registered userid are > 3181650000
I've tried deleting all traces of this %number% on all tables/datastore but when I add new user it is still increasing
I've repaired again all tables but no luck.
vb 3.8.7 pl2

any idea ?

Thanks

[TheNewOne]

ALTER TABLE `user`
AUTO_INCREMENT=4;

run this query
change the number 4 to the one above the highest of the one you have now for userid


so in other words if the highest userid is 4 then you would change it to 5

[lood2]

Worked,
thank you

[TheNewOne]

your welcome