Did you install the SQL patch ?
Did you install the SQL patch ?
That is the error I'm getting with the sql file that came with the plugin.
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.
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...)"
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?
Last edited by charmlt; 15 Mar 2015 at 10:04 AM.
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..
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?
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
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
Last edited by Hannat; 23 Mar 2015 at 09:45 AM.
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
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Bookmarks