[Bryan Ex]

Originally Posted by Nebula

Good luck. I hope it works out for you If you encounter any problems, post them here.

Wow! That was too close to disaster for my liking. I ran a couple of test imports during the week just to be sure everything would be okay... and I thought it did. What I did not notice was that all the userID's were renumbered starting from 1. This means that every time a missing ID was encountered, all the users from that point on would change ID affecting everything across my site (user base is integrated with three other applications). To make matters worse, my backups from Friday were corrupt and I had to manually cut and paste all date back into the db.

I'm back to where I started now but can't seem to override the auto increment of user ID's. I've tried your importer (the better one IMO) and the jelsoft version, both with auto-inc disabled. Is there a way to import the usernames and keep them associated with current ID's in phpBB2? A perfect example is admin which is user 2 in phpBB but #1 in VB. Once I import I become "lilpinkpuppynoses" in my gallery, classifieds, and chat. I'm dealing with 8000 registered members here and do not want to go through renumbering each one individually if at all possible.