Our Feature Items: SM Market // SM AutoStore // SP Revo
Shopping cart (0)

Club Magento 2

How to Upgrade OpenCart v2.1.0.1

Rate this item
(0 votes)
Written by  Sumo
Wednesday, 04 November 2015 13:54
As OpenCart v2.1.0.1 has been released, there are some problems when upgrading to this latest OpenCart version. These steps below will show you how to update and fix issues when update to OpenCart 2.1.0.1.

How to upgrade OpenCart 2.1.0.1

1. Download the latest OpenCart version Here.

2. Unzip the downloaded package

3. Using an FTP file manager or Hosting Cpanel file manager upload the content of upload folder to the server on top of your current install EXCEPT your config.php and admin/config.php

upgrade opencart

4. Browse to http://yourstore.com/install replacing yourstore.com with your actual site (and subdirectory if applicable). You will see the OpenCart Upgrade script.

5. Click Upgrade or Continue. After a few seconds you should see the upgrade success page.

6. Go back to your FTP and remove the install folder.

How to fix errors occurred when upgrading by using the Backup/Restore option file install

1. Log into your Opencart admin panel. Open Tools > Backup/Restore page.

2. Browse your install.sql  file under Restore Backup field.

    install.sql file code:


SET sql_mode = '';

--
-- Table structure for table `oc_api`
--

DROP TABLE IF EXISTS `oc_api`;
CREATE TABLE `oc_api` (
  `api_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `key` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`api_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oc_api_ip`
--

DROP TABLE IF EXISTS `oc_api_ip`;
CREATE TABLE `oc_api_ip` (
  `api_ip_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) NOT NULL,
  `ip` varchar(40) NOT NULL,
  PRIMARY KEY (`api_ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `oc_api_session`
--

DROP TABLE IF EXISTS `oc_api_session`;
CREATE TABLE `oc_api_session` (
  `api_session_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) NOT NULL,
  `token` varchar(32) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `session_name` varchar(32) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  PRIMARY KEY (`api_session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Table structure for table `oc_cart`
--

DROP TABLE IF EXISTS `oc_cart`;
CREATE TABLE `oc_cart` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `product_id` int(11) NOT NULL,
  `recurring_id` int(11) NOT NULL,
  `option` text NOT NULL,
  `quantity` int(5) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`cart_id`),
  KEY `cart_id` (`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Table structure for table `oc_customer_wishlist`
--

DROP TABLE IF EXISTS `oc_customer_wishlist`;
CREATE TABLE `oc_customer_wishlist` (
  `customer_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  PRIMARY KEY (`customer_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `oc_customer` CHANGE COLUMN `token` `token` text NOT NULL;

DROP TABLE IF EXISTS `oc_customer_ban_ip`;
DROP TABLE IF EXISTS `oc_customer_activity`;
CREATE TABLE `oc_customer_activity` (
`activity_id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`key` varchar(64) NOT NULL,
`data` text NOT NULL,
`ip` varchar(40) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`activity_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

3. Click the Restore button at the top right corner:

Opencart._Using_the_Backup_Restore_option_3


After all these steps, you will successfully upgrade you store with OpenCart 2.1.0.1

Hope this article is useful for you! Thanks for reading!

Google+
Joomla TemplatesFree Joomla TemplatesVirtuemart TemplatesK2 TemplatesJoomShopping TemplatesHikaShop TemplatesSobiPro TemplatesOpenCart Themes
Quà Tết Cao Cấp Hộp quà tết Giỏ quà tết Túi quà tết