Reset customer password from admin

Hannat:

Ok,

I figured out that the reason it isn't changing the password is because after hitting "Submit Query" it will find the customer but when you click on "Change Password" the page that is loaded is 'blank'. The customer is no longer selected, so typing in a password there won't do anything.

Any help here?

Regards, Hannat

Blank/partial blank: http://www.zen-cart.com/content.php?124-blank-page

mc12345678:

Blank/partial blank: http://www.zen-cart.com/content.php?124-blank-page

Let me rephrase. The page isn't blank, the page loads perfectly. The fields that should have my selected customer's details in are blank.

Sorry about that.

Maybe I am not making any sense.

Once I have selected a customer, via searching for them using their email address, and clicking "Change Password" when the page reloads this is what I see.

Attachment #15081

As you can see the customer name and customer email is blank, so entering a new password doesn't do anything as no customer is selected.

Some help would be appreciated.

Regards, Hannat

Be sure all of the plugin files have uploaded correctly. Corrupt uploads can happen. Anything in the error logs?

I'm having the same issue. I've found that it only occurs when using the search function (which does some pretty weird things). If you page through and select from the list of customers, everything seems to work. So problem is in the search. I've been looking through the code but haven't found the problem yet.

Okay, found the problem and fixed it. I've submitted an update to this plug-in.

batracy:

Okay, found the problem and fixed it. I've submitted an update to this plug-in.

Can you share what the fix was. This is also kept on Github so would like to update there too.

There were about four changes made to the passchange.php file in the admin folder. No other folders or files were changed.

First change was to move the line that sets the $customers_id variable outside the block and moved it up with the other items getting passed variables and information as follows:

  $passchangeCust = (DB_PREFIX.'customers');
  $customers_id = (isset($_GET['cID']) ? zen_db_prepare_input($_GET['cID']) : '');

  if (zen_not_null($action)) {
    switch ($action) {

Second change was to add an elseif where the passchange_query_raw variable is set as follows:

 if ($searchemail){
		$passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_email_address='$searchemail'";
  }elseif ($customers_id){
		$passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_id='$customers_id'";
  }else{
		$passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";
  }

The other two changes were just to make sure the cID variable is not passed when the users presses the Cancel button.

charmlt:

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h? Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

I have the same issue on a site running 1.39h. No search box - and upgrading this site is not an option. Anybody have any ideas?

RescoCCC:

I have the same issue on a site running 1.39h. No search box - and upgrading this site is not an option. Anybody have any ideas?

Problem solved. Just upload the files from the 1.5x folder. Works perfectly.

I just installed Reset--Customer-Password on Zen Cart 1.5.4.
I changed the admin folder name to my admin folder name.
I copied pasted and sent the SQL add_admin_menu_entry-v15xsql

Either it didn't work or I just don't know where to find it.
Can someone tell me where it is suppose to be.
k

ken1:

I just installed Reset--Customer-Password on Zen Cart 1.5.4.
I changed the admin folder name to my admin folder name.
I copied pasted and sent the SQL add_admin_menu_entry-v15xsql

Either it didn't work or I just don't know where to find it.
Can someone tell me where it is suppose to be.
k

What version of Zen Cart do you have?
Where did paste teh sql file? It should have been in Tools>Install SQL Patches

The Zen Cart version is 1.5.4 and yes the patch was installed in Tools>SQL Patches

If I recall, a Change Passwords option is added the the Tools menu.

Thanks.
You are right. I didn't know where to look. I found it under tools and it works.
I appreciate the help.
ken

I did this, everything loaded OK, but the Master password returns this error

Error: Sorry, there is no match for that email address and/or password.

stevesh:

Copy and paste the contents of pass.sql into Admin - Tools - Install SQL Patches then click Send.

Then drag and drop the 'includes' folder in the mod to the root dirctory of your site.

I went to MY Store and changed the Master Password, but it is not working. Any ideas?

johnniejetski:

I went to MY Store and changed the Master Password, but it is not working. Any ideas?

This is not the master password support thread. This plugin resets customer passwords.

@jeking, just wanted to report a bugfix to you. I'm using Admin Profiles, and realized that enabling 'Change Customer Password' from the profile editor did not actually give access to my client's admin account. I found that the page key had a capital 'C' (passChange), but it should be lowercase to allow access to passchange.php.

Here is the updated SQL that worked for me:

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passchange', 'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

jackie.taferner:

@jeking, just wanted to report a bugfix to you. I'm using Admin Profiles, and realized that enabling 'Change Customer Password' from the profile editor did not actually give access to my client's admin account. I found that the page key had a capital 'C' (passChange), but it should be lowercase to allow access to passchange.php.

Here is the updated SQL that worked for me:

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passchange', 'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

Thanks for the report and the fix.