Password Reset Link for Customer Doesn't Change PW

[Sam-AUST]

Hi guys,

          I actually forgot the password to my test account for this new site I'm working on, so requested a password change. I received the link just fine and it goes through the motions of changing the password, but I can't login with the new password. I've changed it twice now, it's just not happening.

 

Has anyone experienced the same? This could be a nightmare once we actually start selling.

[♥kymation]

What version of osCommerce? There was a bug in the Password Reset in some older versions.

 

Regards

Jim

[Sam-AUST]

It's the latest oscommerce bootstrap version, I did a version check and it definitely says the latest.

 

I registered a new account and then immediately reset the password, which worked, it seems almost like the first test account was corrupted somehow. The only thing I did with the first account was put through a test order, which I then used to change the order number (and the order disappeared) - but would that action corrupt the account?

[♥kymation]

How did you change the order number? There are multiple database tables linked to that number. If you didn't make all of the changes, you corrupted your database.

 

I can see the result being that the order is no longer visible, but I don't see how that would affect the password. I need to take a closer look at that.

 

Regards

Jim

[Sam-AUST]

The instructions on changing the order number only show one change to make - are there others I should be aware of or anything else I need to do now to avoid problems?

 

 

Note: I placed an order on a test account, then went to orders on the database and changed the order number by editing it. Then I placed another test order to make sure the number went up as it should (and it did).

[♥kymation]

The orders_id is used in the orders, orders_products, orders_products_attributes, orders_products_downloads, orders_total, and orders_status_history tables. Not all of those will have data for every order, but the ones that do would all need to be changed or there will be problems with that order. All future orders should be OK, so it probably doesn't matter if the one you changed was a test order.

 

As always when making changes to the database, backup your database before you change anything.

 

If you want to know what fields are used to link the tables in the database, find the database_schema.pdf in the docs folder in your osCommerce download.

 

Regards

Jim

[Sam-AUST]

Thank you for the advice, much appreciated