Existing User Password Issue

[Guest]

Hi all,

 

Ive seen some posts relating to this issue, but I cant find an answer anywhere.

 

When I create an account on my site, [email protected] with a password, everything works okay. I can login /logout without any issues.

 

If I logout, then go back to the login page, I click Forgotten Password. I then add my email address and a few seconds later I receive an email with my new password.

 

When I attempt to put in my email address and the new password, I receive an error saying:

 

Error: No match for E-Mail Address and/or Password.

 

Could some please help me as Ive been trying to resolve this for days now.

 

Thanks in advance,

 

Sanye

[tapuahk]

Hi all,

 

Ive seen some posts relating to this issue, but I cant find an answer anywhere.

 

When I create an account on my site, [email protected] with a password, everything works okay. I can login /logout without any issues.

 

If I logout, then go back to the login page, I click Forgotten Password. I then add my email address and a few seconds later I receive an email with my new password.

 

When I attempt to put in my email address and the new password, I receive an error saying:

 

Error: No match for E-Mail Address and/or Password.

 

Could some please help me as Ive been trying to resolve this for days now.

 

Thanks in advance,

 

Sanye

 

I can't seem to duplicate the problem...

 

Can you still log in using the old password?

If you can then there is a problem with the password_forgotten.php file.

 

~~~Tapuahk

[Guest]

I can't seem to duplicate the problem...

 

Can you still log in using the old password?

If you can then there is a problem with the password_forgotten.php file.

 

~~~Tapuahk

 

No I cant. It seems that the new password is sent to me, then the original password becomes void. It then means that Im unable to access my account again.

 

Very frustrating

[Guest]

No I cant. It seems that the new password is sent to me, then the original password becomes void. It then means that Im unable to access my account again.

 

Very frustrating

Not a common problem, what addons did you install?

[tapuahk]

Not a common problem, what addons did you install?

 

Okay... Open phpAdmin browse the Customer Table you should find the hashed password in the password column...

 

If you see straight text, it might be more complicated.

 

BUT..

 

If you ever manually hashed a password for a .htpassword file, you'll see if it's output problem from forgotten_password.php

 

Let me know if this helps...

 

~~~Tapuahk

[Guest]

Not a common problem, what addons did you install?

 

I installed PWA and New Customer Notify v7.

 

Ive seen posts relating to the same problem without addons installed.

 

James

[Guest]

Okay... Open phpAdmin browse the Customer Table you should find the hashed password in the password column...

 

If you see straight text, it might be more complicated.

 

BUT..

 

If you ever manually hashed a password for a .htpassword file, you'll see if it's output problem from forgotten_password.php

 

Let me know if this helps...

 

~~~Tapuahk

 

 

Tapuahk,

 

Not sure about this response, but I do believe that you may be on the right tracks with the MYSQL db.

 

I think the password field in the Customer table is being incorrectly formatted (40bit Vs 56bit or something like that). Cant check this until tonight, but Im quietly confident that if I change the format of that field to something more appropriate, this will resolve my issue.

 

Apologies for being vague, but Im not able to access the DB at the moment.

 

If it works, I will post the steps I took, on the forum tomorrow.

 

James

[Guest]

I installed PWA and New Customer Notify v7.

 

Ive seen posts relating to the same problem without addons installed.

 

James

Don't know that one, did involve an sql file?

[Guest]

Don't know that one, did involve an sql file?

 

Both of the addods involved sql files. The actual addons for your information were:

 

pwa_2_0b

 

New_Customer_Emails_1_1

 

James

[Guest]

Both of the addods involved sql files. The actual addons for your information were:

 

pwa_2_0b

 

New_Customer_Emails_1_1

 

James

Can't see how they would cause it. Go with tapuahk suggestions.

[Reeselectronics]

GOOD GOD!! :) i found someone else since 2005 that has the same exact problem (sorry if i am too dramatic)

 

i tried every solution on the internet (not that many)

 

