Steps to upgrade from 1.2.6 to 1.2.7

I didn't see it yet in the wiki section. What are the proper steps to UPGRADE from version 1.2.6 to 1.2.7 ?

If its in the download file already please let us know, if not its a good practice to put a straight forward upgrade.txt file in each version for users (atleast for the prior version release) along with the standard install.txt file.

P.S. Keep up the great work on this great product.

See this thread for a brief description on how to upgrade to the new Opencart 1.2.7.

Thanks, I'll repost it here:

Daniel wrote:

scripto wrote:How can you upgrade v1.2.6 easily to this new build?

To Upgrade:
1. First off backup your site.
2. Download a backup of your database.
3. Delete the files in your hosting directory
4. Upload the files from the download.
5. Go through the install as normal.
6. Once the install is finished import the database you backed up.
7. Goto the image directory from the backup and copy all the image and upload to the image directory on your hosting.

There is only one db change. I add the field coupon_id to the orders table.

I tried to upgrade from 1.2.6 to 1.2.7

here is error I am getting..

Error

SQL query:

--
-- Dumping data for table `category`
--
INSERT INTO `category` ( `category_id` , `image` , `parent_id` , `sort_order` , `date_added` , `date_modified` )
VALUES ( 39, '', 0, 4, '2009-04-18 08:00:03', '2009-04-18 08:00:03' ) , ( 17, '', 0, 3, '2009-01-03 21:08:57', '2009-04-18 07:58:56' ) , ( 42, '', 37, 3, '2009-04-18 10:13:53', '2009-04-22 04:54:07' ) , ( 41, '', 37, 2, '2009-04-18 08:02:06', '2009-04-18 10:10:09' ) , ( 40, '', 37, 1, '2009-04-18 08:01:11', '2009-04-22 07:56:56' ) , ( 38, 'circuits3.png', 0, 2, '2009-04-18 07:58:18', '2009-04-22 06:43:00' ) , ( 37, 'circuits1.png', 0, 1, '2009-04-18 07:56:36', '2009-04-22 06:42:19' ) , ( 43, '', 38, 1, '2009-04-22 04:51:14', '2009-04-22 04:51:14' ) , ( 44, '', 38, 2, '2009-04-22 04:52:01', '2009-04-22 04:52:01' ) , ( 45, '', 38, 3, '2009-04-22 04:52:54', '2009-04-22 04:52:54' ) ;

MySQL said: Documentation
#1062 - Duplicate entry '17' for key 1

Hi suds,

Are you getting this when you run the import?

By the looks of the error it seems like you have a duplicate. I.e there was already a category in your database which has been assigned category_id 17.

Are you doing this on a fresh install of 1.2.7?

Login to mysql and confirm if there already is a category with category_id = "17":

select * from category where category_id = "17";

you can also confirm which ones were successully written to the database using similar syntax to above.

try this out and let us know if you need more assistance. I will install a fresh install later tonight and will be able to confirm which category_id numbers already have been assigned on a fresh install.

Also, if he has added in past mods to opencart where he may have added a new table to the sql file this too can create a problem from my experience.