Post by amdev » Sat Jan 24, 2015 8:31 am

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

ร้านค้าออนไลน์
OpenCart Thailand Support Forum
How to Upgrade oc1.5 to 2.0.1.1
Upgrading OpenCart From v.1.4 or v.1.5 to V.2.2 Step by step


User avatar
Active Member

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand

Post by tjsystems » Mon Jan 26, 2015 9:30 pm

Thanks!

I'll try to test it today... let you know.

Live with 2.2.0.0 fully SSL.


Active Member

Posts

Joined
Sun Aug 26, 2012 5:39 pm
Location - NL, Amsterdam

Post by tjsystems » Tue Jan 27, 2015 12:49 am

Hi,
Download the script and read more information pleas go to this link:http://adf.ly/wZlCt
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 

Live with 2.2.0.0 fully SSL.


Active Member

Posts

Joined
Sun Aug 26, 2012 5:39 pm
Location - NL, Amsterdam

Post by amdev » Tue Jan 27, 2015 10:18 am

tjsystems wrote:Hi,
Download the script and read more information pleas go to this link:http://adf.ly/wZlCt
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.
;)

ร้านค้าออนไลน์
OpenCart Thailand Support Forum
How to Upgrade oc1.5 to 2.0.1.1
Upgrading OpenCart From v.1.4 or v.1.5 to V.2.2 Step by step


User avatar
Active Member

Posts

Joined
Fri Nov 27, 2009 3:40 pm
Location - Bangkok - Thailand

Post by tjsystems » Wed Jan 28, 2015 2:49 am

amdev wrote: Hi, fixed.
;)
can you post the fix here?

Live with 2.2.0.0 fully SSL.


Active Member

Posts

Joined
Sun Aug 26, 2012 5:39 pm
Location - NL, Amsterdam

Post by tjsystems » Wed Jan 28, 2015 3:26 am

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

Live with 2.2.0.0 fully SSL.


Active Member

Posts

Joined
Sun Aug 26, 2012 5:39 pm
Location - NL, Amsterdam

Post by keanel » Sat Jan 31, 2015 1:18 am

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

Newbie

Posts

Joined
Sat Jan 31, 2015 1:14 am

Post by eline » Sun Feb 01, 2015 5:43 am

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.

Polskie forum OpenCart: http://forum.opencart.com/viewforum.php?f=164


New member

Posts

Joined
Tue Oct 06, 2009 10:52 pm

Post by keenly » Mon Apr 20, 2015 11:33 pm

can anyone tell me if theres a working upgrade script for 1.5.X to latest? Cheers

Newbie

Posts

Joined
Mon Apr 20, 2015 10:57 pm
Who is online

Users browsing this forum: No registered users and 9 guests