Reset customer password from admin

[stevesh]

Did you install the SQL patch ?

[CarlC]

That is the error I'm getting with the sql file that came with the plugin.

[designsbytrina]

I'm having the same problem when I try to run the adminplacementv15.sql patch on ZC 1.5.1, I get:

Error ERROR: Cannot execute because table admin_pages(page_key, does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I've tried changing the prefix to my db name, same error, only then it says MYDBNAME_admin_pages does not exist.

[designsbytrina]

Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql

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');

The original one left out the space between "admin_pages" and "(page_key...)"

[pricediscrimination]

Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql

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');

The original one left out the space between "admin_pages" and "(page_key...)"

Thank you very much for this! After an hour of trying this was the remedy. It should probably be changed in the file before others get caught up with the same issue.

[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?

[mc12345678]

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?

Best guess is that something about the 1.3.9 code is different from the 1.5.4 code such as the name of the function to call for the search box, or the sequence of some internal variables is different. I realize not a highly technical response, but see below..

Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

The real question is shouldn't I be upgrading a 1.3.9 site to the latest version so that when the host no longer offers PHP 5.2.17 possibly later this year that the site will still operate?

[Hannat]

Hi there guys,

So I installed everything fine with no errors. Installed the SQL patch too, no problem there. Searched for a customer (used my testing account) and reset my password. But the new password doesn't work. Anyone else have this issue or have a solution?

Regards, Hannat

Edit:

Using: Zen Cart v1.5.4, PHP Version 5.4.33 and my DB doesn't have prefixes

[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

[mc12345678]

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