My Checkout Without Account Mod

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?

Quote:

---

Originally Posted by 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

I installed this mod early on when I started developing my website. This was one of the first mods I installed. I'm almost finished with my website when I tested the downloads and found that COWOA won't allow customers to download products (instant download) unless they are logged in. Once they click the download button, they are taken to the login page.

Is there not an easy way around this? Or does this entail a huge rewrite?? I hope not!!

Please help! :frusty:

LOL

sunflowertami

my site is for downloads too! HHmmmm am I wasting time on this mod? I hope not because if I can get it working as intended it would be perfect for my needs.

I re-read the readme file and it does say that the customer is actually creating an account however the details are hidden and password is not required.

I am not a programmer but if that is the case then logically it should work if whatever file that references the checkout success references those account details before the customer gets logged off.

I used this mod and made further modifications on the login page, took out most of the details the customer needs to input except for email, name, city, country. It would be perfect PERFECT if we can get COWOA to work!!

Please help!!! :frusty:

So instead of fretting about changing all the codes, I just disabled COWOA which is just commenting it out from the login page so it won't show.

Then I reworded the whole checkout experience so that the customer will just be entering the details for checkout (when actually they are creating an account).

The only info I require is first name, last name, city, state, country, email and password then they can checkout and download the files.

short and sweet :D

>>The only info I require is first name, last name, city, state, country, email and password then they can checkout and download the files.<<


sunflowertami

If I may ask.... and maybe you'll answer? :smile:


How did you eliminate street address, zip code, and telephone number? I have no need for these fields but admin doesn't off to disable these. (unless I'm missing something.)

I'm just learning to deal with php.

I see you still require a password so that means at some point one needs to create an account.

Quote:

---

admin doesn't off

---

should read...

admin doesn't offer

>>How did you eliminate street address, zip code, and telephone number? <<


never mind ........ got it

http://www.zen-cart.com/forum/showth...move+telephone