bislewl:
Something must have went wrong with the auto-installer.
in the admin choose the last item in the configuration.
In the address bar will be gID=xx
increase/decrease the xx and you should see it.
Then for easy access next time in your DB, TABLE_ADMIN_PAGES. look for the entry for Fast & Easy Checkout and change the parameter to gID=YY
That usually does the trick.
I'm trying to get a stable test setup of ZC 1.5.3 before converting my live site.
I've committed to using Numinix Tableau as the theme and a small set of plugins to support it. So far I've installed Edit Orders (EO), Super Orders (SO), Add New Customer (ANC), Reset Client Password From Admin (RCP), OzPost MultiQuote (OZPost). These all worked fine until I installed Fast And Easy Checkout (FEC/FEAC).
My first attempt to install FEAC seemed successful - it appeared in the configuration menu - but I then encountered difficulties with OZPost and to diagnose the problems I disabled FEAC by running the uninstaller from the package (pasted into SQL patcher). Returning to the Configuration menu (which should have run the installer) showed the FEC entry was missing. I've since run the uninstaller a couple of times, merged the various files and code snippets a couple of times without success before embarking on the exploration described below. (Sorry about the long post - there's no happy ending yet, but some partial success which may help you).
I then examined the scripts and database structure for clues. Firstly, it seems there is a history of name changes in the configuration options which hasn't been carried through. Some options are prefixed FEC others FEAC. The uninstaller seems to fail for this reason.
Secondly, I could find no entry in the ADMIN_PAGES table. It isn't being inserted so it's not appearing in the Configuration Menu. It was created the first time I installed but not since, so I'm guessing there's some rogue process blocking it. Perhaps the Uninstaller isn't a complete cleaner.
This is the uninstall script from the FEC/FEAC v1.15.3 package:
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration
WHERE configuration_key= 'FAST_AND_EASY_CHECKOUT_VERSION'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM admin_pages WHERE page_key = 'configFastandEasyCheckout' LIMIT 1;
I have only a rudimentary understanding of SQL but this is what I think it does:
- Three tables will be affected.
- The CONFIGURATION table is searched for a record where the configuration_key field contains 'FAST_AND_EASY_CHECKOUT_VERSION'.
- The corresponding configuration_group_id (i.e. the 'gID') is then retrieved and used to find and delete relevant records in the tables: CONFIGURATION, CONFIGURATION_GROUP and ADMIN_TABLE_PAGES.
When I look in my CONFIGURATION table there is no record with the configuration_key='FAST_AND_EASY_CHECKOUT_VERSION' - but there is a configuration_key='FEAC_VERSION'
Running the uninstaller with that change actually does work as expected (I checked result via phpMyAdmin) but now, when I try to access admin I get this message:
WARNING: An Error occurred, please refresh the page and try again.
The error log shows this:
PHP Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /blah/admin/includes/functions/extra_functions/nmx_disk_cache.php on line 8
PHP Fatal error: 1060 Duplicate column name 'COWOA_account' :: ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0; ==> (as called by) /blah/admin/includes/installers/fec/1_12_0.php on line 29 <== in /blah/includes/classes/db/mysql/query_factory.php on line 155
Presumably the FEC installer is trying to run but then dies when it encounters the pre-existing field (how it is created before the FEAC script does I don't yet know).
If I run the uninstaller script, then delete the COWOA _account column (via phpMyAdmin), then try to access Admin I still get the error. There must be a mechanism that prevents auto-installer scripts from running every time you make a menu selection, but I don't know what it is where to find it nor how to disable / reset it.
Not sure where to go from here.
