Can't seem to have more than 100 users.. help!

New Member Joined: Oct 02, 2003 Posts: 6

I posted about this problem previously, but it's resurfaced! I keep wondering why no one is joining my site, because I seem to have loads of guests, but I got an email this morning stating that after users click on the confirmation link, they can't login ("Login details incorrect"). Indeed, they're deleted from nuke_users_temp but not added to nuke_users.

The userids are all whacky - the last user who joined (the 100th user) has userid "2147483647". There's no userid 1, and Anonymous has the userid 0.

This happened after I merged the user database from phpBB2 with the nuke_users table. I'd previously thought I fixed the problem by changing the next auto-increment but apparently it didn't work.

Any other ideas?

This is my old thread regarding this problem

TIA

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Anna,

Make sure that there are no users in your users table with the -1 user_id value. If there are then correct it using phpMyAdmin. Then, follow the steps in your other post. I routinely use the procedure in that other post and it has never failed me. I don't know what else to offer up at this point. You might also look at the user_id in the users_temp file to see if there are any in there that have a large user_id. I would also disallow anonymous posting if you haven't already.

Posted: Mon Oct 20, 2003 6:22 am

^ I've disallowed Anonymous posting, had done that already. The last member who joined is the only one with the large userid. None of the users have an id of -1, and following the instructions in the other thread doesn't fix the problem Crying or Very sad

Might have to start over!

Posted: Mon Oct 20, 2003 6:28 am

So you corrected that bad user_ids in users and temp users (if there were any) and then did the ALTER statement on both the users and temp users table to reset them accordingly and you still have the problem?

Posted: Mon Oct 20, 2003 6:34 am

I did all of that, yup.

Then I did it again, and then again.

Third time's a charm, as they say. It works now Rolling Eyes

Thanks Raven!