Possible solution if you have this problem:
1062 Duplicate entry 'Permanent Account Holders Only' for key 'query_name'
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.
For anyone having a problem with this message, and NOT posting HOW they solved it (thanks a LOT guys), this is what I did, and it SEEMS to have worked (no guarantees for anyone else....I'm just trying to post what helped me).
numinix says "remove the first 4 lines or so". I removed 8 LINES, and its basically worked. So where it starts with:
"SET @configuration_group_id=0;" .... thats where I started my SQL edit. So far it's worked, but I don't have high hopes of this working
Bookmarks