I'm trying to uninstall COWOA to replace it with FEC. However, when I run the uninstall_COWOA.sql I get an error:
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;]
So, now I cant uninstall COWOA, and when I try to install FEC I get error:
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');]
.
I've tried using phpMyAdmin to check for any COWOA entries, but cant find any.
I'm using Zen-Cart v1.39h
Any assistance appreciated!


Reply With Quote
