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?
Latest News: (loading..)
1054 - Unknown column 'password_reset_key' in 'field list'
Started by tonyc49, Aug 22 2012 10:45 PM
7 replies to this topic
#1
Posted 22 August 2012 - 10:45 PM
#3
Posted 23 August 2012 - 12:51 AM
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.
Thanks again.
#5
Posted 23 August 2012 - 01:46 AM
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
alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;
Tony
#6
Posted 27 August 2012 - 11:15 AM
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
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
#7
Posted 28 August 2012 - 06:05 AM
Issue fixed. Thanks any way
#8
Posted 24 April 2013 - 03:19 PM
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
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!









