database connect

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

Profile photo of Mall Staff 184060.00 $tone June 9, 2016
Public

Hi Ton Swart,
You can use this tool to capture your screenshot: https://addons.mozilla.org/en-US/firefox/addon/lightshot/
Regards,
Mall.

#3
Profile photo of Admin Staff -30640.00 $tone June 9, 2016
Public

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

#4
Profile photo of Ton Swart 50.00 $tone June 10, 2016
Public

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

#5
Profile photo of Ton Swart 50.00 $tone June 10, 2016
Public

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”;}

#6

This question is now closed

Written By

Comments