upgrade from 1.3.0 to 1.3.0.2

**v3locity** · 27 Jul 2006, 08:42 PM

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.

**kobra** · 29 Jul 2006, 05:52 AM

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.

**Ajeh** · 30 Jul 2006, 12:14 AM

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 ...

**v3locity** · 31 Jul 2006, 08:02 PM

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.