Page 1 of 1
[Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Sat Jan 24, 2015 8:31 am
by amdev
Hi all,
This is a simple way to migration your opencart from 1.5.x to 2.0.1.1
https://www.youtube.com/watch?v=eOsOswYBGuU
How to do?
Backup your database.
Log in to OpenCart Administrator panel.
Uninstall all modules that activated.
Uninstall extension which are not originally.
Log in to your phpmyadmin panel.
Go to your database and import the migration sript.
Download and extract opencart-2.0.1.1.zip to your opencart directory.
Update download and image directory.
Configuration config.php and admin/config.php files.
Log in to administrator panel again and setting up the user groups permission.
Update the store settings and categories.
Done.
ps1:I'm so sorry for my bad on English and i'm a newbie with Camtasia recorder
ps2:I'm don't wnow how to attach youtube to phpBB forum???
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Mon Jan 26, 2015 9:30 pm
by tjsystems
Thanks!
I'll try to test it today... let you know.
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Tue Jan 27, 2015 12:49 am
by tjsystems
Hi,
Just tested with the upgrade using 1.5.6.5_rc as a base (latest Git).
-disable modules etc
-Used the 1564-to-2011.sql file.
-removed the db prefix (oc_)
-run the script... the following error:
Code: Select all
SQL-query:
ALTER TABLE `product` CHANGE `date_available` `date_available` DATE NOT NULL DEFAULT '0000-00-00' AFTER `tax_class_id``; ALTER TABLE `product` CHANGE `date_added` `date_added` DATETIME NOT NULL AFTER `viewed`; ALTER TABLE `product` CHANGE `date_modified` `date_modified` DATETIME NOT NULL AFTER `date_added`; -- -------------------------------------------------------- -- -- Table structure for table `product_description` -- ALTER TABLE `product_description` CHANGE `tag` `tag` TEXT NOT NULL AFTER `description`; ALTER TABLE `product_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `tag`; -- -------------------------------------------------------- -- -- Table structure for table `product_image` -- ALTER TABLE `product_image` ADD INDEX(`product_id`); -- -------------------------------------------------------- -- -- Table structure for table `product_option` -- ALTER TABLE `product_option` CHANGE `option_value` `value` TEXT NOT NULL; -- ------[...]
[b]MySQL retourneerde: Documentatie[/b]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'product` CHANGE `date_added` `date_added` DATETIME NOT NULL AFTER `viewed`;
ALT' at line 1
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Tue Jan 27, 2015 10:18 am
by amdev
tjsystems wrote:Hi,
Just tested with the upgrade using 1.5.6.5_rc as a base (latest Git).
-disable modules etc
-Used the 1564-to-2011.sql file.
-removed the db prefix (oc_)
-run the script... the following error:
Code: Select all
SQL-query:
ALTER TABLE `product` CHANGE `date_available` `date_available` DATE NOT NULL DEFAULT '0000-00-00' AFTER `tax_class_id``; ALTER TABLE `product` CHANGE `date_added` `date_added` DATETIME NOT NULL AFTER `viewed`; ALTER TABLE `product` CHANGE `date_modified` `date_modified` DATETIME NOT NULL AFTER `date_added`; -- -------------------------------------------------------- -- -- Table structure for table `product_description` -- ALTER TABLE `product_description` CHANGE `tag` `tag` TEXT NOT NULL AFTER `description`; ALTER TABLE `product_description` ADD `meta_title` VARCHAR(255) NOT NULL AFTER `tag`; -- -------------------------------------------------------- -- -- Table structure for table `product_image` -- ALTER TABLE `product_image` ADD INDEX(`product_id`); -- -------------------------------------------------------- -- -- Table structure for table `product_option` -- ALTER TABLE `product_option` CHANGE `option_value` `value` TEXT NOT NULL; -- ------[...]
[b]MySQL retourneerde: Documentatie[/b]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'product` CHANGE `date_added` `date_added` DATETIME NOT NULL AFTER `viewed`;
ALT' at line 1
Hi, fixed.
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Wed Jan 28, 2015 2:49 am
by tjsystems
amdev wrote:
Hi, fixed.
can you post the fix here?
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Wed Jan 28, 2015 3:26 am
by tjsystems
ok, just did it again..
whole script at once... errors...
split sql code in parts... OKE!
PS: had some trouble with multi language... Make shure ENGISH had ID:1
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Sat Jan 31, 2015 1:18 am
by keanel
Hello! When I do the import of your database. Pops up this error. see below.
SQL запрос:
-- ---------------------------------------------------------
--
-- Update image path to catalog
--
UPDATE `banner_image` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
Ответ MySQL: Документация
#1146 - Table 'p196389_s.banner_image' doesn't exist
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Sun Feb 01, 2015 5:43 am
by eline
Hello
SQL script in at least 1.5.6.4 package unfortunately has few errors.
On end of file You need to add prefix (yours is p196389_s., so probably code below should works).
UPDATE `p196389_s.banner_image` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
UPDATE `p196389_s.category` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
UPDATE `p196389_s.manufacturer` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
UPDATE `p196389_s.option_value` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
UPDATE `p196389_s.product` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
UPDATE `p196389_s.product_image` SET `image` = CONCAT( 'catalog/', `image` ) WHERE `image` <>'' ;
Also line
ALTER TABLE `oc_product` CHANGE `date_available` `date_available` DATE NOT NULL DEFAULT '0000-00-00' AFTER `tax_class_id``;
has a error with doubled `` on the end of line.
Re: [Tricks]How to migration from 1.5.x to 2.0.1.1
Posted: Mon Apr 20, 2015 11:33 pm
by keenly
can anyone tell me if theres a working upgrade script for 1.5.X to latest? Cheers