COWOA (for ZC v1.5.x)

DivaVocals:

Just so you know, it will be a while.. Pretty busy right now with paid work.. That's why I published the code on Github..
Earning money is always best... thanks for the info

Hello,

I recently installed COWOA on my new Zencart empty database of 1.5.1, and ran the new SQL install. I made an error and wanted to remove it, so I ran the SQL un-install. when I did I keep getting this message. (WARNING: An Error occurred, please refresh the page and try again.) I have tried refreshing but no luck, can anyone help me. I am stuck with COWOA not working and it kind of installed on the admin.

gokeypa:

Hello,

I recently installed COWOA on my new Zencart empty database of 1.5.1, and ran the new SQL install. I made an error and wanted to remove it, so I ran the SQL un-install. when I did I keep getting this message. (WARNING: An Error occurred, please refresh the page and try again.) I have tried refreshing but no luck, can anyone help me. I am stuck with COWOA not working and it kind of installed on the admin.Happy to help if you give more information..

• Need to know what error you got in the error logs
• Need to know what version of COWOA you installed

Finally..

WHY are you installing this on a fresh copy of v1.5.1 when v1.5.4 is the latest greatest version available??

Thanks, here are the answers to the questions you asked.
Error log, see below:
COWOA version is 2.4
I am using 1.5.1 because I am on godaddy, and that is the version that they have in there install center. I think that if there is an issue with zencart it's self godaddy will be more helpfull if I can say that I used there copy of zencart, at least I think so.

Error log.
[24-Apr-2015 09:41:25] PHP Fatal error: 1062:Duplicate entry 'COWOA_STATUS' for key 2 :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'COWOA', 'COWOA_STATUS', 'false', 'Activate COWOA Checkout? <br />Set to True to allow a customer to checkout without an account.', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Turn Off Sideboxes During Checkout', 'COWOA_SIDEBOX_OFF', 'false', 'Turn off sideboxes during checkout? <br /><br />Customers should be focused on completing the sale once they start the checkout process. It is a recommended practice that sideboxes should be turned off to help minimize customer distractions during checkout. Many of the larger e-commerce retailers turn off "distractions" during their checkout processes for the same reason - i.e. Amazon. By reducing customer distractions during checkout you can help to decrease cart abandonment, and to increase sales conversions.<br /><br />Set to True to turn off the following sideboxes during checkout:<br /><ul><li>account_history_info (Order Information)</li><li>account_newsletters (Newsletter Subscriptions)</li><li>account_notifications (Product Notifications)</li><li>account_password (My Password)</li><li>address_book (My Personal Address Book)</li><li>address_book_process (New Address Book Entry)</li><li>checkout_confirmation (Confirmation/Order Review)</li><li>checkout_payment (Payment Method/Payment Information)</li><li>checkout_payment_address (Change Billing Address/Change the Billing Information)</li><li>checkout_process (submits the order)</li><li>checkout_shipping (Shipping Method/Shipping Information)</li><li>checkout_shipping_address (Change Shipping Address/Change the Shipping Address)</li><li>create_account (Create Account/My Account Information)</li><li>login (Login)</li><li>logoff Logoff)</li><li>no_account (COWOA Billing Information)</li><li>shopping_cart (Shopping Cart)</li></ul>', @t4, 12, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable Order Status', 'COWOA_ORDER_STATUS', 'false', 'Enable The Order Status Function of COWOA?<br />Set to True so that a Customer that uses COWOA will receive an E-Mail with instructions on how to view the status of their order.', @t4, 14, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable E-Mail Only', 'COWOA_EMAIL_ONLY', 'false', 'Enable The E-Mail Order Function of COWOA?<br />Set to True so that a Customer that uses COWOA will only need to enter their E-Mail Address upon checkout if their Cart Balance is 0 (Free).', @t4, 16, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable Forced Logoff', 'COWOA_LOGOFF', 'false', 'Enable The Forced LogOff Function of COWOA?<br />Set to True so that a Customer that uses COWOA will be logged off automatically after a sucessfull checkout. If they are getting a file download, then they will have to wait for the Status E-Mail to arrive in order to download the file.', @t4, 18, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'); in /home/content/g/o/k/gokeypa/html/siecurewine/cart/includes/classes/db/mysql/query_factory.php on line 120

DivaVocals:

