Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / Help need error in upgrade to 1.3.8a urgent

Help need error in upgrade to 1.3.8a urgent

Locked

Views: 1,579

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
20 Dec 2007, 1:04 AM
#1
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Help need error in upgrade to 1.3.8a urgent

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');]

Also the bar keeps coming up that the database is not upgraded

http://www.palam.org/bkstore2

20 Dec 2007, 5:40 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Help need error in upgrade to 1.3.8a urgent

After importing your DB - did you re-run zc_install to upgrade the DB?

20 Dec 2007, 6:25 AM
#3
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: Help need error in upgrade to 1.3.8a urgent

Yes, that didn't work and when I tried a fresh install of 1.38a and moving just the products and categories and other product related fields over Everthing worked except the products. It is telling me there are too many fields but I have counted and there are not.

Only about 4 of 180 show up.

SO I am in a mess. Can't get the data in a good database and can't fix the other (which was supposed to be a good database.

C

20 Dec 2007, 11:58 PM
#5
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: Help need error in upgrade to 1.3.8a urgent

Upgrade completed with this error, the category columns do not show up correctly they are set to 3 but show up as one row with 2 the next with one.

21 Dec 2007, 12:10 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Help need error in upgrade to 1.3.8a urgent

cshart:

Upgrade completed with this error, the category columns do not show up correctly they are set to 3 but show up as one row with 2 the next with one.

I'm not sure I understand.
What error are you referring to now?