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

New Member Joined: Oct 02, 2003 Posts: 6

Hi,

My 100th user is trying to sign up and emailed me - she gets her confirmation email but once she's confirmed, she disappears. Her login doesn't work, and there's no record of her in the database. The same thing happens if I try to sign up a test account from my computer.

Does anyone know why this might happen? I've imported the users from a phpbb database so all of their user_id fields are two digit numbers, whereas the two people who've signed up since I moved it over have longer numbers as their IDs (10 digits).

My Anonymous user_id is set at -1 and the person who signed up last is at the top of the list after Anonymous. The user_id's then go from 2 (which is me), to 99 (which is the last person who registered on the phpbb before I moved it).

My site is here: [ Only registered users can see links on this board! Get registered or login! ]

Please help! No one can sign up at the moment!

Thanks,

Anna

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

Just as I suspected when I contacted you. You no doubt converted a stand alone PHPBB system to nuke. This is the unfortunate by-product. You will need to change the anonymous user to 0 or 1. But, you also must then reset the auto increment value in your nuke_users table. If you allowed anonymous posting under your stand alone system, then you must now change all -1 posterids to 0 or 1. If you did not allow them to post then you are done at this point.

Clear as mud Laughing

? If you would like to give me access to your phpMyAdmin, I will be happy to take care of this for you Wink

Just PM me your
site url, adminid, adminpw
and
phpMyAdmin url, id, password

Posted: Thu Oct 02, 2003 4:10 pm

I did have the Anonymous user set at 1 previously, but it still didn't work like that Confused

Fortunately there shouldn't be any guest posts (or important guest posts, at least) that need to be converted.

I'll PM you my details Smile

Posted: Thu Oct 02, 2003 5:02 pm

Well if you're not concerned about thise posts, then set the anonymous user to ZERO. Then, change thos large numbered user_id's to what they should be. Then, run this sql statement in phpMyAdmin

ALTER TABLE nuke_users auto_increment=XXX

where XXX is the next user_id to be issued.

Posted: Thu Oct 02, 2003 8:20 pm

Hi Raven,

That seems to have done the trick Smile

I've just signed up a test account and it worked fine.

Thanks so much!

Anna

Posted: Thu Oct 02, 2003 8:36 pm

Glad to have been of help!

Regular Joined: Oct 25, 2003 Posts: 67

Raven, I am having this same problem. As if I didn't have enough already.

Where do I run the sql statement from? I don't see a field to enter the command.

Posted: Sun Oct 26, 2003 3:02 pm

Unless you've converted a stand alone phpbb database, you should not be having this isse, but you run the command from phpMyAdmin in the SQL window.

Posted: Sun Oct 26, 2003 3:05 pm

I did convert from a standalone. Wink

Thats' the problem, I'm in myphphadmin, and dont see a sql window.

Posted: Sun Oct 26, 2003 3:06 pm

forget it. brain fart.

Posted: Sun Oct 26, 2003 3:36 pm

Ok, registration works, this still doesn't. I entered the command, and no dice.

Also, when users register for the board, they can not access the forum. It's showing them as registered for the forum, and they are active users, but when they goto login, they are brought to the account page.

Sooooo close!

Posted: Sun Oct 26, 2003 4:49 pm

Hi Raven. This fix didn't work. Do you think this is also the reason why people who register can not access the forum?

I loaded the sql statement and it stil gives a user id of: 2147483647

Posted: Sun Oct 26, 2003 8:03 pm

There's more to the fix than just that! You have to also change the anonymous user_id from -1 to zero and THEN apply the SQL statement.

Posted: Sun Oct 26, 2003 8:09 pm

HA. ok let me try that

Posted: Sun Oct 26, 2003 8:16 pm

It's official, i'm naming my first born Raven!

Gaylen, you are amazing. My site is now finished.

Can you please register to make sure it works? I did, but that's not a valid test.

I will alkso be sure to link to you!

Posted: Sun Oct 26, 2003 8:20 pm

Works perfectly (of course Laughing

). Please delete the user Raventest. Thanks.

Posted: Sun Oct 26, 2003 8:35 pm

You rock, thanks!

New Member Joined: Apr 12, 2004 Posts: 3

i've converted my users from phpbb to phpnuke and i've tried what raven has said and it doesn't seem to have worked.
i was wondering if raven could go into myphpadmin to correct it? thanks very much as a few people want to sign up to my site!

Posted: Mon Apr 12, 2004 1:41 pm

actually, i've tried making an account and it worked after messing round in phpmyadmin! thanks very much!

Posted: Mon Apr 12, 2004 2:01 pm

and it isn't working again now! Shocked