Zen Follower
- Join Date:
- Jan 2008
- Location:
- Memphis, USA
- Posts:
- 298
- Plugin Contributions:
- 0
1.3.7 to 1.3.8a Upgrade error
Hi,
I have stock install of 1.3.7 with only a template mod. I get the following error when trying to upgrade.
1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
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 this make sense to anyone? Also now in my admin it shows I have version 1.3.7/1.3.8 even though the upgrade did not start.
