ubertheme/module-ubdatamigration

This is a module for Magento 2. This allow migrate data from Magento 1.x to Magento 2.x

module-ubdatamigration's Issues

migration tool Whoops, our bad... in admin

Hello
i am using nexcess server and i have installed extension and when i am access backend and it coming it Whoops, our bad... not working tool any other settings need it?

can't install

Hi,
I just did install a fresh version of magento 2.2.2, when I give the composer command to install updatamigration I get:

Problem 1 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.4 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.3 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.2 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.1 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.0|remove magento/framework 101.0.2 - Conclusion: don't install ubertheme/module-ubdatamigration v1.0.0|don't install magento/framework 101.0.2 - Installation request for ubertheme/module-ubdatamigration ^1.0 -> satisfiable by ubertheme/module-ubdatamigration[v1.0.0, v1.0.1, v1.0.2, v1.0.3, v1.0.4]. - ubertheme/module-ubdatamigration v1.0.0 requires magento/framework 100.0.* -> satisfiable by magento/framework[100.0.2, 100.0.3, 100.0.4, 100.0.5, 100.0.6, 100.0.7, 100.0.8, 100.0.9, 100.0.10, 100.0.11, 100.0.12, 100.0.13, 100.0.14, 100.0.15, 100.0.16, 100.0.17, 100.0.18, 100.0.19]. - Can only install one of: magento/framework[101.0.2, 100.0.2]. - Can only install one of: magento/framework[101.0.2, 100.0.3]. - Can only install one of: magento/framework[101.0.2, 100.0.4]. - Can only install one of: magento/framework[101.0.2, 100.0.5]. - Can only install one of: magento/framework[101.0.2, 100.0.6]. - Can only install one of: magento/framework[101.0.2, 100.0.7]. - Can only install one of: magento/framework[101.0.2, 100.0.8]. - Can only install one of: magento/framework[101.0.2, 100.0.9]. - Can only install one of: magento/framework[101.0.2, 100.0.10]. - Can only install one of: magento/framework[101.0.2, 100.0.11]. - Can only install one of: magento/framework[101.0.2, 100.0.12]. - Can only install one of: magento/framework[101.0.2, 100.0.13]. - Can only install one of: magento/framework[101.0.2, 100.0.14]. - Can only install one of: magento/framework[101.0.2, 100.0.15]. - Can only install one of: magento/framework[101.0.2, 100.0.16]. - Can only install one of: magento/framework[101.0.2, 100.0.17]. - Can only install one of: magento/framework[101.0.2, 100.0.18]. - Can only install one of: magento/framework[101.0.2, 100.0.19]. - Installation request for magento/framework (locked at 101.0.2) -> satisfiable by magento/framework[101.0.2].

any hint?

thanks a lot

Error checkout after migrate

After migrate success, I'm test checkout product and error :
http://pasteboard.co/O8rPR5k.png
http://pasteboard.co/PG1ixR7.png
And logs:

[2016-01-15 08:49:03] main.CRITICAL: exception 'Zend_Db_Statement_Exception' with message 'Report ID: webapi-5698b27f9bb41; Message: SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '', query was: INSERT INTO `` () VALUES ()' in /var/www/html/magento20new/lib/internal/Magento/Framework/Webapi/ErrorProcessor.php:194
Stack trace:
#0 /var/www/html/magento20new/lib/internal/Magento/Framework/Webapi/ErrorProcessor.php(139): Magento\Framework\Webapi\ErrorProcessor->_critical(Object(Zend_Db_Statement_Exception))
#1 /var/www/html/magento20new/app/code/Magento/Webapi/Controller/Rest.php(163): Magento\Framework\Webapi\ErrorProcessor->maskException(Object(Zend_Db_Statement_Exception))
#2 /var/www/html/magento20new/var/generation/Magento/Webapi/Controller/Rest/Interceptor.php(24): Magento\Webapi\Controller\Rest->dispatch(Object(Magento\Framework\App\Request\Http))
#3 /var/www/html/magento20new/lib/internal/Magento/Framework/App/Http.php(115): Magento\Webapi\Controller\Rest\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#4 /var/www/html/magento20new/lib/internal/Magento/Framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#5 /var/www/html/magento20new/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#6 {main} [] []

Can you help me? pls

Step 6 Issue - Migrate Customers

Hello

I get the following error when trying to complete the Step 6:

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO customer_group (tax_class_id, customer_group_id, customer_group_code) VALUES (:yp0, :yp1, :yp2)

/Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/db/CDbCommand.php(358)
346 { 347 if($this->_connection->enableProfiling) 348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute'); 349 350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 351 $message=$e->getMessage(); 352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.', 353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 354 355 if(YII_DEBUG) 356 $message.='. The SQL statement executed was: '.$this->getText().$par; 357 358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 360 } 361 } 362 363 /** 364 * Executes the SQL statement and returns query result. 365 * This method is for executing an SQL query that returns result set. 366 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative 367 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing 368 * them in this way can improve the performance. Note that if you pass parameters in this way, 369 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa. 370 * Please also note that all values are treated as strings in this case, if you need them to be handled as Stack Trace

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/db/ar/CActiveRecord.php(1080): CDbCommand->execute()

1075 { 1076 Yii::trace(get_class($this).'.insert()','system.db.ar.CActiveRecord'); 1077 $builder=$this->getCommandBuilder(); 1078 $table=$this->getTableSchema(); 1079 $command=$builder->createInsertCommand($table,$this->getAttributes($attributes)); 1080 if($command->execute()) 1081 { 1082 $primaryKey=$table->primaryKey; 1083 if($table->sequenceName!==null) 1084 { 1085 if(is_string($primaryKey) && $this->$primaryKey===null)

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/db/ar/CActiveRecord.php(809): CActiveRecord->insert(null)

804 * @return boolean whether the saving succeeds 805 */ 806 public function save($runValidation=true,$attributes=null) 807 { 808 if(!$runValidation || $this->validate($attributes)) 809 return $this->getIsNewRecord() ? $this->insert($attributes) : $this->update($attributes); 810 else 811 return false; 812 } 813 814 /**
– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/protected/controllers/MigrateController.php(1817): CActiveRecord->save()

1812 $customer_group2->customer_group_code = $customer_group1->customer_group_code; 1813 } 1814 //update tax class_id if have exits 1815 $customer_group2->tax_class_id = $customer_group1->tax_class_id; 1816 1817 if ($customer_group2->save()){ 1818 $migrated_customer_group_ids[] = $customer_group2->customer_group_id; 1819 1820 //we will migrate related tax_class here 1821 $tax_class1 = Mage1TaxClass::model()->findByPk($customer_group2->tax_class_id); 1822 if ($tax_class1){ #3

-– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/actions/CInlineAction.php(49): MigrateController->actionStep6()

44 $controller=$this->getController(); 45 $method=new ReflectionMethod($controller, $methodName); 46 if($method->getNumberOfParameters()>0) 47 return $this->runWithParamsInternal($controller, $method, $params); 48 49 $controller->$methodName(); 50 return true; 51 } 52 }

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/CController.php(308): CInlineAction->runWithParams(array())

303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction;

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/CController.php(286): CController->runAction(CInlineAction)

281 \* @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); #6

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array())

260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); #7

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/CWebApplication.php(282): CController->run("step6")

277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); #8

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/web/CWebApplication.php(141): CWebApplication->runController("migrate/step6")

`136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
137 $_GET[$name]=$value;
138 }
139 else
140 $route=$this->getUrlManager()->parseUrl($this->getRequest());
141 $this->runController($route);
142 }
143
144 /**
145 * Registers the core application components.
146 * This method overrides the parent implementation by registering additional core components.
#9

`

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/yii/base/CApplication.php(184): CWebApplication->processRequest()
`179 public function run()
180 {
181 if($this->hasEventHandler('onBeginRequest'))
182 $this->onBeginRequest(new CEvent($this));
183 register_shutdown_function(array($this,'end'),0,false);
184 $this->processRequest();
185 if($this->hasEventHandler('onEndRequest'))
186 $this->onEndRequest(new CEvent($this));
187 }
188
189 /**
#10

`

– /Applications/MAMP/htdocs/finaldraft-m2/public_html2/pub/ub-tool/index.php(13): CApplication->run()

08 // change the following paths if necessary 09 $yii=dirname(__FILE__).'/yii/yii.php'; 10 $config=dirname(__FILE__).'/protected/config/main.php'; 11 12 require_once($yii); 13 Yii::createWebApplication($config)->run();

Screen:

• http://take.ms/eNxhZ
• http://take.ms/LcBSw

Can you help me please to solve this issue?

Thanks.

404 Error when clicking on UB Data Migration

site.com/admin/ubdatamigration/index/index/key/... gives and error. 404. See the screenshot. I've re-compiled, redid the static content, cleared the caches, etc.

php 5.6.17, nginx 1.9.9

CDbException

Hi. I get a "CDbConnection failed to open the DB connection: could not find driver" on opening the menu item. pdo_mysql installed and working.

503 on AWS/Bitnami

Trying to use the UB data migration with an install of a Magento image from Bitnami. The prior version (1.9.x) has over 200,000 products in the DB. The first few steps work fine but when I get to "Step 5: Migrate Products" I experience the following error:

Error 503 Backend fetch failed

Backend fetch failed
Guru Meditation:

XID: 327923

Varnish cache server

I have adjusted timeouts within the php.ini and also searched for any setting that might have to do with varnish itself (with little success). I thought that I was onto something when reading someone with similar, but they were running a different version of Varnish (3. We are running 4).. (http://stackoverflow.com/questions/27739853/varnish-cache-server-error-503-service-unavailable). Not only did this setting fail to exist in the .vcf file, but the vcf files do not exist in the install.

With this being a Bitnami/Magento (via AWS Marketplace) I figured that someone else might have experienced the issue.

I have been unable to track down any form of solution.

Any help would be greatly appreciated.

Datetime

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'value' at row 1. The SQL statement executed was: INSERT INTO catalog_product_entity_datetime (attribute_id, store_id, entity_id, value) VALUES (:yp0, :yp1, :yp2, :yp3)

346 {
347 if($this->_connection->enableProfiling)
348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349
350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351 $message=$e->getMessage();
352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354
355 if(YII_DEBUG)
356 $message.='. The SQL statement executed was: '.$this->getText().$par;
357
358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360 }
361 }

Customer Attribute Can not Migrated

Hiii,

I Migrated all data using ubdatamigration. but customer attributes of 1.9.2 not migrated to magento 2.
Please help me for customer attributes & attribute data .

Thanks & Regards
Praveen

Error 500 mysqli_connect(): on step 1

After installing the module on Bitnami's Magento 2 ami, I get this error after step 1:

Error 500
mysqli_connect(): php_network_getaddresses: getaddrinfo failed: Name or service not known

New db was created and privileges set.
I tried using localhost/127.0.0.1 as well as socket connection for host field
Tried with root db user as well.
Magento was upgraded to 2.0.2 beforehand
I did mess around with file/folder permissions after Magento upgrade
Didn't try on localhost

404 Backend Error when viewing UB Data Migration Tab in backend

We get a 404 error when viewing the UB Data Migration Tab in backend. Not the hole site but after the headline "UB Data Migration".

Maybe this is related to the nginx standard configuration file located in the magneto root and showing:

---

location /pub {
location ~ ^/pub/media/(downloadable|customer|import|theme_customization/.*.xml) {
deny all;
}
alias $MAGE_ROOT/pub;
add_header X-Frame-Options "SAMEORIGIN";

}

I think its not possible here to run the index.php file or am i wrong?

Thanks!

Step 6 Issue The table "{{tax_class}}" for active record class "Mage1TaxClass" cannot be found in the database.

Hi, friends,

I get this error in step 6 of migration process from Magento 1.7.2 to 2.0.11:
The table "{{tax_class}}" for active record class "Mage1TaxClass" cannot be found in the database.

\pub\ub-tool\yii\db\ar\CActiveRecord.php(2385)
2385 throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.',

\pub\ub-tool\protected\controllers\MigrateController.php(1821): CActiveRecord->findByPk("3")
1821 $tax_class1 = Mage1TaxClass::model()->findByPk($customer_group2->tax_class_id);

I think I'm using last update.

Could anyone help, please?

Thanks in advance

Magento 2.1.8 include(Mage1WebsitePeer.php):

Error 500
include(Mage1WebsitePeer.php):

vagrant@vagrant:/vagrant$ php -v PHP 7.0.22-1~dotdeb+8.1 (cli) ( NTS ) Copyright (c) 1997-2017 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies with Zend OPcache v7.0.22-1~dotdeb+8.1, Copyright (c) 1999-2017, by Zend Technologies vagrant@vagrant:/vagrant$ magento -version Magento CLI version 2.1.8

Downloaded from https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-tool/

Unable to unserialize value. Error: Syntax error

Hi, after successfully migration all of the products , customers , orders etc . I can see them in the admin panel. But when I am accessing the order view page:
{base_url}admin/sales/order/view/order_id/8276/key/d8552eb3065f5435cf121462e5296f25ea82bf953414d5cc8c0ebece615a0e70/

A report is generated , with this content:

{"0":"Unable to unserialize value. Error: Syntax error","1":"<pre>#1 Magento\\Framework\\Model\\ResourceModel\\AbstractResource->_unserializeField() called at [vendor\/magento\/framework\/Model\/ResourceModel\/Db\/AbstractDb.php:507]\n#2 Magento\\Framework\\Model\\ResourceModel\\Db\\AbstractDb->unserializeFields() called at [vendor\/magento\/module-sales\/Model\/ResourceModel\/Order\/Item\/Collection.php:62]\n#3 Magento\\Sales\\Model\\ResourceModel\\Order\\Item\\Collection->_afterLoad() called at [vendor\/magento\/framework\/Data\/Collection\/AbstractDb.php:594]\n#4 Magento\\Framework\\Data\\Collection\\AbstractDb->loadWithFilter() called at [vendor\/magento\/framework\/Data\/Collection\/AbstractDb.php:565]\n#5 Magento\\Framework\\Data\\Collection\\AbstractDb->load() called at [vendor\/magento\/framework\/Data\/Collection.php:333]\n#6 Magento\\Framework\\Data\\Collection->getItems() called at [vendor\/magento\/module-sales\/Model\/Order\/ItemRepository.php:129]\n#7 Magento\\Sales\\Model\\Order\\ItemRepository->getList() called at [vendor\/magento\/module-sales\/Model\/Order.php:2118]\n#8 Magento\\Sales\\Model\\Order->getItems() called at [generated\/code\/Magento\/Sales\/Model\/Order\/Interceptor.php:1259]\n#9 Magento\\Sales\\Model\\Order\\Interceptor->getItems() called at [vendor\/magento\/module-sales\/Model\/Order\/ShippingAssignmentBuilder.php:86]\n#10 Magento\\Sales\\Model\\Order\\ShippingAssignmentBuilder->create() called at [vendor\/magento\/module-sales\/Model\/OrderRepository.php:289]\n#11 Magento\\Sales\\Model\\OrderRepository->setShippingAssignments() called at [vendor\/magento\/module-sales\/Model\/OrderRepository.php:143]\n#12 Magento\\Sales\\Model\\OrderRepository->get() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#13 Magento\\Sales\\Model\\OrderRepository\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#14 Magento\\Sales\\Model\\OrderRepository\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#15 Magento\\Sales\\Model\\OrderRepository\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Sales\/Model\/OrderRepository\/Interceptor.php:26]\n#16 Magento\\Sales\\Model\\OrderRepository\\Interceptor->get() called at [vendor\/magento\/module-sales\/Controller\/Adminhtml\/Order.php:155]\n#17 Magento\\Sales\\Controller\\Adminhtml\\Order->_initOrder() called at [vendor\/magento\/module-sales\/Controller\/Adminhtml\/Order\/View.php:26]\n#18 Magento\\Sales\\Controller\\Adminhtml\\Order\\View->execute() called at [generated\/code\/Magento\/Sales\/Controller\/Adminhtml\/Order\/View\/Interceptor.php:24]\n#19 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->execute() called at [vendor\/magento\/framework\/App\/Action\/Action.php:108]\n#20 Magento\\Framework\\App\\Action\\Action->dispatch() called at [vendor\/magento\/module-backend\/App\/AbstractAction.php:231]\n#21 Magento\\Backend\\App\\AbstractAction->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#22 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#23 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/module-backend\/App\/Action\/Plugin\/Authentication.php:143]\n#24 Magento\\Backend\\App\\Action\\Plugin\\Authentication->aroundDispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:135]\n#25 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#26 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Sales\/Controller\/Adminhtml\/Order\/View\/Interceptor.php:39]\n#27 Magento\\Sales\\Controller\\Adminhtml\\Order\\View\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/FrontController.php:159]\n#28 Magento\\Framework\\App\\FrontController->processRequest() called at [vendor\/magento\/framework\/App\/FrontController.php:98]\n#29 Magento\\Framework\\App\\FrontController->dispatch() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:58]\n#30 Magento\\Framework\\App\\FrontController\\Interceptor->___callParent() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:138]\n#31 Magento\\Framework\\App\\FrontController\\Interceptor->Magento\\Framework\\Interception\\{closure}() called at [vendor\/magento\/framework\/Interception\/Interceptor.php:153]\n#32 Magento\\Framework\\App\\FrontController\\Interceptor->___callPlugins() called at [generated\/code\/Magento\/Framework\/App\/FrontController\/Interceptor.php:26]\n#33 Magento\\Framework\\App\\FrontController\\Interceptor->dispatch() called at [vendor\/magento\/framework\/App\/Http.php:137]\n#34 Magento\\Framework\\App\\Http->launch() called at [generated\/code\/Magento\/Framework\/App\/Http\/Interceptor.php:24]\n#35 Magento\\Framework\\App\\Http\\Interceptor->launch() called at [vendor\/magento\/framework\/App\/Bootstrap.php:261]\n#36 Magento\\Framework\\App\\Bootstrap->run() called at [pub\/index.php:40]\n<\/pre>","url":"\/mmanager\/sales\/order\/view\/order_id\/8276\/key\/d8552eb3065f5435cf121462e5296f25ea82bf953414d5cc8c0ebece615a0e70\/","script_name":"\/index.php"}

My environment:
Magento: 2.3.3
Ub-tool: 3.2.3

Any advice on how to fix this ? Thank you in advance :)

Unable to install it

Get a 500 error after install

I followed your directions, but after I install I get a 500 error.

After I run:

$ php -f ./bin/magento setup:upgrade

I get:

Cache cleared successfully
File system cleanup:
/var/www/html/magento/var/generation/Composer
/var/www/html/magento/var/generation/Magento
/var/www/html/magento/var/generation/Symfony
The directory '/var/www/html/magento/var/di/' doesn't exist - skipping cleanup
Updating modules:
Schema creation/updates:
Module 'Magento_Store':
Module 'Magento_AdvancedPricingImportExport':
...
Please re-run Magento compile command

At this point I can't access the site and am getting a 500 error.

I then tried running:

$ magento setup:di:compile

And I get:

Compilation was started.
Repositories code generation... 1/7 [====>-----------------------]  14%
3 secs 43.0 MiBPHP Fatal error:  Class 'CComponent' not found in /var/www/html/magento/vendor/ubertheme/module-ubdatamigration/lib/yii/base/CApplicationComponent.php on line 26

Step 7 Issue - Migrate Sales Data

Hello

I get the following error when trying to complete the Step 7:

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'converted_at' at row 1. The SQL statement executed was: INSERT INTO quote (store_id, updated_at, is_active, is_virtual, is_multi_shipping, items_count, items_qty, orig_order_id, store_to_base_rate, store_to_quote_rate, grand_total, base_grand_total, customer_group_id, customer_note_notify, customer_is_guest, trigger_recollect, is_persistent, entity_id, created_at, converted_at, base_currency_code, store_currency_code, quote_currency_code, checkout_method, customer_tax_class_id, remote_ip, applied_rule_ids, reserved_order_id, global_currency_code, base_to_global_rate, base_to_quote_rate, subtotal, base_subtotal, subtotal_with_discount, base_subtotal_with_discount, is_changed) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35)

It seems there is an incorrect datetime default value that is not accepted by Magento2 DB.
Can you please help me solve this issue?

Thanks.

CDbException.pdf

step 7 error to migrate sales

Hi,
i have migrate 1 to 6 step fine.
On step 7 (sales migration) i received the message on the browser: "the connection is canceled" after 5/10min.

How can i solve it?

Thanks

start migration from command line

Hi, first of all thank you very much for creating this tool.

I work on shop which has 25000 simple products and 4400 grouped products. It takes several hours to finish the migration. Is it possible to add a functionality which starts the tool or a step like product migration from the command line using the php cli?

customer flat grid empty after migration and reindex

Hi

I had migrated from 1.9 to Magento 2. All seems to be working fine except customer_grid_flat table is empty. Even after reindex this table is empty and not showing any error while reindex. Because of this I dont see customer data in backend and while placing order in frontend I am getting some error.

Strange thing is it shows status Processing for customer grid reindex which is not changing.

NOTICE : while migration I see following warning message for customer migration.
Mage2CustomerAddressEntityText not valid value

I dont know how to fix this issue can some one help here please.

Thanks,
Mitesh

Data Migration Tool failing on Settings

Hello,

I'm dealing with the connection issue and on Nexcess hosting.
I've tried the IP of the host, and name as well as localhost but all with the same error...

Couldn't connected to Magento 1 database: Access denied for user 'username'@'localhost' (using password: )Also, attached the screenshot.

I am migrating data from Magento 1.7.2 to Magento 2.1.2

Please help!

mysqli_connect(): Headers and client library minor version mismatch

Hello after clicking start this is the error I'm facing:
mysqli_connect(): Headers and client library minor version mismatch. Headers:50547 Library:100024
The installations of Magento 1.9.2.3 and 2.0.2 are on the same server and use PHP 5.5 and Maria Db 10.

Any idea what can cause this?
Thanks

unserialize() error

Guys is it work with Magento 2.2.0 yet?
Getting error right after open the page.

Notice: unserialize(): Unexpected end of serialized data in /home/localdev/public_html/migra/yii/caching/CCache.php on line 108

Notice: unserialize(): Error at offset 0 of 1 bytes in /home/localdev/public_html/migra/yii/caching/CCache.php on line 108

Can't compile di, Class >'CDbSchema' not found in

php bin/magento setup:di:compile

Compilation was started.
Repositories code generation... 1/7 [====>-----------------------] 14% 1 sec 54.0 MiBPHP Fatal error: Class >'CDbSchema' not found in /app/app/code/Ubertheme/Ubdatamigration/lib/yii/db/schema/oci/COciSchema.php on line 19

Magento CE 2.1.4
Ubertheme_Ubdatamigration 1.0.6 Lite version

Can't compile

php -f ./bin/magento setup:di:compile, produces an error:

Compilation was started.
Repositories code generation... 1/7 [====>-----------------------] 14% 2 secs 53.2 MiBPHP Fatal error: Class 'CComponent' not found in /var/www/html/magento/vendor/ubertheme/module-ubdatamigration/lib/yii/base/CApplicationComponent.php on line 26

Fatal Error after installation Magento 2.0.9

Hi

After i installed extension i got fatal error below: Any idea how to sort the problem?

Fatal error: Uncaught exception 'Magento\Framework\Exception\LocalizedException' with message 'Can't create directory /home/pashiminatest/public_html/var/generation/Magento/Framework/App/ResourceConnection/.' in /home/pashiminatest/public_html/vendor/magento/framework/Code/Generator.php:103 Stack trace: #0 /home/pashiminatest/public_html/vendor/magento/framework/Code/Generator/Autoloader.php(35): Magento\Framework\Code\Generator->generateClass('Magento\Framewo...') #1 [internal function]: Magento\Framework\Code\Generator\Autoloader->load('Magento\Framewo...') #2 [internal function]: spl_autoload_call('Magento\Framewo...') #3 /home/pashiminatest/public_html/vendor/magento/framework/Code/Reader/ClassReader.php(19): ReflectionClass->__construct('Magento\Framewo...') #4 /home/pashiminatest/public_html/vendor/magento/framework/ObjectManager/Definition/Runtime.php(44): Magento\Framework\Code\Reader\ClassReader->getConstructor('Magento\Framewo...') #5 /home/pashiminatest/public_html/vendor/magento/framework/ObjectManager/Fa in /home/pashiminatest/public_html/vendor/magento/framework/Code/Generator.php on line 103

Missing permissions mkdir

Hello!

I have come across following problem:

a:4:{i:0;s:128:"Warning: mkdir(): Permission denied in /var/www/html/magento2/vendor/ubertheme/module-ubdatamigration/Helper/File.php on line 33";i:1;s:7188:"#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'mkdir(): Permis...', '/var/www/html/m...', 33, Array)
#1 /var/www/html/magento2/vendor/ubertheme/module-ubdatamigration/Helper/File.php(33): mkdir('/var/www/html/m...', 509)
#2 /var/www/html/magento2/vendor/ubertheme/module-ubdatamigration/Controller/Adminhtml/Index/Index.php(48): Ubertheme\Ubdatamigration\Helper\File::xcopy('/var/www/html/m...', '/var/www/html/m...', 509)
#3 /var/www/html/magento2/var/generation/Ubertheme/Ubdatamigration/Controller/Adminhtml/Index/Index/Interceptor.php(25): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index->execute()
#4 /var/www/html/magento2/lib/internal/Magento/Framework/App/Action/Action.php(102): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor->execute()
#5 /var/www/html/magento2/app/code/Magento/Backend/App/AbstractAction.php(226): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http))
#6 [internal function]: Magento\Backend\App\AbstractAction->dispatch(Object(Magento\Framework\App\Request\Http))
#7 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(74): call_user_func_array(Array, Array)
#8 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(70): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor->___callParent('dispatch', Array)
#9 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Ubertheme\Ubdat...', 'dispatch', Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Array, 'adminAuthentica...')
#10 /var/www/html/magento2/app/code/Magento/Backend/App/Action/Plugin/Authentication.php(143): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain{closure}(Object(Magento\Framework\App\Request\Http))
#11 [internal function]: Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#12 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(67): call_user_func_array(Array, Array)
#13 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Ubertheme\Ubdat...', 'dispatch', Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Array, 'designLoader')
#14 /var/www/html/magento2/lib/internal/Magento/Framework/App/Action/Plugin/Design.php(39): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain{closure}(Object(Magento\Framework\App\Request\Http))
#15 [internal function]: Magento\Framework\App\Action\Plugin\Design->aroundDispatch(Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#16 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(67): call_user_func_array(Array, Array)
#17 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(136): Magento\Framework\Interception\Chain\Chain->invokeNext('Ubertheme\Ubdat...', 'dispatch', Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Array, 'adminMassaction...')
#18 /var/www/html/magento2/app/code/Magento/Backend/App/Action/Plugin/MassactionKey.php(33): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor->Magento\Framework\Interception{closure}(Object(Magento\Framework\App\Request\Http))
#19 [internal function]: Magento\Backend\App\Action\Plugin\MassactionKey->aroundDispatch(Object(Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#20 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(140): call_user_func_array(Array, Array)
#21 /var/www/html/magento2/var/generation/Ubertheme/Ubdatamigration/Controller/Adminhtml/Index/Index/Interceptor.php(53): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor->___callPlugins('dispatch', Array, Array)
#22 /var/www/html/magento2/lib/internal/Magento/Framework/App/FrontController.php(55): Ubertheme\Ubdatamigration\Controller\Adminhtml\Index\Index\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#23 [internal function]: Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http))
#24 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(74): call_user_func_array(Array, Array)
#25 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(70): Magento\Framework\App\FrontController\Interceptor->___callParent('dispatch', Array)
#26 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Framewo...', 'dispatch', Object(Magento\Framework\App\FrontController\Interceptor), Array, 'install')
#27 /var/www/html/magento2/lib/internal/Magento/Framework/Module/Plugin/DbStatusValidator.php(69): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain{closure}(Object(Magento\Framework\App\Request\Http))
#28 [internal function]: Magento\Framework\Module\Plugin\DbStatusValidator->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#29 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Chain/Chain.php(67): call_user_func_array(Array, Array)
#30 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(136): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Framewo...', 'dispatch', Object(Magento\Framework\App\FrontController\Interceptor), Array, 'storeCookieVali...')
#31 /var/www/html/magento2/app/code/Magento/Store/Model/Plugin/StoreCookie.php(78): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception{closure}(Object(Magento\Framework\App\Request\Http))
#32 [internal function]: Magento\Store\Model\Plugin\StoreCookie->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#33 /var/www/html/magento2/lib/internal/Magento/Framework/Interception/Interceptor.php(140): call_user_func_array(Array, Array)
#34 /var/www/html/magento2/var/generation/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#35 /var/www/html/magento2/lib/internal/Magento/Framework/App/Http.php(115): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#36 /var/www/html/magento2/lib/internal/Magento/Framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#37 /var/www/html/magento2/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#38 {main}";s:3:"url";s:113:"/magento2/admin/ubdatamigration/index/index/key/4e06061fab34eef491816417bcdd7b559bc375571c003183be71b0edd8d109d7/";s:11:"script_name";s:19:"/magento2/index.php";}

It seems to be missing some permissions, but there is no such problems with other than this extension it seems.

Any ideas?

Thanks,
Stian

CDbConnection failed to open the DB connection: could not find driver

Hello,

How to fix this error, please …

404 Not Found after Install

Steps:

• Clean Mage2 install
• Install from steps listed UBDataMigration
• Flush/Refresh all cache - bin/magento cache:clean, bin/magento cache:flush
• Re-compile bin/magento bin/magento setup:di:compile
• Rebuild all static resources bin/magento setup:static-content:deploy

404 Error is specifically: The requested URL /pub/ub-tool/ was not found on this server.

Viewing folder structure, that folder does exist, with only one folder within,

• ub-tool
  • yii

No index or htaccess within ub-tool folder (not sure if that matters but wanted to point it out).

Configurable products don't migrate.

Simple products works, but migration module didn't recognize configurable products from the source store.

Any ideas?

CDbException

Hi,
https://github.com/ubertheme/module-ubdatamigration/blob/master/README.md

I have upload your module-ubdatamigration in my local system for data migration magento 1.9.1.1 to magento 2.0.
Its working fine till 3 step but Getting error in Step-4 : Migrate Category

Error:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicata du champ 'home-1' pour la clef 'URL_REWRITE_REQUEST_PATH_STORE_ID'. The SQL statement executed was: INSERT INTO url_rewrite (redirect_type, is_autogenerated, entity_type, entity_id, request_path, target_path, store_id, description, metadata) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8)

pub\ub-tool\yii\db\CDbCommand.php(358)

Can you please help me?
Thanks

Php version

Magento 1.9.X is working with PHP 5.5, but Mangeto2 is working with PHP 5.6!
How can I have different php's in the same server?
Regards
Emil

Cannot Go to Next Step (Redirecting to Magento 2 Installation)

Hi. Thanks for the tool.

I was able to install the tool and connect the databases (Database settings). But when I click on "Next Step" to go to "Migrate Website/ Stores", it takes me directly to the new Magento website with no options to continue the migration. Any tricks?

Thanks

Error in enabling module

When using in WinSCP
php -f magento module:enable --clear-static-content Ubertheme_Ubdatamigration
error
bin/magento must be run as a CLI application

In Putty error is
Magento supports PHP 5.5.0 or later but I'm using php 5.6 in siteground

Can you help ?

not matching with PHP version 7.1.12.0

Hi,

i am getting the following error when i tried to pull it from magento repo

Could not find package ubertheme/module-ubdatamigration at any version matching your PHP version 7.1.12.0

Do you support nginx?

Looks like with nginx all rewrites are broken. Can you help?

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'petshop_new.catalogsearch_fulltext_scope3' doesn't exist'

successfully migrate but once i want to edit products it gives me error.

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'petshop_new.catalogsearch_fulltext_scope3' doesn't exist' in C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement\Pdo.php:228 Stack trace: #0 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array) #1 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Statement\Pdo\Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #2 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #3 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array) #4 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('DELETE FROM ca...', Array) #5 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Adapter\Pdo\Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('DELETE FROMca...', Array) #6 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Adapter\Pdo\Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('DELETE FROM ca...', Array) #7 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Abstract.php(664): Magento\Framework\DB\Adapter\Pdo\Mysql->query('DELETE FROMca...') #8 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\IndexerHandler.php(106): Zend_Db_Adapter_Abstract->delete('catalogsearch_f...', Array) #9 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext.php(91): Magento\CatalogSearch\Model\Indexer\IndexerHandler->deleteIndex(Array, Object(ArrayObject)) #10 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext.php(142): Magento\CatalogSearch\Model\Indexer\Fulltext->execute(Array) #11 C:\xampp\htdocs\petshop_new\app\code\Magento\Indexer\Model\Indexer.php(433): Magento\CatalogSearch\Model\Indexer\Fulltext->executeRow('1') #12 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\AbstractPlugin.php(34): Magento\Indexer\Model\Indexer->reindexRow('1') #13 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product.php(26): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\AbstractPlugin->reindexRow('1') #14 [internal function]: Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin{closure}() #15 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Model\ResourceModel\AbstractResource.php(94): call_user_func(Object(Closure)) #16 C:\xampp\htdocs\petshop_new\var\generation\Magento\Catalog\Model\ResourceModel\Product\Interceptor.php(713): Magento\Framework\Model\ResourceModel\AbstractResource->commit() #17 C:\xampp\htdocs\petshop_new\app\code\Magento\Eav\Model\Entity\AbstractEntity.php(1156): Magento\Catalog\Model\ResourceModel\Product\Interceptor->commit() #18 [internal function]: Magento\Eav\Model\Entity\AbstractEntity->save(Object(Magento\Catalog\Model\Product\Interceptor)) #19 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Interceptor.php(74): call_user_func_array(Array, Array) #20 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(70): Magento\Catalog\Model\ResourceModel\Product\Interceptor->___callParent('save', Array) #21 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Catalog...', 'save', Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Array, 'catalogsearchFu...') #22 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product.php(28): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain{closure}(Object(Magento\Catalog\Model\Product\Interceptor)) #23 [internal function]: Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->aroundSave(Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor)) #24 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(68): call_user_func_array(Array, Array) #25 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Interceptor.php(136): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Catalog...', 'save', Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Array, 'apply_catalog_r...') #26 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogRule\Plugin\Indexer\Product\Save\ApplyRules.php(40): Magento\Catalog\Model\ResourceModel\Product\Interceptor-

step 7 error to migrate sales (Customer Taxvat is too long)

Hi,

first of thanks for this very awesome tool, it's very handy!

Migration from Point 1 to 6 works smoothly, but at Point 7 (Sales Data Migration) it seems like
it went through all the data but failed in the end somehow and I can't proceed from there.

Error Message:
Customer Taxvat is too long (maximum is 32 characters)

Error 500
implode(): Invalid arguments passed.

I'm using PHP 7.0.3 + Apache + MySQL 5.7.10

Any advice how to fix it ?

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'low_stock_date' at row 1. The SQL statement executed was: INSERT INTOcataloginventory_stock_item(product_id,stock_id,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,qty,low_stock_date,notify_stock_qty`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24)

/opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/db/CDbCommand.php(358)

346 {
347 if($this->_connection->enableProfiling)
348 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349
350 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351 $message=$e->getMessage();
352 Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354
355 if(YII_DEBUG)
356 $message.='. The SQL statement executed was: '.$this->getText().$par;
357
358 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360 }
361 }
362
363 /**
364 * Executes the SQL statement and returns query result.
365 * This method is for executing an SQL query that returns result set.
366 * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367 * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368 * them in this way can improve the performance. Note that if you pass parameters in this way,
369 * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370 * Please also note that all values are treated as strings in this case, if you need them to be handled as`

Stack Trace

`Stack Trace
#0

• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(1080): CDbCommand->execute()
  #1
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/db/ar/CActiveRecord.php(809): CActiveRecord->insert(null)
  #2
  – /opt/bitnami/apps/magento/htdocs/pub/ub-tool/protected/controllers/MigrateController.php(1371): CActiveRecord->save()
  1366 $stock_item2->$key = $stock_item->$key;
  1367 }
  1368 }
  1369 //this field is new in Magento 2
  1370 $stock_item2->website_id = $website_id;
  1371 $stock_item2->save();
  1372 }
  1373 }
  1374 }
  1375 }
  1376 }
  #3
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/actions/CInlineAction.php(49): MigrateController->actionStep5()
  #4
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/CController.php(308): CInlineAction->runWithParams(array())
  #5
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/CController.php(286): CController->runAction(CInlineAction)
  #6
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/CController.php(265): CController->runActionWithFilters(CInlineAction, array())
  #7
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/CWebApplication.php(282): CController->run("step5")
  #8
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/web/CWebApplication.php(141): CWebApplication->runController("migrate/step5")
  #9
• /opt/bitnami/apps/magento/htdocs/pub/ub-tool/yii/base/CApplication.php(184): CWebApplication->processRequest()
  #10
  – /opt/bitnami/apps/magento/htdocs/pub/ub-tool/index.php(13): CApplication->run()
  08 // change the following paths if necessary
  09 $yii=dirname(FILE).'/yii/yii.php';
  10 $config=dirname(FILE).'/protected/config/main.php';
  11
  12 require_once($yii);
  13 Yii::createWebApplication($config)->run();`

Step 2 error on multi website setup.

I have a multi website setup and can't get passed step 2 when I select all websites.
Migrating from 1.9.2.3 to 2.0.2 fresh install.

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO `store_website` (`sort_order`, `default_group_id`, `is_default`, `website_id`, `code`, `name`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5)

C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\db\CDbCommand.php(358)

346         {
347             if($this->_connection->enableProfiling)
348                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349 
350             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351             $message=$e->getMessage();
352             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354 
355             if(YII_DEBUG)
356                 $message.='. The SQL statement executed was: '.$this->getText().$par;
357 
358             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360         }
361     }
362 
363     /**
364      * Executes the SQL statement and returns query result.
365      * This method is for executing an SQL query that returns result set.
366      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368      * them in this way can improve the performance. Note that if you pass parameters in this way,
369      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370      * Please also note that all values are treated as strings in this case, if you need them to be handled as
Stack Trace
#0  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\db\ar\CActiveRecord.php(1080): CDbCommand->execute()
#1  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\db\ar\CActiveRecord.php(809): CActiveRecord->insert(null)
#2  
–  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\protected\controllers\MigrateController.php(266): CActiveRecord->save()
261                             $website2->name = $website->name;
262                             $website2->sort_order = $website->sort_order;
263                             $website2->default_group_id = $website->default_group_id;
264                             $website2->is_default = $website->is_default;
265 
266                             if ($website2->save()) {
267                                 //update to log
268                                 $migrated_website_ids[] = $website->website_id;
269 
270                                 if ($store_group_ids && isset($store_group_ids[$website->website_id])) {
271                                     //Migrate store group of this website
#3  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\actions\CInlineAction.php(49): MigrateController->actionStep2()
#4  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\CController.php(308): CInlineAction->runWithParams(array())
#5  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\CController.php(286): CController->runAction(CInlineAction)
#6  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\CController.php(265): CController->runActionWithFilters(CInlineAction, array())
#7  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\CWebApplication.php(282): CController->run("step2")
#8  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\web\CWebApplication.php(141): CWebApplication->runController("migrate/step2")
#9  
+  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\yii\base\CApplication.php(184): CWebApplication->processRequest()
#10 
–  C:\wamp\www\moso\magento2_data_migration-0.1.25\magento2_data_migration-0.1.25\index.php(13): CApplication->run()
08 
09 //remove the following line when in production mode
10 defined('YII_DEBUG') or define('YII_DEBUG', true);
11 
12 require_once($yii);
13 Yii::createWebApplication($config)->run();
2016-02-04 18:17:02 Apache/2.4.9 (Win64) PHP/5.5.12 Yii Framework/1.1.16

cdbexception step 8

Hi, Im trying to use your tool for migration from magento 1.9.2.2 to 2.0.4 , I'm getting *CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. The SQL statement executed was: INSERT INTOreview_entity_summary(entity_pk_value,entity_type,reviews_count,rating_summary,store_id,primary_id) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5) *

on step 8 , any ideas ? Its running on CentOS 6.7 with apache server, I did 777permissions to your tool so they cant be problem. Im using your latest tool ( 1.0.4 )

error step 5

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can't create table `admin_mag`.`catalog_product_entity_tier_price` (errno: 150 "Foreign key constraint is incorrectly formed"). The SQL statement executed was: CREATE TABLE `catalog_product_entity_tier_price` (
`value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
`entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
`all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
`customer_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
`qty` decimal(12,4) NOT NULL DEFAULT '1.0000' COMMENT 'QTY',
`value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
`website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
PRIMARY KEY (`value_id`),
UNIQUE KEY `UNQ_E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';

Fatal error: running bin/magento setup:di:compile

After running bin/magento setup:upgrade, runned bin/magento setup:di:compile

Fatal error: running bin/magento setup:di:compile
--------->
Repositories code generation... 1/7 [====>-----------------------] 14% 2 secs 54.0 MiBPHP Fatal error: Class 'Mage2CatalogProductOptionTypePricePeer' not found in /var/www/clients/client2/web2/web/byvisor/vendor/ubertheme/module-ubdatamigration/lib/protected/models/mage2/Mage2CatalogProductOptionTypePrice.php on line 4

Class 'CController' not found on setup:di:compile

I run php bin/magento setup:di:compile and it gets stuck with this error:

Class 'CController' not found in /chroot/home/.../.../html/app/code/Ubertheme/Ubdatamigration/lib/protected/components/Controller.php on line 7