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???
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
Hi,
-disable modules etc
-Used the 1564-to-2011.sql file.
-removed the db prefix (oc_)
-run the script... the following error:
Just tested with the upgrade using 1.5.6.5_rc as a base (latest Git).Download the script and read more information pleas go to this link:http://adf.ly/wZlCt
-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.
Hi, fixed.tjsystems wrote:Hi,
Just tested with the upgrade using 1.5.6.5_rc as a base (latest Git).Download the script and read more information pleas go to this link:http://adf.ly/wZlCt
-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
ร้านค้าออนไลน์
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
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
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
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.
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
Who is online
Users browsing this forum: No registered users and 30 guests