I have a problem when use data migration tool

Answered

Public

Richard Marken asked December 4, 2015

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento20.catalogsearch_fulltext_scope2' doesn't exist, query was: INSERT INTO `search_tmp_56610931863e83_26874912` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope2` AS `search_index`
 LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id
 LEFT JOIN `catalog_category_product_index` AS `category_ids_index` ON search_index.entity_id = category_ids_index.product_id
 LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = '1' WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 29)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
#0 C:\xampp\htdocs\magento20\vendor\magento\framework\DB\Statement\Pdo\Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 C:\xampp\htdocs\magento20\vendor\magento\zendframework1\library\Zend\Db\Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 C:\xampp\htdocs\magento20\vendor\magento\zendframework1\library\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 C:\xampp\htdocs\magento20\vendor\magento\zendframework1\library\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)
#4 C:\xampp\htdocs\magento20\vendor\magento\framework\DB\Adapter\Pdo\Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `se...', Array)
#5 C:\xampp\htdocs\magento20\vendor\magento\framework\DB\Adapter\Pdo\Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `se...', Array)
#6 C:\xampp\htdocs\magento20\vendor\magento\framework\Search\Adapter\Mysql\TemporaryStorage.php(69): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `se...')
#7 C:\xampp\htdocs\magento20\vendor\magento\framework\Search\Adapter\Mysql\Adapter.php(77): Magento\Framework\Search\Adapter\Mysql\TemporaryStorage->storeDocumentsFromSelect(Object(Magento\Framework\DB\Select))
#8 C:\xampp\htdocs\magento20\vendor\magento\module-search\Model\SearchEngine.php(42): Magento\Framework\Search\Adapter\Mysql\Adapter->query(Object(Magento\Framework\Search\Request))
#9 C:\xampp\htdocs\magento20\vendor\magento\module-catalog-search\Model\ResourceModel\Fulltext\Collection.php(197): Magento\Search\Model\SearchEngine->search(Object(Magento\Framework\Search\Request))
#10 C:\xampp\htdocs\magento20\vendor\magento\framework\Data\Collection\AbstractDb.php(331): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore()
#11 C:\xampp\htdocs\magento20\vendor\magento\module-catalog-search\Model\ResourceModel\Fulltext\Collection.php(224): Magento\Framework\Data\Collection\AbstractDb->_renderFilters()
#12 C:\xampp\htdocs\magento20\vendor\magento\module-eav\Model\Entity\Collection\AbstractCollection.php(906): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFilters()
#13 C:\xampp\htdocs\magento20\vendor\magento\module-catalog\Model\ResourceModel\Product\Collection.php(719): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false)
#14 C:\xampp\htdocs\magento20\vendor\magento\module-review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver.php(38): Magento\Catalog\Model\ResourceModel\Product\Collection->load()
#15 C:\xampp\htdocs\magento20\vendor\magento\framework\Event\Invoker\InvokerDefault.php(73): Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver->execute(Object(Magento\Framework\Event\Observer))
#16 C:\xampp\htdocs\magento20\vendor\magento\framework\Event\Invoker\InvokerDefault.php(61): Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod(Object(Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver), Object(Magento\Framework\Event\Observer))
#17 C:\xampp\htdocs\magento20\vendor\magento\framework\Event\Manager.php(65): Magento\Framework\Event\Invoker\InvokerDefault->dispatch(Array, Object(Magento\Framework\Event\Observer))
#18 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\Event\Manager\Proxy.php(95): Magento\Framework\Event\Manager->dispatch('catalog_block_p...', Array)
#19 C:\xampp\htdocs\magento20\vendor\magento\module-catalog\Block\Product\ListProduct.php(203): Magento\Framework\Event\Manager\Proxy->dispatch('catalog_block_p...', Array)
#20 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Element\AbstractBlock.php(651): Magento\Catalog\Block\Product\ListProduct->_beforeToHtml()
#21 C:\xampp\htdocs\magento20\var\generation\Magento\Catalog\Block\Product\ListProduct\Interceptor.php(882): Magento\Framework\View\Element\AbstractBlock->toHtml()
#22 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(542): Magento\Catalog\Block\Product\ListProduct\Interceptor->toHtml()
#23 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#24 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#25 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('category.produc...')
#26 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('category.produc...', true)
#27 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Element\AbstractBlock.php(492): Magento\Framework\View\Layout\Interceptor->renderElement('category.produc...', true)
#28 C:\xampp\htdocs\magento20\vendor\magento\module-catalog\Block\Category\View.php(98): Magento\Framework\View\Element\AbstractBlock->getChildHtml('product_list')
#29 C:\xampp\htdocs\magento20\vendor\magento\module-catalog\view\frontend\templates\category\products.phtml(18): Magento\Catalog\Block\Category\View->getProductListHtml()
#30 C:\xampp\htdocs\magento20\vendor\magento\framework\View\TemplateEngine\Php.php(59): include('C:\\xampp\\htdocs...')
#31 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Element\Template.php(255): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Catalog\Block\Category\View), 'C:/xampp/htdocs...', Array)
#32 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Element\Template.php(279): Magento\Framework\View\Element\Template->fetchView('C:/xampp/htdocs...')
#33 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Element\AbstractBlock.php(652): Magento\Framework\View\Element\Template->_toHtml()
#34 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#35 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#36 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#37 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('category.produc...')
#38 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('category.produc...', true)
#39 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('category.produc...')
#40 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('content')
#41 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('content')
#42 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('content')
#43 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('content', true)
#44 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('content')
#45 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main')
#46 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main')
#47 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main')
#48 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main', true)
#49 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('main')
#50 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('columns')
#51 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('columns')
#52 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('columns')
#53 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('columns', true)
#54 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('columns')
#55 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main.content')
#56 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.content')
#57 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.content')
#58 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.content', true)
#59 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('main.content')
#60 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#61 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#62 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper')
#63 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', true)
#64 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(569): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper')
#65 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(520): Magento\Framework\View\Layout->_renderContainer('root')
#66 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root')
#67 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(472): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root')
#68 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true)
#69 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Layout.php(938): Magento\Framework\View\Layout\Interceptor->renderElement('root')
#70 [internal function]: Magento\Framework\View\Layout->getOutput()
#71 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Interceptor.php(144): call_user_func_array(Array, Array)
#72 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Layout\Interceptor.php(494): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array)
#73 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Result\Page.php(241): Magento\Framework\View\Layout\Interceptor->getOutput()
#74 C:\xampp\htdocs\magento20\vendor\magento\framework\View\Result\Layout.php(162): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#75 [internal function]: Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#76 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Interceptor.php(74): call_user_func_array(Array, Array)
#77 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Chain\Chain.php(70): Magento\Framework\View\Result\Page\Interceptor->___callParent('renderResult', Array)
#78 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Chain\Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-varnish-...')
#79 C:\xampp\htdocs\magento20\vendor\magento\module-page-cache\Model\Controller\Result\VarnishPlugin.php(74): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#80 [internal function]: Magento\PageCache\Model\Controller\Result\VarnishPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#81 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Chain\Chain.php(68): call_user_func_array(Array, Array)
#82 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Interceptor.php(136): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-builtin-...')
#83 C:\xampp\htdocs\magento20\vendor\magento\module-page-cache\Model\Controller\Result\BuiltinPlugin.php(67): Magento\Framework\View\Result\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#84 [internal function]: Magento\PageCache\Model\Controller\Result\BuiltinPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#85 C:\xampp\htdocs\magento20\vendor\magento\framework\Interception\Interceptor.php(141): call_user_func_array(Array, Array)
#86 C:\xampp\htdocs\magento20\var\generation\Magento\Framework\View\Result\Page\Interceptor.php(130): Magento\Framework\View\Result\Page\Interceptor->___callPlugins('renderResult', Array, Array)
#87 C:\xampp\htdocs\magento20\vendor\magento\framework\App\Http.php(119): Magento\Framework\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#88 C:\xampp\htdocs\magento20\vendor\magento\framework\App\Bootstrap.php(258): Magento\Framework\App\Http->launch()
#89 C:\xampp\htdocs\magento20\index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#90 {main}

