Forums / Upgrading from 1.3.x to 1.3.9 / 1062 Duplicate entry - on upgrade

1062 Duplicate entry - on upgrade

Locked

Views: 660

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
8 Apr 2010, 4:35 PM
#1
veedub avatar

veedub

New Zenner

Join Date:
Apr 2010
Posts:
2
Plugin Contributions:
0

1062 Duplicate entry - on upgrade

Hi,
I wonder if there iss anyone with the time and patience to help a "newbie" to Zen Cart.
Our site was designed by a firm who basically showed us the admin control panel and left us to it. The site has worked very well for us and has/is generating a substantial amount of business. Unortunately it's too much traffic and we've gone over our allotted bandwith quite substantially. As a consequence of this and of being hacked a number of times we are trying to migrate the site to a dedicated server and perform the 1.37 to 1.38 upgrade.
After much headbanging and a generous amount of help from our new host we had the site running on the new server (as a test site) and decided to peform the upgrade.
Having followed the upgrade instructions and gotten id of all the errors I hit the Database upgrade button, it the tells me that i need a 1,37 to 1,38 upgrade - I hit the button and get the following error message:-
1062 Duplicate entry 'Customers who have never completed a purchase' for key 2
in:
[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');]

Duh???
anyone help someone who is way out of his depth ??ards

Cheers

Chris

8 Apr 2010, 5:52 PM
#2
get_em_fast avatar

get_em_fast

Totally Zenned

Join Date:
Dec 2006
Location:
Seligman, MO U.S.A.
Posts:
2,072
Plugin Contributions:
1

Re: 1062 Duplicate entry - on upgrade

You might try using UPDATE instead of INSERT INTO.

Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!

8 Apr 2010, 9:57 PM
#3
eentje avatar

eentje

Zen Follower

Join Date:
Jan 2009
Location:
The Netherlands/Germany
Posts:
144
Plugin Contributions:
4

Re: 1062 Duplicate entry - on upgrade

the insert into is baked in the update...

you might want to get in your database and delete the Customers who have never completed a purchase entry by hand

I came, I saw, I got zenned... :)

11 Apr 2010, 11:47 PM
#4
veedub avatar

veedub

New Zenner

Join Date:
Apr 2010
Posts:
2
Plugin Contributions:
0

Re: 1062 Duplicate entry - on upgrade

All good now except i'm getting the customer return login error.
have created new customer and he logs in and out ok, have made sure that the
tpl_login_default.php
tpl_timeout_default.php
have the additional lines in them but still no luck.
My admin login is fine and the site seems to be selling items as well (to the new customer).

Also,

How do I migrate the current database (v 1.3.7) when i want to go live on the new site v 1.3.8 - is it just a case of backup and restore or will i then end up having a 1.3.7 database on my new site??

Thanks for the advice

Chris