I am running Zen Cart 1.39d and have installed COWOA. I am having a very difficult time. When someone clicks checkout they only get two options: to register or to log in. There is no COWOA option at all. Other than that the checkout operates perfectly, complete with the green arrows and progress bar.
In my Admin panel there is no listing whatsoever for COWOA. I suspect that if there was I could turn on the COWOA option.
I have gone through all of the files numerous times and am confident that all is right there. I suspect it is a database problem. I tried running the uninstall COWOA.sql and I receive a white screen with this:
1054 Unknown column 'query_builder.query_name' in 'where clause'
in:
[DELETE FROM zen_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 to re-run the COWOA install sql I get this:
1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO zen_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.
Is there a 'back door' in a file where I can turn COWOA on? I am at a loss as to what else I can try. Any help or advice would be greatly appreciated.
Thank you.