Problem with new registration

Hangin' Around Joined: Jul 18, 2007 Posts: 49

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?

Posted: Mon Oct 01, 2007 6:02 am

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

Posted: Mon Oct 01, 2007 6:08 am

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?

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

modules/Your_Account/index.php

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.

Posted: Mon Oct 01, 2007 3:23 pm

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

Posted: Mon Oct 01, 2007 3:26 pm

You will need to do it through phpmyadmin.

Posted: Mon Oct 01, 2007 3:30 pm

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.

Posted: Tue Oct 02, 2007 12:29 am

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.

Subject Matter Expert Joined: Feb 23, 2004 Posts: 358

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

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

Posted: Tue Oct 02, 2007 4:52 pm

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?

Posted: Tue Oct 02, 2007 8:47 pm

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

Posted: Tue Oct 02, 2007 9:00 pm

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.

registered · Posted: Tue Oct 02, 2007 10:08 pm

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

Posted: Tue Oct 02, 2007 10:32 pm

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

Posted: Tue Oct 02, 2007 11:16 pm

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.

www.sek-sports.com

Posted: Wed Oct 03, 2007 12:00 am

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

Posted: Wed Oct 03, 2007 12:39 am

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.

Posted: Wed Oct 03, 2007 2:34 am

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

Posted: Wed Oct 03, 2007 2:39 am

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!

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.

Posted: Wed Oct 03, 2007 6:23 am

Thanks PHrEEkie!