7 replies to this topic

[tonyc49]

When anyone tries to login to my site, they get this error

1054 - Unknown column 'password_reset_key' in 'field list'
update customers_info set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1, password_reset_key = null, password_reset_date = null where customers_info_id = '2'

They are successfully logged in but the first must hit the back key.

My site is hosted through Bluehost and I am using osCommerce version 2.3.3 (Stable).

Can anyone please help me?

[DunWeb]

@tonyc49

Did you update the store to v2.3.3 from a previous version ?  It would appear you did not perform all of the steps, which could either running the database query or alter the filenames.php



Chris

[tonyc49]

Thanks for your reply Chris. I did upgrade from v2.3.1 but this issue appeared before the upgrade. The upgrade was done only to see if it would resolve this. I will check to see that I have completed all the steps and update you.
Thanks again.

[DunWeb]

@tonyc49

The table that the site is asking for was only introduced with the v2.3.2 upgrade.  Check the upgrade guide again and make the appropriate corrections.



Chris

[tonyc49]

Thanks again Chris. I ran the following queries and the problem is resolved.

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;

Tony

[newOSuser007]

tonyc49, on 23 August 2012 - 01:46 AM, said:

Thanks again Chris. I ran the following queries and the problem is resolved.

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;

Tony

HI Tony.

I have the same problem.
Can you please tell me how did you run those above queries?
I have no idea about this. Please help.

Thanks

James

[newOSuser007]

Issue fixed. Thanks any way

[alhawnah]

tonyc49, on 23 August 2012 - 01:46 AM, said:

Thanks again Chris. I ran the following queries and the problem is resolved.

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;

Tony

Thank you Tony. This solved my problem, too. Version 2.3.3. password_reset_key was no where to be found in my database. Added via MySQL Workbench and all is well. Thank you!