COWOA Module (my update for ZC v1.3.x)

[countrycharm]

So I'm back with one more question..

On a site using PayPal Payments Pro or Authorize.net, I can see how offering a COWOA option may be beneficial.

However, PayPal Express can be configured to operate like COWOA. If a customer clicks the "Checkout With PayPal" button in a store where PayPal Express is configured to operate like COWOA, they are immediately directed to the PayPal checkout page where they can pay with or without a PayPal account.

Trying to understand the need/advantage of using COWOA on a site which has PayPal Express configured to operate like COWOA..

Would appreciate some insight from those who are using COWOA.. Though my question is not version specific, if this question should be posted in the new support thread, let me know and I'll be happy to move this discussion there..

On a site using PayPal Payments Pro or Authorize.net, I can see how offering a COWOA option may be beneficial.

Yes it is beneficial.

However, PayPal Express can be configured to operate like COWOA. If a customer clicks the "Checkout With PayPal" button in a store where PayPal Express is configured to operate like COWOA, they are immediately directed to the PayPal checkout page where they can pay with or without a PayPal account.

Trying to understand the need/advantage of using COWOA on a site which has PayPal Express configured to operate like COWOA..

Correct again PayPal Express can be configured to operate like COWOA and it is not needed, but a lot of people don't have that knowledge. Thank You for bring it up.

[DivaVocals]

Correct again PayPal Express can be configured to operate like COWOA and it is not needed, but a lot of people don't have that knowledge. Thank You for bring it up.

Okay.. thanks for confirming this part for me..

[sharpie82]

I can't find a solution to my problem in this thread. I'm having difficulty uninstalling COWOA using the uninstall_COWOA.sql file. It seems pretty straightforward, but I get error: 1054 Unknown column 'query_builder.query_name' in 'where clause'
in:
[DELETE FROM znc_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

when I try and execute that. I removed the line that was related to that error but it just gives a new error for the next line in that .sql file. Also, I'm getting similar errors when trying to send e-mails to customers through zencart and also when trying to export e-mails. The main reason I'm trying to get COWOA out of my database though is because it's removed the colum about where the customers where referred from on the customers page. I manually added it back in by manipulating the customers.php file in admin, but the customers referral source isn't being saved in the database, and I'm guessing some COWOA-related modification is to blame. Also, disabling COWOA doesn't help, I want to remove it from the database.

[countrycharm]

I can't find a solution to my problem in this thread. I'm having difficulty uninstalling COWOA using the uninstall_COWOA.sql file. It seems pretty straightforward, but I get error: 1054 Unknown column 'query_builder.query_name' in 'where clause'
in:
[DELETE FROM znc_query_builder WHERE query_builder.query_name = 'Permanent Account Holders Only' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

when I try and execute that. I removed the line that was related to that error but it just gives a new error for the next line in that .sql file. Also, I'm getting similar errors when trying to send e-mails to customers through zencart and also when trying to export e-mails. The main reason I'm trying to get COWOA out of my database though is because it's removed the colum about where the customers where referred from on the customers page. I manually added it back in by manipulating the customers.php file in admin, but the customers referral source isn't being saved in the database, and I'm guessing some COWOA-related modification is to blame. Also, disabling COWOA doesn't help, I want to remove it from the database.

I'm assuming you are still on zen cart v1.3.9. If so re-run the COWOA_Full_Install.sql statement again and try to uninstall it again. If that doesn't work you have modified something in your database keeping it from uninstalling. You might have to go to your phpMyAdmin database to manually uninstall it.

[sharpie82]

I'm assuming you are still on zen cart v1.3.9. If so re-run the COWOA_Full_Install.sql statement again and try to uninstall it again. If that doesn't work you have modified something in your database keeping it from uninstalling. You might have to go to your phpMyAdmin database to manually uninstall it.

I just now tried the full install sql file and I get error message:

1062 Duplicate entry 'Permanent Account Holders Only' for key 'query_name'
in:
[INSERT INTO znc_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

But similar error messages when navigating around admin go away. Then I tried the uninstall sql file again and the same error message as before showed up. So I guess I have to manually unstall it. How exactly do I do that? What lines of code do I delete from the database? I see lots of pieces of cowoa in there.

[countrycharm]

I just now tried the full install sql file and I get error message:

1062 Duplicate entry 'Permanent Account Holders Only' for key 'query_name'
in:
[INSERT INTO znc_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

But similar error messages when navigating around admin go away. Then I tried the uninstall sql file again and the same error message as before showed up. So I guess I have to manually unstall it. How exactly do I do that? What lines of code do I delete from the database? I see lots of pieces of cowoa in there.

It would be much simpler if you would give me temporary access to your phpMyAdmin. By the time I tell you I could already have it done.
You have deleted all files containing to Cowoa right? If you don't you will receive and error message in the admin which say's
WARNING: An Error occurred, please refresh the page and try again.... after you uninstall the uninstall_COWOA.sql statement.

If you want me to uninstall it for you send the details to me in a PM.

[seanscully]

I am using 1.3.9H with COWOA and a mobile template and notcie on my desktop version I get in my browser bar title the phrase Redeem Gift Certificate and on the home page and shopping cart but not product pages the phrase - Step 3 of 3 - Order Confirmation. Where can I edit this out?

[SpeedBird3654]

Im really struggling... Iv installed the mod and it messed up my template and didnt show COWOA in my admin configuration drop down menu at all

my site is ;- www.adultpleasure.co.uk/store

[DivaVocals]

I have open a NEW thread for the latest version COWOA Updated and Combined for Zen Cart v1.5.x. COWOA Version 20c4. I'm not providing any support for this add-on I'm just being a good zen cart member and opening another thread for the updated version of COWOA....
COWOA has been uploaded to the downloads area waiting on approval from the zen team.

The new thread is here: http://www.zen-cart.com/showthread.p...-for-ZC-v1-5-x

Unless you are running the OLDER version of COWOA, support question should be posted in the v1.5.x. COWOA Version support thread..