How to OpenCart Upgrade

  • 2015-12-09 17:24:57
  • Ekrem KAYA
  • E-Commerce
  • Tutorials
  • 0 comment(s)
  • 3500
  1. BACKUP YOUR EXISTING STORE FILES AND DATABASE!!
    • Backup your database via your store Admin->System->Backup
    • Backup your files using FTP file copy or use cPanel/Plesk Panel filemanager to create a zip of all the existing opencart files and folders
  2. Download the latest version of OpenCart and upload ALL new files on top of your current install EXCEPT your config.php and admin/config.php. If you are up to date with the last recent version and want to find just the new files that have changed since the last version, you can follow this guide to create a smaller changes-only patch. But for most, the full opencart zip will suffice.
    • Watch this video to understand how to properly upload folder using FTP.
  3. Browse to http://<yourstore.com>/install Replacing <yourstore.com> with your actual site (and subdirectory if applicable).
  4. You should see the OpenCart Upgrade script.
    • If you see the OpenCart Install page, then that means you overwrote your config.php files. Restore them from your backup first. Then try again.
  5. Click "Upgrade". After a few seconds you should see the upgrade success page.
    • If you see any errors, report them immediately in the forum before continuing.
  6. Clear any cookies in your browser.
  7. Goto the admin side of your store and press Ctrl+F5 3x times to refresh your browser cache. That will prevent oddly shifted elements due to stylesheet changes. Login to your admin as the main administrator.
  8. Goto Admin->Users->User Groups and Edit the Top Adminstrator group. Check All boxes.
    • This will ensure you have permissions for all the new files.
  9. Goto Admin->System->Stores.
    • Update any blank fields and click save.
    • Even if you do not see any new fields, click save anyway to update the database with any new field names.
  10. Other Adjustments that may need to be made, depending on which version you are upgrading from and to. These are broken down by which version they were added in. So if you are not currently at that version, you may need to make changes.
    • v151
      • Modules must all be reinstalled to update the database with the new serialized data method or you will see errors on the front end.
    • v151.3
      • System->Stores have new "Use Store Tax Address" and "Use Customer Tax Address" fields that need to be set for taxes to work. By default they are updated to use "Shipping Address" which will be what 99% of stores will use anyway.
    • v152
      • New "Product Count" field added to the category module. You may need to edit that module to set the new field.
    • v153
      • UPS module gets a change for the unit select and is disabled by default to force you to resave the settings.
      • New Voucher Min/Max fields added to Admin->System>Stores. Default is 1 to 1000
      • New Customer Group selection option for registration. You can choose which fields to show in the Admin->Customer->Customer Groups section.  By default it is set to "Default" only in the Admin->System>Stores under the Option tab.
      • New "Category Product Count" setting in the Admin->System>Stores under the Server tab. This is disabled by default and should only be used for small stores as it causes massive performance loss for larger stores with lots of categories.
  11. Load the store front and again press CTRL+F5 3x times to refresh your browser cache. That will prevent oddly shifted elements due to stylesheet.
  12. If you use vQmod (by now everyone should be) you should first check for a new version at http://vqmod.com. Be sure to download the version that is marked for "opencart".
    • You will also need to re-run the vQmod installer, even if you have the latest version. You should already have the installer on your site as it isn't meant to be deleted from the first time you run it.
    • Simply browse to: http://yoursite.com/vqmod/install and you should see a success message. If you do not see a success message, follow the full install guide from the http://vqmod.com site.

Click to enlarge.
 Note that some of your vQmod scripts may need to be updated for the new core changes. So run through your site catalog and admin areas and check in FTP for error file(s) in vqmod/logs. If you see errors, then you will need to address them. Also, if you are using CloudFlare or a similar system, please follow the steps in image.

v2.1.0.1 Upgrade Fix

