Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke
Author Message
Robocrotch
Hangin' Around



Joined: Aug 03, 2004
Posts: 28

PostPosted: Tue Aug 03, 2004 10:40 am Reply with quote

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...
 
View user's profile Send private message
Robocrotch







PostPosted: Tue Aug 03, 2004 10:42 am Reply with quote

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



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Tue Aug 03, 2004 11:06 am Reply with quote

Check nuke_users and see if your autoincrement value is some BIG number.
 
View user's profile Send private message
Robocrotch







PostPosted: Tue Aug 03, 2004 11:08 am Reply with quote

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







PostPosted: Tue Aug 03, 2004 11:11 am Reply with quote

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.
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:13 am Reply with quote

user_id int(11) No auto_increment

Sorry! Does that help?
 
Raven







PostPosted: Tue Aug 03, 2004 11:22 am Reply with quote

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
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:26 am Reply with quote

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?
 
Raven







PostPosted: Tue Aug 03, 2004 11:28 am Reply with quote

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.
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:30 am Reply with quote

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...
 
Raven







PostPosted: Tue Aug 03, 2004 11:40 am Reply with quote

Topic split and moved Smile

Now, what happens when a new user registers?
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:44 am Reply with quote

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!
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:54 am Reply with quote

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

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







PostPosted: Tue Aug 03, 2004 11:55 am Reply with quote

What server platform are you using? IIS or Apache?
 
Robocrotch







PostPosted: Tue Aug 03, 2004 11:58 am Reply with quote

[ Only registered users can see links on this board! Get registered or login! ]
Customized Apache Web Server
?
 
Raven







PostPosted: Tue Aug 03, 2004 12:09 pm Reply with quote

Do you have a table called nuke_users_temp?
 
Robocrotch







PostPosted: Tue Aug 03, 2004 12:11 pm Reply with quote

Yes I do
 
Raven







PostPosted: Tue Aug 03, 2004 12:32 pm Reply with quote

See if this helps [ Only registered users can see links on this board! Get registered or login! ]
 
Robocrotch







PostPosted: Tue Aug 03, 2004 12:37 pm Reply with quote

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 Crying or Very sad Crying or Very sad Crying or Very sad Crying or Very sad
 
Robocrotch







PostPosted: Tue Aug 03, 2004 12:40 pm Reply with quote

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.
 
Raven







PostPosted: Tue Aug 03, 2004 12:54 pm Reply with quote

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

If set to NONE, try setting it to AMDIN.
 
Robocrotch







PostPosted: Tue Aug 03, 2004 2:03 pm Reply with quote

You're a genius.
I tried it once and worked perfectly, ill try it again later to make sure it's still working.
Thanks!!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©