Other

9 answers

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone December 4, 2015

Public

Hi Richard Marken,
Can you show me more about your working?
What versions of Magento 1, Magento 2 in your working?
What version of the Migration Tool you are using?
Where did you download the source code of the Migration Tool?
Regards,
Mall.

Vote Up

Vote Down

Richard Marken ⋅70.00 $tone December 4, 2015

Public

Hi Mall,
Thanks for your reply quickly.
I used magento 1.9.1 and magento ce 2.0.
I used this tool https://drive.google.com/file/d/0B4UfTo5yHHTKcGYwd3pqZEFheWs/view?usp=sharing to data migrate.

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone December 4, 2015

Public

Hi Richard Marken,
Yes, did you do exactly steps in guide of this tool?
The guide of this too: https://docs.google.com/document/d/1FmJfDIm8u09m8T9jcCL38t3vRxcKbS7DMltaA2WFUI8/edit
Did you do finished successfully 9 steps of this tool?
Did you re-index the data of Magento2 after the data migrated successfully?
Regards,
Mall.

Vote Up

Vote Down

Richard Marken ⋅70.00 $tone December 4, 2015

Public

Yes. I have migrated sucessfully.
And I just have issue with Store View.
Can you help me?

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone December 4, 2015

Public

Hi Richard Marken,
Did you finished the step IV in guide of this tool? (IV -- After Data Migration Finished (Required))
Regards,
Mall.

Vote Up

Vote Down

Richard Marken ⋅70.00 $tone December 4, 2015

Public

Hi,
I have finished all step

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone December 4, 2015

Public

Hi Richard Marken,
Does your magento2 website working fine before you use this tool to migrate data from your Magento 1.x.
The issue say that, your magento 2 missed some tables in database ‘catalogsearch_fulltext_scope2’ and this table wasn’t related to the Migrate Tool.
For this case, you should re-install the Magento 2 in the database you have migrated by this tool.
Or you can re-install a Fresh Magento 2 website and re-try with this tool once more.
Let’s do it and tell me know how it goes.
Regards,
Mall.

Vote Up

Vote Down

Richard Marken ⋅70.00 $tone December 4, 2015

Public

Hi,
Do you have skype?
Can you discuss this issue via skype?

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone December 4, 2015

Public

Hi Richard Marken,
Let’s follow your private message.
Regards,
Mall.

I have a problem when use data migration tool

9 answers

Please login or Register to Submit Answer

Written By

2 people are following this question.

9 answers

Please login or Register to Submit Answer

Written By

Further Reading

Updates: UB Atoms and UB Bookshop themes updated for CE 2.4.4, PHP 8.1, and more

[Update] 3 more extensions updated for CE 2.4.4, PHP 8.1, and more

[Update] Multiple Magento Extensions updated for CE 2.4.4 and PHP 8.1

Related Questions

2 people are following this question.