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..)
1
7 replies to this topic
#2
Posted 22 August 2012 - 11:10 PM
@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
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
:|: Was this post helpful ? Click the LIKE THIS button :|:
See my Profile (click here) for more information and to contact me for professional osCommerce support that includes custom templates, add ons as well as cart leasing and support plans.
See my Profile (click here) for more information and to contact me for professional osCommerce support that includes custom templates, add ons as well as cart leasing and support plans.
#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.
#4
Posted 23 August 2012 - 12:59 AM
@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
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
:|: Was this post helpful ? Click the LIKE THIS button :|:
See my Profile (click here) for more information and to contact me for professional osCommerce support that includes custom templates, add ons as well as cart leasing and support plans.
See my Profile (click here) for more information and to contact me for professional osCommerce support that includes custom templates, add ons as well as cart leasing and support plans.
#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
#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!
