Hello everyone, I'm rather new using ZenCart. I am trying to upgrade a website. Everything goes well untill the system has accepted my admin username en password to update my database. When I try it, I get the following error:
1062 Duplicate entry 'Customers who have never completed a purchase' for key 'query_name'
in:
[INSERT INTO zen_query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL');]
Does anyone know this problem and give me the step how I can solve this problem?
With kind regards,
Marco from the Netherlands.
Bookmarks