Change oc_ db prefix with your db prefix and run phpmyadmin->SQL Tab

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`;


    Loading...
Last Update: 2015-12-10 12:36:26

Ekrem KAYA

1985 Gemlik doğumlu, müzik ve yemek ayrımı yapmayan, maviye hayran, sabrının sınırlarını zorlayan, beyninde yüz bin baloncuk gezen, yengeç burcu bir dünyalı.

Related Articles

Loading...

Write a Comment

Reply

Note: HTML is not translated!

  • How to OpenCart Upgrade
  • OpenCart Update,OpenCart Upgrade,OpenCart Update Guide
  • http://static.e-piksel.com/image/cache/catalog/articles/opencart/how-to-opencart-upgrade-500x350.jpg
  • 2015-12-09 17:24:57
  • 2015-12-10 12:36:26
    1. BACKUP YOUR EXISTING STORE FILES AND DATABASE!!
      • Backup your database via your store Admin->System->Backup
      • Backup your files using FTP file copy or use cPanel/Plesk Panel filemanager to create a zip of all the existing opencart files and folders
    2. Download the latest version of OpenCart and upload ALL new files on top of your current install EXCEPT your config.php and admin/config.php. If you are up to date with the last recent version and want to find just the new files that have changed since the last version, you can follow this guide to create a smaller changes-only patch. But for most, the full opencart zip will suffice.
      • Watch this video to understand how to properly upload folder using FTP.
    3. Browse to http://<yourstore.com>/install Replacing <yourstore.com> with your actual site (and subdirectory if applicable).
    4. You should see the OpenCart Upgrade script.
      • If you see the OpenCart Install page, then that means you overwrote your config.php files. Restore them from your backup first. Then try again.
    5. Click "Upgrade". After a few seconds you should see the upgrade success page.
      • If you see any errors, report them immediately in the forum before continuing.
    6. Clear any cookies in your browser.
    7. Goto the admin side of your store and press Ctrl+F5 3x times to refresh your browser cache. That will prevent oddly shifted elements due to stylesheet changes. Login to your admin as the main administrator.
    8. Goto Admin->Users->User Groups and Edit the Top Adminstrator group. Check All boxes.
      • This will ensure you have permissions for all the new files.
    9. Goto Admin->System->Stores.
      • Update any blank fields and click save.
      • Even if you do not see any new fields, click save anyway to update the database with any new field names.
    10. Other Adjustments that may need to be made, depending on which version you are upgrading from and to. These are broken down by which version they were added in. So if you are not currently at that version, you may need to make changes.
      • v151
        • Modules must all be reinstalled to update the database with the new serialized data method or you will see errors on the front end.
      • v151.3
        • System->Stores have new "Use Store Tax Address" and "Use Customer Tax Address" fields that need to be set for taxes to work. By default they are updated to use "Shipping Address" which will be what 99% of stores will use anyway.
      • v152
        • New "Product Count" field added to the category module. You may need to edit that module to set the new field.
      • v153
        • UPS module gets a change for the unit select and is disabled by default to force you to resave the settings.
        • New Voucher Min/Max fields added to Admin->System>Stores. Default is 1 to 1000
        • New Customer Group selection option for registration. You can choose which fields to show in the Admin->Customer->Customer Groups section.  By default it is set to "Default" only in the Admin->System>Stores under the Option tab.
        • New "Category Product Count" setting in the Admin->System>Stores under the Server tab. This is disabled by default and should only be used for small stores as it causes massive performance loss for larger stores with lots of categories.
    11. Load the store front and again press CTRL+F5 3x times to refresh your browser cache. That will prevent oddly shifted elements due to stylesheet.
    12. If you use vQmod (by now everyone should be) you should first check for a new version at http://vqmod.com. Be sure to download the version that is marked for "opencart".
      • You will also need to re-run the vQmod installer, even if you have the latest version. You should already have the installer on your site as it isn't meant to be deleted from the first time you run it.
      • Simply browse to: http://yoursite.com/vqmod/install and you should see a success message. If you do not see a success message, follow the full install guide from the http://vqmod.com site.

    Click to enlarge.
     Note that some of your vQmod scripts may need to be updated for the new core changes. So run through your site catalog and admin areas and check in FTP for error file(s) in vqmod/logs. If you see errors, then you will need to address them. Also, if you are using CloudFlare or a similar system, please follow the steps in image.

    v2.1.0.1 Upgrade Fix

    Change oc_ db prefix with your db prefix and run phpmyadmin->SQL Tab

    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`;