1062 Duplicate entry 'Customers who have never completed a purchase' for key 2

[maperr55]

Hi, I am upgrading all my carts and it has been going well I guess. wish there was a way to test if everything was done correctly and no critical files were over written.

I am running into a strange error. I backed up my old cart. Installed a new copy of 139d. When I went to restored my backup I found it was damaged some how and I could not use it. I found a backup that was from a 137 cart and database. I restored from it ok said of course that the DB needed to be patched. When I run the DB update I get this error:

1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
in:
[INSERT INTO gallquery_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');]

Anything I can do or am I toast?

[DrByte]

That's happening because you're trying to do an upgrade step that's already been done once.
I share some ideas on this thread for getting around that particular problem: http://www.zen-cart.com/forum/showthread.php?t=82998

[maperr55]

Hi Doc,
I ran the sql query and it appears to correct the problem for that then I got this;

1253 COLLATION 'latin1_general_ci' is not valid for CHARACTER SET 'utf8'
in:
[CREATE TABLE gallcounter_history_clean as SELECT * FROM gallcounter_history WHERE 1 GROUP BY startdate COLLATE latin1_general_ci;]


---------------

I looked through the entire DB and changed the collation any where I found latin1_general_ci which was in a few places but I still get the error. ????

[DrByte]

Evidently your database is set to utf8, not latin1 which is assumed by default.
Change the DB_CHARSET in zc_install/includes/installer_params from 'latin1' to 'utf8'

[maperr55]

Hi Doc, That took care of it. Is it OK or a problem if it skips an entry because something already exists?

[DrByte]

The system normally intelligently skips things that have already been done, and simply displays a note about it. For the most part it's safe to ignore those.
Carry on.