If you read through the last 2-3 pages of this thread or search for "1.5.4", you'll this question has been addressed..
On a side note, I've been running into this a few times now, trying to search for "1.5.4" and nothing comes up. Any hint on how this darn Thread Search works so I can filter/search for 1.5.4 compatibility?

gokeypa:

Thanks, here are the answers to the questions you asked.
Error log, see below:
COWOA version is 2.4
I am using 1.5.1 because I am on godaddy, and that is the version that they have in there install center. I think that if there is an issue with zencart it's self godaddy will be more helpfull if I can say that I used there copy of zencart, at least I think so.

Error log.
[24-Apr-2015 09:41:25] PHP Fatal error: 1062:Duplicate entry 'COWOA_STATUS' for key 2 :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'COWOA', 'COWOA_STATUS', 'false', 'Activate COWOA Checkout? <br />Set to True to allow a customer to checkout without an account.', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Turn Off Sideboxes During Checkout', 'COWOA_SIDEBOX_OFF', 'false', 'Turn off sideboxes during checkout? <br /><br />Customers should be focused on completing the sale once they start the checkout process. It is a recommended practice that sideboxes should be turned off to help minimize customer distractions during checkout. Many of the larger e-commerce retailers turn off "distractions" during their checkout processes for the same reason - i.e. Amazon. By reducing customer distractions during checkout you can help to decrease cart abandonment, and to increase sales conversions.<br /><br />Set to True to turn off the following sideboxes during checkout:<br /><ul><li>account_history_info (Order Information)</li><li>account_newsletters (Newsletter Subscriptions)</li><li>account_notifications (Product Notifications)</li><li>account_password (My Password)</li><li>address_book (My Personal Address Book)</li><li>address_book_process (New Address Book Entry)</li><li>checkout_confirmation (Confirmation/Order Review)</li><li>checkout_payment (Payment Method/Payment Information)</li><li>checkout_payment_address (Change Billing Address/Change the Billing Information)</li><li>checkout_process (submits the order)</li><li>checkout_shipping (Shipping Method/Shipping Information)</li><li>checkout_shipping_address (Change Shipping Address/Change the Shipping Address)</li><li>create_account (Create Account/My Account Information)</li><li>login (Login)</li><li>logoff Logoff)</li><li>no_account (COWOA Billing Information)</li><li>shopping_cart (Shopping Cart)</li></ul>', @t4, 12, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable Order Status', 'COWOA_ORDER_STATUS', 'false', 'Enable The Order Status Function of COWOA?<br />Set to True so that a Customer that uses COWOA will receive an E-Mail with instructions on how to view the status of their order.', @t4, 14, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable E-Mail Only', 'COWOA_EMAIL_ONLY', 'false', 'Enable The E-Mail Order Function of COWOA?<br />Set to True so that a Customer that uses COWOA will only need to enter their E-Mail Address upon checkout if their Cart Balance is 0 (Free).', @t4, 16, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Enable Forced Logoff', 'COWOA_LOGOFF', 'false', 'Enable The Forced LogOff Function of COWOA?<br />Set to True so that a Customer that uses COWOA will be logged off automatically after a sucessfull checkout. If they are getting a file download, then they will have to wait for the Status E-Mail to arrive in order to download the file.', @t4, 18, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'); in /home/content/g/o/k/gokeypa/html/siecurewine/cart/includes/classes/db/mysql/query_factory.php on line 120

Yes, the issue is with the installer file:
The changes haven't been applied to the module but see my changes here:
https://github.com/bislewl/zen_COWOA/commit/556da4b1765dab1774826e4b1d5aea16ab864b53

Also, you SHOULD not use the godaddy installers, perform a regular install. I have had nothing but problems with their zencart installs.

bislewl:

Yes, the issue is with the installer file:
The changes haven't been applied to the module but see my changes here:
https://github.com/bislewl/zen_COWOA/commit/556da4b1765dab1774826e4b1d5aea16ab864b53
and you submitted a PR to the main repo I have been directing people to when??????????????? (not bustn' your chops.. but IJS..:laugh:)

DivaVocals:

and you submitted a PR to the main repo I have been directing people to when??????????????? (not bustn' your chops.. but IJS..:laugh:)

I think I already did. But in my last download it wasn't there. Maybe I'm wrong and it has been updated since then...

Tried my luck merging Z1.5.4 with the zen_COWOA-master from github. After merging I proceeded with uploading and wanted to process the COWOA_Full_Install.sql as outlined in the doc. But there is no COWOA_Full_Install.sql. Well I tried the COWOA_Full_Install.sql from the mod in the plugin section and proceeded. No luck. Ether my merge failed or sql was not working. I do have the Configuration COWOA entry in admin but the page comes up blank. Any hints?

bislewl:

I think I already did. But in my last download it wasn't there. Maybe I'm wrong and it has been updated since then...I'll check.. :smile: I asked because you pointed him to your fork versus the main repo.. made me wonder if you did this because you hadn't submitted your changes a PR..

Sorry folks, I am not following. Is there a complete (beta) mod that should be working on 1.5.4 with a correct SQL to install?

mydanilo:

Tried my luck merging Z1.5.4 with the zen_COWOA-master from github. After merging I proceeded with uploading and wanted to process the COWOA_Full_Install.sql as outlined in the doc. But there is no COWOA_Full_Install.sql. Well I tried the COWOA_Full_Install.sql from the mod in the plugin section and proceeded. No luck. Ether my merge failed or sql was not working. I do have the Configuration COWOA entry in admin but the page comes up blank. Any hints?

mydanilo:

Sorry folks, I am not following. Is there a complete (beta) mod that should be working on 1.5.4 with a correct SQL to install?

The COWOA repo on Github IS the beta version for Zen Cart v1.5.4.. there is no separate install SQL file because it uses an auto installer.. suggest running the uninstall SQL file, and trying your install again..

https://github.com/DivaVocals/zen_COWOA

mydanilo:

Sorry folks, I am not following. Is there a complete (beta) mod that should be working on 1.5.4 with a correct SQL to install?

I have a beta up for 1.5.4 that working for me, but it's getting a bit off track with the current COWOA so dropped the fork. Haven't fully tested on clean installs or packaged instructions. The sql is auto install/removed which I'll be changing how that works when I get time. Working on some things with it that once they start working I'll go back and see how much I can get back on track before uploading the changes. Working it down to 2 or 1 page checkout. just added a switch last night to drop the shipping address for a COWOA user.

Okay.. It's starting to get A LOT confusing in here.. Let me post this so it's clear for EVERYONE who is asking or inquiring about the beta version that myself and a few other contributors have been referring to..

YES.. There is a Zen Cart v1.5.4 compatible update to the version of COWOA that's currently available in the Zen Cart downloads section. That version is available on Github in the repo whose link I have posted a number of times in this support thread. https://github.com/DivaVocals/zen_COWOA. The current version number for this BETA version is v2.6.

YES.. There are other people who have forked this repo and are actively committing code to this repo from their forks to the https://github.com/DivaVocals/zen_COWOA repo,

and

YES.. There are others who have created their own COWOA repos altogether..

However when the MAJORITY of us posting in this thread are referring to the BET version of COWOA for Zen Cart v1.5.4, we are referring to the repo here: https://github.com/DivaVocals/zen_COWOA

I was wanting to make a few more changes to this version before submitting, but thinking I'm gonna need to speed up my submission to end the confusion about WHICH version are we referring to when we speak of the v1.5.4 compatible version.. (Again: this repor: https://github.com/DivaVocals/zen_COWOA)

Thank you for clarification, I shall merge one more time and give it another shot. As this is a db carried forward from a 1.5.1 show, I might need to run the uninstall sql from the old mod so the installer of the beta can do it's job? I shall see...

mydanilo:

Thank you for clarification, I shall merge one more time and give it another shot. As this is a db carried forward from a 1.5.1 show, I might need to run the uninstall sql from the old mod so the installer of the beta can do it's job? I shall see...

You only need to run those parts of the uninstall SQL that remove the configuration and configuration_group table entries..

DivaVocals:

Okay.. It's starting to get A LOT confusing in here..

OK.... sorry, I'll go back into my hole and keep quiet.. LOL

davewest:

OK.... sorry, I'll go back into my hole and keep quiet.. LOL

don't you dare I'm waiting to see your fork!!smile

DivaVocals:

You only need to run those parts of the uninstall SQL that remove the configuration and configuration_group table entries..
Second time around worked fine. Merging with Edit Orders and Admin Login As Customer took some time but now they all work, finally! God do I love Word Press simplicity for upgrades....