My Checkout Without Account Mod

Is there any way to get this to work with Google Checkout? When I install the googlecheckout mod the COWOA option disappears. This has worked perfect for me until I tried to use Google. Any Ideas?

Thanks.

I see, both mods overwrite the same files. I wish I knew enough about php to try to combine these files so that they work together. Maybe someone else already has?

Thanks.

Hi! I'm really excited about this mod. I thought all went well... No so. Today I tried to login as an existing customer and this is the error that I get...

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM zen_customers WHERE customers_email_address = :email AND COWOA_account != 1]

I've been trying to figure it out. I've searched and searched and the only close error message was on a site that I had to translate to read (not good). Please help. I don't even know where to look.

Nancy

ladyink:

Hi! I'm really excited about this mod. I thought all went well... No so. Today I tried to login as an existing customer and this is the error that I get...

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM zen_customers WHERE customers_email_address = :email AND COWOA_account != 1]

I've been trying to figure it out. I've searched and searched and the only close error message was on a site that I had to translate to read (not good). Please help. I don't even know where to look.

Nancy

Well, for anyone else that may have this problem... I don't really have an exact answer but it is functioning properly now. I had installed this on two sites. The first site, I merged all the information into the pages that had already existed. That site worked great. Then I found the list of edits that was included with the module. For the second site, I just used the edits. Somewhere in there, something went wrong. Today (since I had made a backup) I uploaded my backup and then went in and merged the codes. Took about 2 hours- BUT IT WORKS!!!

I wish I knew where I went wrong- since I have other sites to add this mod to but in the mean time at least I have a method to work with!

It's great when things are resolved by 9am- it really makes the day seem all that much better!

Nancy

Qwert302:

I see, both mods overwrite the same files. I wish I knew enough about php to try to combine these files so that they work together. Maybe someone else already has?

Thanks.

I'm no expert... But I have it working with Google Checkout. I used "WinMerge" (A free and great tool- wish I'd had it years ago) and merged the file together. Using the file with Google checkout already in it and added the COWOA code to it. I think (and like I said, I'm no expert) that you really have to worry about:
includes/templates/YOURTEMP/templates/tpl_login_default.php and
include/templates/YOURTEMP/templates/tpl_checkout_payment_default.php

Nancy

Hi, finally got this working and all was going well but now for some reason the state/province field has gone, well not gone there's a field there with an * to indicate it's required but no name for the field and no drop down menu like there was before, also the default country is not showing up anymore it just says please select your country.
I have no idea why this would be happening, last time I tried it it was all fine and I haven't made any changes since. Here's a link to the billing info page. https://unique-jewellery.com.au/shop/index.php?main_page=no_account Any ideas anyone?

Okay went back to continue the test I was doing and discovered also that when I click continue checkout after entering billing info I just get the billing info page again, it doesn't move on at all. Please help?

All fixed, please disregard the last 2 messages. Thanks

I have a bizarre problem - On the clients site with no items in cart - click login - default 2 choice menu is displayed.

Add items to cart - login menu displays 3 choice menu correctly, however 'checkout' and 'continue to checkout' link both display default 2 choice option.

I've uploaded and reuploaded the files from a variety of sources, both by dumping them on there and by hand, so it cant be that. Any suggestions?

Thanks guys.

Thank you ladyink, that is a most useful tool!

This is so sweet, COWOA and GC together at last!

I tried setting up COWA with FEC and there has been some sort of collision, I don't know which caused it or how to fix this now.

The title tag of my shopping cart now always says Billing Information and the top of the page and all other shopping cart/check out pages now always says "Step 1 of 5 - Billing Information" even when I am not on step 1 of 5 billing information.

Has anyone seen this issue or found a way to solve it or have insight as to the fix here?

hlantern:

I would simply use a message on my index page stating "if you want to buy without creating an account with us, just send us your request by email, and we will reply shorthly, thank you :) "

I'm hoping this is a joke.

Hey, so far I love the mod.
However I did find one small problem. On my site I offer both merchandise and virtual products. The way Zen cart is set up is you need to have an account to be able to download what you have purchased. Is their any kind of setting that wont allow you to do express check out if you have virtual prods in your cart?

let me know, and keep on rock'n in the free world

Jarred f.

I need to disable and/or completely remove this mod from the store I'm working on. :no:

I loved this mod, while I had it on the site in question, by the way, and would keep it except the client doesn't want it because after the first time someone checks out without an account, it asks them for the account info the next time they order (seeing as how it creates accounts unbeknownst to the customer).

Have searched this thread high and low and cannot find any discussion on how this is done. :ohmy: Can anyone help?

Much appreciated! :clap:

bwoodsdesign:

client doesn't want it because after the first time someone checks out without an account, it asks them for the account info the next time they order (seeing as how it creates accounts unbeknownst to the customer)

When this mod is installed correctly, it does not ask them for account info after they have COWOA. The only time it would do this is if they are trying to COWOA with an email address that has previously created an account. I have been using COWOA from the beginning and have spent a lot of time placing different combinations of COWOA and non-COWOA test orders. I have placed COWOA order after COWOA order and my cart has never told me that I have already created an account. I have several customers who continually COWOA with no problems.

I'm not sure how to remove the SQL, but if you just get the original /includes/templates/YOUR_TEMPLATE/templates/tpl_login_default.php file and replace with the one you uploaded during COWOA, no one will be able to use COWOA.

Thank you for that. It's about what I figured but just wanted to make sure!

Will the Fast and Easy Checkout
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=845

Work with this mod.

I really hope it will, and would love to hear feedback from anyone that has used them together.

I was installing cowoa and this suddenly came up when i clicked login

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM customers WHERE customers_email_address = :email AND COWOA_account != 1]

Someone mentioned it and fixed it before but they didn't know what they did.

The site is http://www.fitnessaire.com/

Anyone have a clue about how to fix this?

xbboychink:

I was installing cowoa and this suddenly came up when i clicked login

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':email AND COWOA_account != 1' at line 9
in:
[SELECT customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_authorization, customers_referral FROM customers WHERE customers_email_address = :email AND COWOA_account != 1]

Someone mentioned it and fixed it before but they didn't know what they did.

The site is http://www.fitnessaire.com/

Anyone have a clue about how to fix this?

I replaced modules/pages/login/header_php.php with the origional code from the over-writes folder.

in case anyone has this problem in the future

Hi

I installed this mod and when testing it out I get as far as the login page during the check out process. I do see the 'Checkout Without Account' section. When I click on the continue button it takes me to a page showing 'page not found' error. (Custom 404 Error Page with Site Map Sample Text)

I went through the install steps again to see if I missed something but the error page is still coming up.

I may still have missed something, it's late and am tired, so will wrap up for tonight. :frusty:

If this problem is an obvious clue as to what I missed I'd be appreciative for an answer.

Thanks