I managed to successfully import my phpbb 2.20 into my Drupal 5.1 site. All is mostly well. The forums, posts and users all show up. However, there is now an error whenever anyone new tries to register. My guess is that somewhere in the Drupal database there is a variable that keeps track of how many users there are, and this variable is now wrong because we have 200 something users but when a new user tries to sign up, Drupal tries to stick him in someweere around number 47:

user warning: Duplicate entry '47' for key 1 query: INSERT INTO users (name, mail, pass, init, status, uid, created) VALUES ('testuser', 'cpelham@mindspring.com', '098f6bcd4621d373cade4e832627b4f6', 'cpelham@mindspring.com', 1, 47, 1176154191) in /home/cpelham/public_html/drupal/includes/database.mysql.inc on line 172.

If someone can tell me which table/variable holds the number of users, I can probably edit this myself. Anyone?

Comments

cpelham’s picture

cpelham commented
Status: Active » Closed (fixed)

I found the variable for number of users in the sequences table. I corrected that number and now I can add new users.