Quote Originally Posted by ladyink View Post
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