I uploaded the zc_install folder again and successfully upgraded the database from 1.3.6 to 1.3.7 but when i try to upgrade from 1.3.7 to 1.3.8 i get another error
***************
1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
in:
[INSERT INTO ataste_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');]
***************
The site now has "Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels." so I checked the Tools -> Server info and yes it tells me its at 1.3.7
any ideas how to get it to upgrade again?
Many thanks
Ellie
Bookmarks