My Checkout Without Account Mod

i am getting this error when i try to run the sql. file

the mod seemed to have worked.. but now i cant access my customer database in my admin?


1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO 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.

I've been using the COWOA module successfully for 4 months now. Thank you!

I'm in the process of implementing gift certificates and I've encountered a problem I can't seem to find any references to on the forum. I was able to add a gift certificate to my cart and checkout without an account.

If I don't send the gift certificate from the checkout confirmation screen then there's no way to 'log back in' to either use the gift certificate or send it to someone else.

It's working correctly in that if I'm the recipient of the gift certificate I can not redeem it without creating an account.

On a related point: I have a downloadable product in my store. Whenever someone checks out without an account they're unable to get back and download the product so I end up manually e-mailing them the product.

My question: Is there a simple way to prevent checking out without an account if the customer has either a downloadable product or a gift certificate in their cart?

Thank you!

Hi

The last few customers that have checked out from my site have created accounts. Some have not completed, and looks like they have created accounts but then not logged in and continued.

How can I put the checkout without account at the top of the page and make it more prominent, so the customer does not get confused.

This is my site www.chalfont gifts.co.uk

I have broken the link to stop google indexing this link to the site.

Regards
Laurie

Quote:

---

Originally Posted by pinkchalkstudio

I've been using the COWOA module successfully for 4 months now. Thank you!

I'm in the process of implementing gift certificates and I've encountered a problem I can't seem to find any references to on the forum. I was able to add a gift certificate to my cart and checkout without an account.

If I don't send the gift certificate from the checkout confirmation screen then there's no way to 'log back in' to either use the gift certificate or send it to someone else.

It's working correctly in that if I'm the recipient of the gift certificate I can not redeem it without creating an account.

On a related point: I have a downloadable product in my store. Whenever someone checks out without an account they're unable to get back and download the product so I end up manually e-mailing them the product.

My question: Is there a simple way to prevent checking out without an account if the customer has either a downloadable product or a gift certificate in their cart?

Thank you!

---

If they create an account later with the same email address, does the gift certificate appear?

Hello,

I'm trying to configure the Cowa mod in version 1.3.8 on IIS6. I'm copying the files to the directories as required and when I paste the queries into the box and hit send this is what I get:

1364 Field 'query_keys_list' doesn't have a default value
in:
[INSERT INTO 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.


Can someone help? I'm stumped.

Thanks!

How can one tell when the customer uses COWOA?

Probelm solved. I had MySql 5.0 installed and the Mod is written for version 4.1. No error after switching over.

Quote:

---

Originally Posted by staft

How can one tell when the customer uses COWOA?

---

See this post:

http://www.zen-cart.com/forum/showpo...&postcount=529

I uploaded all of the files to the correct folders on my site. Is there something else I'm supposed to do? I'm new to addons. Is there somewhere where I am supposed to enable this? Because right now it's not working. Thanks.

Maybe I didn't "get" everything? I downloaded from the link in the Wiki, here:

http://www.zen-cart.com/wiki/index.p...ithout_Account

Is this an "addon to an addon"? Is there another addon I was supposed to have first?