Error when upgrading
I am getting this error when upgrading.
1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
[INSERT INTO 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');]
Any thoughts here,
I am working in my local environment btw.
By elnaraniall in forum Upgrading from 1.2 to 1.3.x
Last Post: 12 Feb 2008, 12:11 AM
By bsteinagel in forum Upgrading from 1.3.x to 1.3.9
Last Post: 31 Dec 2007, 07:42 AM
By seattleannie in forum Upgrading from 1.3.x to 1.3.9
Last Post: 22 Feb 2007, 06:05 PM
By lennypeng in forum Upgrading from 1.3.x to 1.3.9
Last Post: 16 Nov 2006, 09:42 AM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC