Jump to content



Photo
- - - - -

1054 - Unknown column 'password_reset_key' in 'field list'


  • Please log in to reply
18 replies to this topic

#1   tonyc49

tonyc49
  • Members
  • 6 posts
  • Real Name:Tony Correia

Posted 22 August 2012 - 22:45

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?

#2   DunWeb

DunWeb

    The Censored One

  • Members
  • 13,084 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Ontario, Canada

Posted 22 August 2012 - 23:10

@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
:|: Was this post helpful ? Click the LIKE THIS button :|:

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

#3   tonyc49

tonyc49
  • Members
  • 6 posts
  • Real Name:Tony Correia

Posted 23 August 2012 - 00:51

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.

#4   DunWeb

DunWeb

    The Censored One

  • Members
  • 13,084 posts
  • Real Name:Chris
  • Gender:Male
  • Location:Ontario, Canada

Posted 23 August 2012 - 00:59

@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
:|: Was this post helpful ? Click the LIKE THIS button :|:

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

#5   tonyc49

tonyc49
  • Members
  • 6 posts
  • Real Name:Tony Correia

Posted 23 August 2012 - 01:46

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

#6   newOSuser007

newOSuser007
  • Members
  • 3 posts
  • Real Name:James
  • Gender:Male

Posted 27 August 2012 - 11:15

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

#7   newOSuser007

newOSuser007
  • Members
  • 3 posts
  • Real Name:James
  • Gender:Male

Posted 28 August 2012 - 06:05

Issue fixed. Thanks any way

#8   alhawnah

alhawnah
  • Members
  • 2 posts
  • Real Name:Marsha Doty

Posted 24 April 2013 - 15:19

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!

#9   AusFiero

AusFiero
  • Members
  • 25 posts
  • Real Name:Jim Davis
  • Gender:Male
  • Location:Dapto Australia

Posted 15 July 2013 - 01:14

I have tried this to resolve the issue and I still get this message.
1054 - Unknown column 'password_reset_key' in 'field list'

update customers_info set password_reset_key = 'rnayxVnvLamwdq0xr92LTAtK6kABcQNfSg352722', password_reset_date = now() where customers_info_id = '4'


Any ideas? I updated includes/filenames.php and ran
alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;
on my database.

#10   optikior

optikior
  • Members
  • 1 posts
  • Real Name:stefane borg

Posted 15 July 2013 - 19:13

here a simple way to solve this problem ,you need to add this line in the login files ,you should edit the file.

tep_session_register('customer_country_id');
tep_session_register('customer_zone_id');
header('Location:http://YOUR.WEBSITE.HERE');
tep_db_query("update " . TABLE_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 = '" . (int)$customer_id . "'");

#11   MrPhil

MrPhil
  • Members
  • 5,323 posts
  • Real Name:Phil
  • Gender:Male

Posted 16 July 2013 - 14:15

I ran

alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;
on my database.

Go into phpMyAdmin, browse the table (customers_info) structure, and confirm that your two added fields show up. If you're getting a 1054 error, you probably didn't add them correctly.

#12   ProPhotoShop

ProPhotoShop
  • Members
  • 4 posts
  • Real Name:Aleksandr
  • Gender:Male

Posted 23 October 2013 - 14:23

Go into phpMyAdmin, browse the table (customers_info) structure, and confirm that your two added fields show up. If you're getting a 1054 error, you probably didn't add them correctly.

Can anybody tell in human language HOW :

"The following database queries must be performed
alter table customers_info add password_reset_key char(40);
alter table customers_info add password_reset_date datetime;"

???

I found in guide - https://github.com/o....1...upgrade232
that I have to place this 2 fields into file catalog/install/oscommerce.sql,
but I DONT HAVE "Install" directory !!!
please tell me WHERE I need to place it? in which directory in which file ?
Thank you

#13   MrPhil

MrPhil
  • Members
  • 5,323 posts
  • Real Name:Phil
  • Gender:Male

Posted 23 October 2013 - 15:41

If you have already installed osC, adding that to oscommerce.sql isn't going to do anything for you (it's only used for the initial install). You may no longer have an "install" directory or the file in question, once you've completed installation. You can certainly browse around your site and see if you can find it, perhaps in a different place, but don't count on finding it.

Find out from your host where to find phpMyAdmin and how to run it. It's possible that your host offers something else instead of phpMyAdmin, in which case you'll have to ask them how to do this. You have two choices once you're in phpMyAdmin: you can go to the SQL tab and enter the "alter" command where it says to enter an SQL statement (do the two alters separately) and press "Go". That's probably the easier way. The second way is to go into the Structure tab (for table customers_info) and see where you can add a new field, with name password_reset_key, type character, length 40 (and similar for the second field).

#14   ProPhotoShop

ProPhotoShop
  • Members
  • 4 posts
  • Real Name:Aleksandr
  • Gender:Male

Posted 24 October 2013 - 05:48

Thank you , I fix it :
go to:
phpMyAdmin
customers_info/ page
SQL/ table
alter table customers_info add password_reset_key char(40);
GO

#15   ebbeee

ebbeee
  • Members
  • 4 posts
  • Real Name:Emelie Backman

Posted 06 February 2014 - 12:44

Hello! I have this same problem but this doesn't fix it for me!

A little help please?

I am a beginner at this so as detaild as possible thanx!

#16   MrPhil

MrPhil
  • Members
  • 5,323 posts
  • Real Name:Phil
  • Gender:Male

Posted 06 February 2014 - 14:43

What did you try doing? Go into phpMyAdmin and look to see if those two fields are in the table (browse structure). If not, you have to follow the above instructions for adding the two fields.

#17   ebbeee

ebbeee
  • Members
  • 4 posts
  • Real Name:Emelie Backman

Posted 07 February 2014 - 13:04

The two lines are there but i still get the error 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 = '1'

[TEP STOP]


The cosumers are logged in when they click on the return button from this message, but i need to remove this message and don't know how.

Edited by ebbeee, 07 February 2014 - 13:07.


#18   MrPhil

MrPhil
  • Members
  • 5,323 posts
  • Real Name:Phil
  • Gender:Male

Posted 07 February 2014 - 14:06

"The two lines are there but..." means what? Did you go into phpMyAdmin and browse the structure of the table, and it shows the two new fields are in there? Or did you just add the lines to .sql (which will do nothing)? If the two new fields are not in the table, you didn't add them correctly.

#19   swcharlie

swcharlie
  • Members
  • 24 posts
  • Real Name:Schalk
  • Gender:Male

Posted 11 July 2014 - 15:47

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 , I fix it :
go to:
phpMyAdmin
customers_info/ page
SQL/ table
alter table customers_info add password_reset_key char(40);
GO

 

This worked, thanks.