kyusho77 Posted May 30, 2015 Share Posted May 30, 2015 Hi all, I was contacted by one of my customers telling me that she can't login into her account. I've created an account and when I wanted to login myself as a customer I got this message: 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 = '7617'[TEP STOP] Any ideas what happened? I just bought this site a week ago but the seller is not getting back to me to help me to sort this out as was promised before we made a deal. Can anyone help please? Just tell me what should I do but in plain English please, as I never dealt with osCommerce before. Thanks a lot, guys. Link to comment Share on other sites More sharing options...
tgely Posted May 30, 2015 Share Posted May 30, 2015 Hi, you had an old version of v2.3.1 but somebody missed the updates to next v2.3.2 version. Check the updates. http://library.oscommerce.com/Online&en&oscom_2_3&release_notes&v2_3_2 osCommerce based shop owner with minimal design and focused on background works. When the less is more.Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store. Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 Hi, you had an old version of v2.3.1 but somebody missed the updates to next v2.3.2 version. Check the updates. http://library.oscommerce.com/Online&en&oscom_2_3&release_notes&v2_3_2 HI, Thanks for your reply. Do you mean I have to update my site to the latest version and it will fix it? Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 I've just checked. I've got the latest version v2.3.4 Link to comment Share on other sites More sharing options...
Hotclutch Posted May 30, 2015 Share Posted May 30, 2015 I think the problem may be that the previous owner tried to update an old osCommerce, but missed a few steps. Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 Could be, but how to get it right? Any ideas anyone? Link to comment Share on other sites More sharing options...
Hotclutch Posted May 30, 2015 Share Posted May 30, 2015 You have got to look at the code you have got and compare it to the updates already given above. Nobody can say anything else different with the information at hand. Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 When tried to reset the password got this message: 1054 - Unknown column 'password_reset_key' in 'field list'update customers_info set password_reset_key = 'U5rXKM5o8p94c2uYHawq2ihJ6MJBeV9yFPgkt7eU', password_reset_date = now() where customers_info_id = '7617'[TEP STOP] Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 You have got to look at the code you have got and compare it to the updates already given above. Nobody can say anything else different with the information at hand. You mean the code that I have to the code that suppose to be? That makes sense. Where can I find these files to compare? Link to comment Share on other sites More sharing options...
Hotclutch Posted May 30, 2015 Share Posted May 30, 2015 Click on the link above that Gergely gave. Link to comment Share on other sites More sharing options...
kyusho77 Posted May 30, 2015 Author Share Posted May 30, 2015 OK. Thanks. Gonna look at it now. Link to comment Share on other sites More sharing options...
Wal Posted September 29, 2015 Share Posted September 29, 2015 Posted 30 May 2015 - 23:53 I've just checked. I've got the latest version v2.3.4 Hi Kyusho77 I had this problem with V2.3.4 as well, but this fix from 2012 solved the problem. Check your database for the two values in customer_info & if they are not there just run the two SQL queries in this link. PS - tonyc49 at post #5 is the answer http://www.oscommerce.com/forums/topic/388828-1054-unknown-column-password-reset-key-in-field-list/ Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.