PWA - Purchase Without Account lost password issue

[tony@networld]

I'm not sure if this has affected anyone else who has installed this popular add-on, but somewhere along the lines (various updates to the add-on) there has been a change in the negative value of guest_account - from 'NULL' to '0'. If, like me you experienced the problem below, you may want to look at the guest_account field values in your db customers table to see if you have NULL's as well as '0's...

 

Problem:

If an existing customer loses/forgets his password and goes through the password forgotten sequence, he will get a message saying 'Success: A new password has been sent to your e-mail address.' Yet when he tries to login with the new password, he gets 'Error: No match for E-Mail Address and/or Password.'

 

Solution:

SQL query to update all guest_account field values from NULL to 0...

 

UPDATE `customers` SET `guest_account` = '0' WHERE `guest_account` IS  NULL;

 

It should be noted that this is not the only reason why a new password does not allow access - there are other reasons, which are documented elsewhere.