Try to connect the 1.9 database to the 2.0 database, but whatever I do I’m getting “Couldn’t connected to Magento 1 database: Connection refused”
I have granted all rights etc. Booth servers are with Directadmin.
8 answers
Hi Mall, but how can I add some screenshots here?
Hi Ton Swart,
You can use this tool to capture your screenshot: https://addons.mozilla.org/en-US/firefox/addon/lightshot/
Regards,
Mall.
Hi Ton Swarts,
From the screenshot you provided via email, the reason might be due to connection permission of your Magento 1 database, or you have not enabled remote connection from your M2.
You can check out this post for reference: http://stackoverflow.com/questions/23012836/i-am-unable-to-use-mysql-due-to-a-refused-connection
PS. In case you need to send us screenshot, kindly email us via info (at) ubertheme.com. Sorry for this inconvenience.
Regards,
An Nguyen
Hi there, got the connection working after the remove of 1 line in the my.cnf.
The first 3 items are working, but with number 4 (categories) it stops after a few minutes with a
Whoops, our bad…
The page you requested was not found,
There are 4600 categories and only 200 products.
Thanks
If I now go to products categories etc I’m getting this error:
a:4:{i:0;s:149:”Notice: Undefined offset: 63 in /home/solpin/domains/solpin.org/public_html/vendor/magento/module-eav/Model/ResourceModel/ReadHandler.php on line 166″;i:1;s:7474:”#0 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-eav/Model/ResourceModel/ReadHandler.php(166): Magento\Framework\App\ErrorHandler->handler(8, ‘Undefined offse…’, ‘/home/solpin/do…’, 166, Array) #1 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/EntityManager/Operation/Read/ReadAttributes.php(59): Magento\Eav\Model\ResourceModel\ReadHandler->execute(‘Magento\\Catalog…’, Array, Array) #2 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/EntityManager/Operation/Read.php(116): Magento\Framework\EntityManager\Operation\Read\ReadAttributes->execute(Object(Magento\Catalog\Model\Category\Interceptor), Array) #3 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/EntityManager/EntityManager.php(61): Magento\Framework\EntityManager\Operation\Read->execute(Object(Magento\Catalog\Model\Category\Interceptor), 2, Array) #4 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-catalog/Model/ResourceModel/Category.php(996): Magento\Framework\EntityManager\EntityManager->load(Object(Magento\Catalog\Model\Category\Interceptor), 2) #5 /home/solpin/domains/solpin.org/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Category/Interceptor.php(336): Magento\Catalog\Model\ResourceModel\Category->load(Object(Magento\Catalog\Model\Category\Interceptor), 2, NULL) #6 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Model/AbstractModel.php(531): Magento\Catalog\Model\ResourceModel\Category\Interceptor->load(Object(Magento\Catalog\Model\Category\Interceptor), 2, NULL) #7 /home/solpin/domains/solpin.org/public_html/var/generation/Magento/Catalog/Model/Category/Interceptor.php(1480): Magento\Framework\Model\AbstractModel->load(2, NULL) #8 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-catalog/Controller/Adminhtml/Category.php(40): Magento\Catalog\Model\Category\Interceptor->load(2) #9 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-catalog/Controller/Adminhtml/Category/Edit.php(75): Magento\Catalog\Controller\Adminhtml\Category->_initCategory(true) #10 /home/solpin/domains/solpin.org/public_html/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Edit/Interceptor.php(24): Magento\Catalog\Controller\Adminhtml\Category\Edit->execute() #11 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/App/Action/Action.php(102): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->execute() #12 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-backend/App/AbstractAction.php(226): Magento\Framework\App\Action\Action->dispatch(Object(Magento\Framework\App\Request\Http)) #13 [internal function]: Magento\Backend\App\AbstractAction->dispatch(Object(Magento\Framework\App\Request\Http)) #14 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(74): call_user_func_array(Array, Array) #15 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->___callParent(‘dispatch’, Array) #16 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Catalog…’, ‘dispatch’, Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Array, ‘adminAuthentica…’) #17 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-backend/App/Action/Plugin/Authentication.php(143): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Request\Http)) #18 [internal function]: Magento\Backend\App\Action\Plugin\Authentication->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http)) #19 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Chain/Chain.php(67): call_user_func_array(Array, Array) #20 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Catalog…’, ‘dispatch’, Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Array, ‘adminMassaction…’) #21 /home/solpin/domains/solpin.org/public_html/vendor/magento/module-backend/App/Action/Plugin/MassactionKey.php(33): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http)) #22 [internal function]: Magento\Backend\App\Action\Plugin\MassactionKey->aroundDispatch(Object(Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http)) #23 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(142): call_user_func_array(Array, Array) #24 /home/solpin/domains/solpin.org/public_html/var/generation/Magento/Catalog/Controller/Adminhtml/Category/Edit/Interceptor.php(39): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->___callPlugins(‘dispatch’, Array, Array) #25 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/App/FrontController.php(55): Magento\Catalog\Controller\Adminhtml\Category\Edit\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http)) #26 [internal function]: Magento\Framework\App\FrontController->dispatch(Object(Magento\Framework\App\Request\Http)) #27 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(74): call_user_func_array(Array, Array) #28 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\App\FrontController\Interceptor->___callParent(‘dispatch’, Array) #29 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext(‘Magento\\Framewo…’, ‘dispatch’, Object(Magento\Framework\App\FrontController\Interceptor), Array, ‘install’) #30 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Module/Plugin/DbStatusValidator.php(69): Magento\Framework\App\FrontController\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Request\Http)) #31 [internal function]: Magento\Framework\Module\Plugin\DbStatusValidator->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http)) #32 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/Interception/Interceptor.php(142): call_user_func_array(Array, Array) #33 /home/solpin/domains/solpin.org/public_html/var/generation/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins(‘dispatch’, Array, Array) #34 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/App/Http.php(135): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http)) #35 /home/solpin/domains/solpin.org/public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch() #36 /home/solpin/domains/solpin.org/public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http)) #37 {main}”;s:3:”url”;s:103:”/solpin_53/catalog/category/index/key/5c73abeeccdf5faa37c1447a96da83cc76d4667b5877694ef248e11387e101d4/”;s:11:”script_name”;s:10:”/index.php”;}
Hi Ton Swart,
Let’s reset the step #4 and follow solutions at here:
https://github.com/ubertheme/magento2_data_migration/issues/9
Regards,
Mall.
This question is now closed