i have one question, i using smf 2.0 rc1, and in my phpadmin in table members i have 2748 users ID, in my forum if i control the number of user i have only 2230 users registered, i made maintenance, pruning, optimize table everything in forum and in phpadmin.
So my question is there is one comand line in mysql or something similar for have correct number of users in table ID of members and in forum ?
thx for help
No.
You would have to renumber all the members, but also EVERY single relational use of that id in dozens of other tables.
Whilst its not impossible for someone to write a script, it would take many many many hours of work.
The reason that the numbers are out is because the ID is auto-incremental. Those that are missing are those that have deleted or been deleted. This is also to ensure that ID are never used twice, and suggest against it.
As it will always occurring in the future as you delete accounts.