I migrated the user database table from an old site to a new one. Changed the user IDS so there was no overlap. I can access profiles, and people can login. But on the stats it says 8, meanwhile there is 75 accounts. How can I fix this?
Changing the UID's is sortof risky. There are uid's linked to posts, threads, pm's and reputations. Once this is all done you can goto your AdminCP --> Tools & Maintenance --> Recount and Rebuild --> Rebuild the stats using the appropriate buttons.
Did you only change the UIDs in the users table?? What about posts, threads, privatemessages etc...??