Can't add users

Hangin' Around Joined: Aug 03, 2004 Posts: 28

Instead of starting a new thread, i thought I would bump this one.
Raven, you seem to know your stuff... and I kinda just started getting into this, this anonymous thing, where do I find that? in nuke_users? cause I can't find it!

I have the same problem as the first person...

Posted: Tue Aug 03, 2004 10:42 am

Oh yea, it doesn't have anything to do with me having more than 99 users however, i have like 17

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

Check nuke_users and see if your autoincrement value is some BIG number.

Posted: Tue Aug 03, 2004 11:08 am

The Lenght/Values tab?
It's set to 11

Posted: Tue Aug 03, 2004 11:11 am

No, the auto increment value. When you select the nuke_users table from the left hand panel it will display many MySQL values in the center of the right panel. One of these is the Next auto increment.

Posted: Tue Aug 03, 2004 11:13 am

user_id int(11) No auto_increment

Sorry! Does that help?

Posted: Tue Aug 03, 2004 11:22 am

No. You are on the wrong page. You don't want to be lookinf at the table schema. When you click on the nuke_users link in the left panel you should see a listing of all the fields in the table. Right after that are some MySQL statistics, like

Code:

Row Statistic : Statements Value 


Format dynamic  


Rows 2  


Row length ø 130  


Row size  ø 2,690 Bytes  


Next Autoindex 3  


Creation Feb 23, 2004 at 08:37 AM  


Last update Mar 04, 2004 at 09:08 AM

Posted: Tue Aug 03, 2004 11:26 am

Statements Value
Format dynamic
Rows 17
Row length ø 240
Row size ø 541 Bytes
Next Autoindex 20
Creation Aug 03, 2004 at 10:26 AM
Last update Aug 03, 2004 at 11:20 AM

So is 20 the number?

Posted: Tue Aug 03, 2004 11:28 am

Yes. Did you convert a stand alone PHPBB database to Nuke? If not, this is the wrong thread. I will move it and start another one.

Posted: Tue Aug 03, 2004 11:30 am

Like I said, im a n00b.

I didn't convert, well not that I know of.
It was a clean install of php-nuke...
Then i added some modules...

Posted: Tue Aug 03, 2004 11:40 am

Topic split and moved Smile

Now, what happens when a new user registers?

Posted: Tue Aug 03, 2004 11:44 am

The user can register and recieves the e-mail fine, but when he clicks on the activation link he gets the following message.

Code:

There is no user in the database with this information. 


You can register a new user from here.

It's happened to alot of my members, they couldn't log into their account. So I had to reset their password...

Thanks!

Posted: Tue Aug 03, 2004 11:54 am

Raven,
Would installing your auto-registration mod fix my problem?

I dont care much for the e-mail activation...

Posted: Tue Aug 03, 2004 11:55 am

What server platform are you using? IIS or Apache?

Posted: Tue Aug 03, 2004 11:58 am

http://www.bluehost.com/tell_me_more.html
Customized Apache Web Server
?

Posted: Tue Aug 03, 2004 12:09 pm

Do you have a table called nuke_users_temp?

Posted: Tue Aug 03, 2004 12:11 pm

Yes I do

Posted: Tue Aug 03, 2004 12:32 pm

See if this helps http://www.ravenphpscripts.com/posts1477-highlightuser.html+database+information

Posted: Tue Aug 03, 2004 12:37 pm

Quote:

CREATE TABLE nuke_users_temp (
user_id int(10) NOT NULL auto_increment,
username varchar(25) NOT NULL default '',
user_email varchar(255) NOT NULL default '',
user_password varchar(40) NOT NULL default '',
user_regdate varchar(20) NOT NULL default '',
check_num varchar(50) NOT NULL default '',
time varchar(14) NOT NULL default '',
PRIMARY KEY (user_id)
)

That's exactly what I have in my nuke_users_temp
WAAAAAAAAAAA Crying or Very sad

Posted: Tue Aug 03, 2004 12:40 pm

I remember at one point when installing php-nuke through Fantastico...
it asked me if I wanted e-mail verification, i chose no

so maybe when it says theres no such user, it's because the user has been copied to the nuke_user right away instead of going into the temp...

do I make sense?

because I tried with the test account I made and I can log in... it took like 5 minutes but I can log in, even though the activation link doesn't work...

if that is the case, then fantastico is stupid for not removing the entire activation process... and so I should install your auto-registration addon to fix the issue.

Posted: Tue Aug 03, 2004 12:54 pm

In Forum Configuration, what is the setting
Enable Account Activation
set to?

If set to NONE, try setting it to AMDIN.

Posted: Tue Aug 03, 2004 2:03 pm

You're a genius.
I tried it once and worked perfectly, ill try it again later to make sure it's still working.
Thanks!!