Problem with new registration

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

This just started happening out of the blue. When new members register, they put in their username and password and it tells them log-in incorrect. I even tried it myself and got the same result. But I can go in and edit their profile and retype their password and then they can login. Any suggestions?

jakec · Posted: Mon Oct 01, 2007 6:02 am

Have you made any changes to your site recently? Changed host?

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

No, I haven't changed anything. I do back-ups all the time and have a back-up from a couple days ago. Could I just upload a certain file or folder that contains the registration program? Which folder would it be?

montego · Posted: Mon Oct 01, 2007 6:50 am

modules/Your_Account/index.php

jakec · Posted: Mon Oct 01, 2007 3:07 pm

I'm wondering if your DB has got corrupted, you could try running a repair on your nuke_users table.

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

How do I do that? I tried updoading the back-up of "Your Account" but that didn't work. Thanks for your help guys.

jakec · Posted: Mon Oct 01, 2007 3:26 pm

You will need to do it through phpmyadmin.

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

I just tried that as well, I did "check table" first and it came back as ok. Then did "repair table" and it came back ok. Still no luck.

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

Anyone have any other ideas on how I can fix this? It is puzzling as to why when you type your password it recognizes your login as incorrect but I can go in and edit their profile and type in the exact same password and it works!

Also, when a new member chooses "lost password" and goes through that process the generated password allows them to login correctly.

PHrEEkie · Subject Matter Expert Joined: Feb 23, 2004 Posts: 250

sek-sports wrote:

Also, when a new member chooses "lost password" and goes through that process the generated password allows them to login correctly.

So when you reset their pass, or they do it through lost password, they can login, but only once? Next login is nerfed again?

Honestly, this type of random 'out of the blue' type of problems generally require someone to go in and place stop points in the login sequence and examine/compare variables. It's kinda hard to help through a message board once we've gone through the usual 'have you made any changes recently' or 'have you verified the SQL table is sound'.

That being said, there's usually several things that will generate the same verbose error to the user, so it might not be the password... do you use the captcha? If so, turn it off and test. Fire off an email to your host and ask them if THEY made any changes to the server config. Did they upgrade PHP or MySQL recently? You might be getting bit by the old_password variable in the new MySQL, or they might have changed something in the php.ini file. My .02's

PHrEEk

montego · Posted: Tue Oct 02, 2007 6:04 am

I have a feeling that you/they are trying to use some special characters within the password. Try just alphanumeric and see if the same problem occurs.

I have seen throughout nuke where there can be different rules applied between modules and admin. For example, in some cases something could be "encoded" and in other cases not. It is quite a mess under the hood...

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

That was my first thought also. So I tried just a straight text password, a straight numerical password still no luck.

"So when you reset their pass, or they do it through lost password, they can login, but only once? Next login is nerfed again?"-No it works fine from then on. Crazy isn't it?

PHrEEkie · Subject Matter Expert Joined: Feb 23, 2004 Posts: 250

Ok, then this is less random... I can either go in and fix it, or fix up a script that will output results that we can analyze. Your call...

PHrEEk

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

What do you need from me to go in and fix? Right now I have my "new register" links going to a content page asking everyone to send me an e-mail so I can add them manually. Not much fun that way.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2845

Can you link us to the site so we can see what's going on?

PHrEEkie · Subject Matter Expert Joined: Feb 23, 2004 Posts: 250

sek-sports wrote:

What do you need from me to go in and fix? Right now I have my "new register" links going to a content page asking everyone to send me an e-mail so I can add them manually. Not much fun that way.

You can just create a temp password to the system, then set it back once we're done. PM me the info, including FTP address, etc. Also the site base URL.

PHrEEk

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

I sent you what I thought you would need. Let me know what else you may need. Like I said, I changed my registration links to go to a content page. I know that will need to be changed back if you can figure out what is going on.

Only registered users can see links on this board!
Get registered or login to the forums!

PHrEEkie · Subject Matter Expert Joined: Feb 23, 2004 Posts: 250

Ok, right off the bat, there are some serious MySQL or phpMyAdmin issues on your server... I am trying to create a temp Admin login for nuke, and phpMyAdmin throws about 9 errors when trying to insert the new row.

That's not too good for starters Rolling Eyes

hehe

Sending you a PM and hopefully you can login as Nuke Admin and create an Admin acct for me from inside Nuke...

PHrEEk

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

Got your PM and sent you one back. I appreciate your help, I know nothing when it comes to MySQL stuff. I do know when I had a different site a few years ago, I could go in and edit and add with no problems. But like you said, when I try anything I get errors all over the place with this one.

PHrEEkie · Subject Matter Expert Joined: Feb 23, 2004 Posts: 250

UPDATE: Problem solved...

Field length for password in the users_temp table was set to 25, which was truncating the password as it was stored for a new user. Modified the field for 40 chars, and problem solved.

Thanks for being patient SEK!

PHrEEk

sek-sports · Hangin' Around Joined: Jul 18, 2007 Posts: 39

Dude, thank you so much. For someone to take their personal time and fix a complete strangers problem is awesome.

PHrEEkie=Member of the Month!

jakec · Posted: Wed Oct 03, 2007 6:02 am

Nice catch PHrEEkie.

I wonder why that should suddenly change though. It's worth keeping an eye on and if it should happen again try to find out what it is causing it.

montego · Posted: Wed Oct 03, 2007 6:23 am

Thanks PHrEEkie!