Problem: when a client creates a new account it registers successfully the customer is able to shop and track etc... , however if the client closes the browser and opens a new session, the client can no longer log in and this error shows up: No match for E-Mail Address and/or Password. and when the client retrieves a new password through thier email address that doesnt work ethier.

 

addons: PWA

New_Customer_Emails

Header_tags

SEOURLS

Fancier invoice

 

for a better self explained idea check it out live http://www.digitaltranscriptionstore.com

 

Please help if able

 

Thank you

[tapuahk]

GOOD GOD!! :) i found someone else since 2005 that has the same exact problem (sorry if i am too dramatic)

 

i tried every solution on the internet (not that many)

 

Problem: when a client creates a new account it registers successfully the customer is able to shop and track etc... , however if the client closes the browser and opens a new session, the client can no longer log in and this error shows up: No match for E-Mail Address and/or Password. and when the client retrieves a new password through thier email address that doesnt work ethier.

 

addons: PWA

New_Customer_Emails

Header_tags

SEOURLS

Fancier invoice

 

for a better self explained idea check it out live http://www.digitaltranscriptionstore.com

 

Please help if able

 

Thank you

 

Yes, it definitely sounds like it is a problem with the creation and/or store of the hashed password. It may be a change made to the database under one of the mods or a modification of the original create account file...

 

~~~Tapuahk

[meil2000]

Yes, it definitely sounds like it is a problem with the creation and/or store of the hashed password. It may be a change made to the database under one of the mods or a modification of the original create account file...

 

~~~Tapuahk

 

I have the same problem. I also applied PWA addon. Does anyone have a fix?

 

Thank you!

[meil2000]

I have the same problem. I also applied PWA addon. Does anyone have a fix?

 

Thank you!

 

 

I think I found a fix. It works for me. In \catalog\login.php, found the following code block (if you applied PWA, you should have it).

 

// PWA BOF

// using customers_login instead of customers_email_address

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_login = '" . tep_db_input($email_address) . "'");

// PWA EOF

 

Replace "where customers_login = " with "where customers_email_address = ".

[wimteapots]

If you have installed one of the later versions of PWA it adds a field that includes the user-id: customers_login. At login this is now used, rather than the email_address that was used before to log in. What the PWA install doesn't tell that in some circumstances still the email_adress is used. Also for all existing customers the new field customers_login is of course not filled. You will have to run an SQL query that copies the email_address into the customers_login field and existing customer should be able to login as before (that worked for me, password reset also worked once more). Reverting back to the email_address for login wil in effect kill the PWA solution as that relies on the customers_login to remain NULL if the customer uses PWA.

 

Hope this makes sense. I was lucky to find this quickly.

[skhuu]

I think I found a fix. It works for me. In \catalog\login.php, found the following code block (if you applied PWA, you should have it).

 

// PWA BOF

// using customers_login instead of customers_email_address

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_login = '" . tep_db_input($email_address) . "'");

// PWA EOF

 

Replace "where customers_login = " with "where customers_email_address = ".

 

I had the same problem and this fixed it for me. can now login wthout any problems.

 

Thanks!!

[9827579]

If you have installed one of the later versions of PWA it adds a field that includes the user-id: customers_login. At login this is now used, rather than the email_address that was used before to log in. What the PWA install doesn't tell that in some circumstances still the email_adress is used. Also for all existing customers the new field customers_login is of course not filled. You will have to run an SQL query that copies the email_address into the customers_login field and existing customer should be able to login as before (that worked for me, password reset also worked once more). Reverting back to the email_address for login wil in effect kill the PWA solution as that relies on the customers_login to remain NULL if the customer uses PWA.

 

Hope this makes sense. I was lucky to find this quickly.

 

Here's the sql command:

 

UPDATE `customers` SET `customers_login` = customers_email_address WHERE `customers_password` IS NOT NULL;

 

Have fun!

[galey1981]

Here's the sql command:

 

UPDATE `customers` SET `customers_login` = customers_email_address WHERE `customers_password` IS NOT NULL;

 

Have fun!

 

Did this problem get fixed in more recent versions of PWA?? I had the same thing and found this thread useful - wondered if this was ever factored into new releases?