Forums / Upgrading from 1.2 to 1.3.x / upgrade from 1.3.0 to 1.3.0.2

upgrade from 1.3.0 to 1.3.0.2

Locked

Started by v3locity on 27 Jul 2006, 7:42 PM · Views: 2,112

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
27 Jul 2006, 7:42 PM
#1
v3locity avatar

v3locity

New Zenner

Join Date:
Jul 2006
Posts:
2
Plugin Contributions:
0

upgrade from 1.3.0 to 1.3.0.2

i get this message in both admin and the store:
Warning Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels.
Database is at 1.3.0.1 aencart is at 1.3.0.2. I've tried updating the database from 0.1 to 0.2 and all I get is:
1062 Duplicate entry 'Administrator' for key 2
in:
[INSERT INTO tpbnetco_query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select 'ADMIN' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]

This makes me think that the database actually is 0.2. All this started when I realized this morning when testing that customers cannot complete orders because of a 1064 error during checkout. Please help, I'm really frustrated. This is my first attempt of creating an ecommerce site.

29 Jul 2006, 4:52 AM
#2
kobra avatar

kobra

Black Belt

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

Re: upgrade from 1.3.0 to 1.3.0.2

Search this site for '1062 Duplicate entry' and ther are several posts about this. Basically this indicates that you attempted to upgrade rwice or more times.

Zen-Venom Get Bitten

29 Jul 2006, 11:14 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: upgrade from 1.3.0 to 1.3.0.2

NOTE: be sure that you used the Full Zen Cart v1.3.0.2 to upgrade from v1.3 to v1.3.0.2 ...

The changed version is just for sites that had already upgraded properly from v1.3 to v1.3.0.1 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

31 Jul 2006, 7:02 PM
#4
v3locity avatar

v3locity

New Zenner

Join Date:
Jul 2006
Posts:
2
Plugin Contributions:
0

Re: upgrade from 1.3.0 to 1.3.0.2

Thats it. I went straight from 1.3 to 1.3.0.2. So do i need to install the complete 1.3.0.2 package? can I use the same database? I don't want to lose my products and all that info that is already in it.

31 Jul 2006, 9:24 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: upgrade from 1.3.0 to 1.3.0.2

v3locity:

All this started when I realized this morning when testing that customers cannot complete orders because of a 1064 error during checkout.
Please explain more about this error

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

31 Jul 2006, 9:25 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: upgrade from 1.3.0 to 1.3.0.2

v3locity:

Thats it. I went straight from 1.3 to 1.3.0.2.
How exactly did you do this? Please list detailed steps.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.