Back to Questions Page

I get an error when converting products

0 Comment December 24, 2016
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of jukebox-revival jukebox-revival asked December 24, 2016

 I get this error when migration the products from 1.9 to 2.1.3:
 
Mage2StockItem: Notify Stock Qty is too long (maximum is 12 characters).
 
Looks like there is something wrong in the current database ? Any idea where to look for the error?

7 answers

Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone December 24, 2016
Public

Hi jukebox-revival,

Mage2StockItem: Notify Stock Qty is too long (maximum is 12 characters).

That issue come from your Magento1 database has some bad data with notify_stock_qty field in the cataloginventory_stock_item table.
To solve that, let’s do step as bellow:
Step 1: Open the php file at path: pub/ub-tool/protected/controllers/Step5Controller.php
And fine to the code line:

$stockItem2->$key = $stockItem->$key;

and replace it be code lines:

$stockItem2->$key = $stockItem->$key;
if (in_array($key, array('notify_stock_qty')) AND strlen($stockItem2->$key) > 12) {
    $stockItem2->$key = substr($stockItem2->$key, 0, 12);
}

And then, you can continue with data migration in the step #5 and other steps.
And tell me know how it goes.
Regards,
Mall.
 

#1
Vote Up
0
Vote Down
Profile photo of jukebox-revival ⋅2040.00 $tone December 25, 2016
Public

Conversion of products works with no errors but when I open a catagorie to view a product I get this error:
 

2 exception(s):
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jukeboxs_magento.catalogsearch_fulltext_scope3' doesn't exist, query was: INSERT INTO `search_tmp_585f82229589b1_06696377` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope3` 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 = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 16)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC
 LIMIT 10000
Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jukeboxs_magento.catalogsearch_fulltext_scope3' doesn't exist

Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jukeboxs_magento.catalogsearch_fulltext_scope3' doesn't exist, query was: INSERT INTO `search_tmp_585f82229589b1_06696377` SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, (((0)) * 1) AS `score` FROM `catalogsearch_fulltext_scope3` 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 = 0 WHERE (stock_index.stock_status = 1) AND (category_ids_index.category_id = 16)) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC
 LIMIT 10000
#0 /home/jukeboxs/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)
#4 /home/jukeboxs/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(465): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `se...', Array)
#5 /home/jukeboxs/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(520): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `se...', Array)
#6 /home/jukeboxs/public_html/vendor/magento/framework/Search/Adapter/Mysql/TemporaryStorage.php(95): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `se...')
#7 /home/jukeboxs/public_html/vendor/magento/framework/Search/Adapter/Mysql/Adapter.php(79): Magento\Framework\Search\Adapter\Mysql\TemporaryStorage->storeDocumentsFromSelect(Object(Magento\Framework\DB\Select))
#8 /home/jukeboxs/public_html/vendor/magento/module-search/Model/SearchEngine.php(42): Magento\Framework\Search\Adapter\Mysql\Adapter->query(Object(Magento\Framework\Search\Request))
#9 /home/jukeboxs/public_html/vendor/magento/framework/Search/Search.php(72): Magento\Search\Model\SearchEngine->search(Object(Magento\Framework\Search\Request))
#10 /home/jukeboxs/public_html/vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php(327): Magento\Framework\Search\Search->search(Object(Magento\Framework\Api\Search\SearchCriteria))
#11 /home/jukeboxs/public_html/vendor/magento/framework/Data/Collection/AbstractDb.php(338): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore()
#12 /home/jukeboxs/public_html/vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php(361): Magento\Framework\Data\Collection\AbstractDb->_renderFilters()
#13 /home/jukeboxs/public_html/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(906): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFilters()
#14 /home/jukeboxs/public_html/vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php(727): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false)
#15 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false)
#16 /home/jukeboxs/public_html/var/generation/Magento/CatalogSearch/Model/ResourceModel/Fulltext/Collection/Interceptor.php(26): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callPlugins('load', Array, Array)
#17 /home/jukeboxs/public_html/vendor/magento/module-review/Observer/CatalogBlockProductCollectionBeforeToHtmlObserver.php(38): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load()
#18 /home/jukeboxs/public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(73): Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver->execute(Object(Magento\Framework\Event\Observer))
#19 /home/jukeboxs/public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(61): Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod(Object(Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver), Object(Magento\Framework\Event\Observer))
#20 /home/jukeboxs/public_html/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->dispatch(Array, Object(Magento\Framework\Event\Observer))
#21 /home/jukeboxs/public_html/var/generation/Magento/Framework/Event/Manager/Proxy.php(95): Magento\Framework\Event\Manager->dispatch('catalog_block_p...', Array)
#22 /home/jukeboxs/public_html/vendor/magento/module-catalog/Block/Product/ListProduct.php(202): Magento\Framework\Event\Manager\Proxy->dispatch('catalog_block_p...', Array)
#23 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(658): Magento\Catalog\Block\Product\ListProduct->_beforeToHtml()
#24 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#25 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#26 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#27 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(499): Magento\Framework\View\Layout->renderElement('category.produc...', true)
#28 /home/jukeboxs/public_html/vendor/magento/module-catalog/Block/Category/View.php(98): Magento\Framework\View\Element\AbstractBlock->getChildHtml('product_list')
#29 /home/jukeboxs/public_html/vendor/magento/module-catalog/view/frontend/templates/category/products.phtml(18): Magento\Catalog\Block\Category\View->getProductListHtml()
#30 /home/jukeboxs/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/jukeboxs/...')
#31 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(255): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Catalog\Block\Category\View), '/home/jukeboxs/...', Array)
#32 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(279): Magento\Framework\View\Element\Template->fetchView('/home/jukeboxs/...')
#33 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(659): Magento\Framework\View\Element\Template->_toHtml()
#34 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#35 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#36 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#37 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('category.produc...')
#38 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('content')
#39 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('content')
#40 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('content')
#41 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main')
#42 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('main')
#43 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('main')
#44 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('columns')
#45 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('columns')
#46 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('columns')
#47 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main.content')
#48 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('main.content')
#49 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('main.content')
#50 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#51 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#52 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('page.wrapper')
#53 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('root')
#54 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('root')
#55 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(938): Magento\Framework\View\Layout->renderElement('root')
#56 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Framework\View\Layout->getOutput()
#57 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(39): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array)
#58 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Page.php(243): Magento\Framework\View\Layout\Interceptor->getOutput()
#59 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Layout.php(164): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#60 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#61 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\View\Result\Page\Interceptor->___callParent('renderResult', Array)
#62 /home/jukeboxs/public_html/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-...')
#63 /home/jukeboxs/public_html/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))
#64 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\PageCache\Model\Controller\Result\VarnishPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#65 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-builtin-...')
#66 /home/jukeboxs/public_html/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))
#67 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(142): Magento\PageCache\Model\Controller\Result\BuiltinPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#68 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Result/Page/Interceptor.php(26): Magento\Framework\View\Result\Page\Interceptor->___callPlugins('renderResult', Array, Array)
#69 /home/jukeboxs/public_html/vendor/magento/framework/App/Http.php(139): Magento\Framework\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#70 /home/jukeboxs/public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#71 /home/jukeboxs/public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#72 {main}

Exception #1 (PDOException): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jukeboxs_magento.catalogsearch_fulltext_scope3' doesn't exist
#0 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/jukeboxs/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#3 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /home/jukeboxs/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `se...', Array)
#5 /home/jukeboxs/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(465): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `se...', Array)
#6 /home/jukeboxs/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(520): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('INSERT INTO `se...', Array)
#7 /home/jukeboxs/public_html/vendor/magento/framework/Search/Adapter/Mysql/TemporaryStorage.php(95): Magento\Framework\DB\Adapter\Pdo\Mysql->query('INSERT INTO `se...')
#8 /home/jukeboxs/public_html/vendor/magento/framework/Search/Adapter/Mysql/Adapter.php(79): Magento\Framework\Search\Adapter\Mysql\TemporaryStorage->storeDocumentsFromSelect(Object(Magento\Framework\DB\Select))
#9 /home/jukeboxs/public_html/vendor/magento/module-search/Model/SearchEngine.php(42): Magento\Framework\Search\Adapter\Mysql\Adapter->query(Object(Magento\Framework\Search\Request))
#10 /home/jukeboxs/public_html/vendor/magento/framework/Search/Search.php(72): Magento\Search\Model\SearchEngine->search(Object(Magento\Framework\Search\Request))
#11 /home/jukeboxs/public_html/vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php(327): Magento\Framework\Search\Search->search(Object(Magento\Framework\Api\Search\SearchCriteria))
#12 /home/jukeboxs/public_html/vendor/magento/framework/Data/Collection/AbstractDb.php(338): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFiltersBefore()
#13 /home/jukeboxs/public_html/vendor/magento/module-catalog-search/Model/ResourceModel/Fulltext/Collection.php(361): Magento\Framework\Data\Collection\AbstractDb->_renderFilters()
#14 /home/jukeboxs/public_html/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(906): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection->_renderFilters()
#15 /home/jukeboxs/public_html/vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php(727): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false)
#16 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false)
#17 /home/jukeboxs/public_html/var/generation/Magento/CatalogSearch/Model/ResourceModel/Fulltext/Collection/Interceptor.php(26): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->___callPlugins('load', Array, Array)
#18 /home/jukeboxs/public_html/vendor/magento/module-review/Observer/CatalogBlockProductCollectionBeforeToHtmlObserver.php(38): Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection\Interceptor->load()
#19 /home/jukeboxs/public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(73): Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver->execute(Object(Magento\Framework\Event\Observer))
#20 /home/jukeboxs/public_html/vendor/magento/framework/Event/Invoker/InvokerDefault.php(61): Magento\Framework\Event\Invoker\InvokerDefault->_callObserverMethod(Object(Magento\Review\Observer\CatalogBlockProductCollectionBeforeToHtmlObserver), Object(Magento\Framework\Event\Observer))
#21 /home/jukeboxs/public_html/vendor/magento/framework/Event/Manager.php(66): Magento\Framework\Event\Invoker\InvokerDefault->dispatch(Array, Object(Magento\Framework\Event\Observer))
#22 /home/jukeboxs/public_html/var/generation/Magento/Framework/Event/Manager/Proxy.php(95): Magento\Framework\Event\Manager->dispatch('catalog_block_p...', Array)
#23 /home/jukeboxs/public_html/vendor/magento/module-catalog/Block/Product/ListProduct.php(202): Magento\Framework\Event\Manager\Proxy->dispatch('catalog_block_p...', Array)
#24 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(658): Magento\Catalog\Block\Product\ListProduct->_beforeToHtml()
#25 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#26 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#27 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#28 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(499): Magento\Framework\View\Layout->renderElement('category.produc...', true)
#29 /home/jukeboxs/public_html/vendor/magento/module-catalog/Block/Category/View.php(98): Magento\Framework\View\Element\AbstractBlock->getChildHtml('product_list')
#30 /home/jukeboxs/public_html/vendor/magento/module-catalog/view/frontend/templates/category/products.phtml(18): Magento\Catalog\Block\Category\View->getProductListHtml()
#31 /home/jukeboxs/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/jukeboxs/...')
#32 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(255): Magento\Framework\View\TemplateEngine\Php->render(Object(Magento\Catalog\Block\Category\View), '/home/jukeboxs/...', Array)
#33 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/Template.php(279): Magento\Framework\View\Element\Template->fetchView('/home/jukeboxs/...')
#34 /home/jukeboxs/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(659): Magento\Framework\View\Element\Template->_toHtml()
#35 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(542): Magento\Framework\View\Element\AbstractBlock->toHtml()
#36 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(518): Magento\Framework\View\Layout->_renderBlock('category.produc...')
#37 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('category.produc...')
#38 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('category.produc...')
#39 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('content')
#40 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('content')
#41 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('content')
#42 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main')
#43 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('main')
#44 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('main')
#45 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('columns')
#46 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('columns')
#47 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('columns')
#48 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('main.content')
#49 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('main.content')
#50 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('main.content')
#51 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#52 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#53 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(569): Magento\Framework\View\Layout->renderElement('page.wrapper')
#54 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(520): Magento\Framework\View\Layout->_renderContainer('root')
#55 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(472): Magento\Framework\View\Layout->renderNonCachedElement('root')
#56 /home/jukeboxs/public_html/vendor/magento/framework/View/Layout.php(938): Magento\Framework\View\Layout->renderElement('root')
#57 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Framework\View\Layout->getOutput()
#58 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(39): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array)
#59 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Page.php(243): Magento\Framework\View\Layout\Interceptor->getOutput()
#60 /home/jukeboxs/public_html/vendor/magento/framework/View/Result/Layout.php(164): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#61 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#62 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): Magento\Framework\View\Result\Page\Interceptor->___callParent('renderResult', Array)
#63 /home/jukeboxs/public_html/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-...')
#64 /home/jukeboxs/public_html/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))
#65 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\PageCache\Model\Controller\Result\VarnishPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#66 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\\Framewo...', 'renderResult', Object(Magento\Framework\View\Result\Page\Interceptor), Array, 'result-builtin-...')
#67 /home/jukeboxs/public_html/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))
#68 /home/jukeboxs/public_html/vendor/magento/framework/Interception/Interceptor.php(142): Magento\PageCache\Model\Controller\Result\BuiltinPlugin->aroundRenderResult(Object(Magento\Framework\View\Result\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#69 /home/jukeboxs/public_html/var/generation/Magento/Framework/View/Result/Page/Interceptor.php(26): Magento\Framework\View\Result\Page\Interceptor->___callPlugins('renderResult', Array, Array)
#70 /home/jukeboxs/public_html/vendor/magento/framework/App/Http.php(139): Magento\Framework\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#71 /home/jukeboxs/public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#72 /home/jukeboxs/public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#73 {main}
#2
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone December 25, 2016
Public

Hi jukebox-revival,
To solve that, let’s re-index your data after migrated by command: php -f bin/magento indexer:reindex
and then clean the Magento2 cache by command: php -f bin/magento cache:clean
And tell me know how it goes.
Regards,
Mall.

#3
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone December 25, 2016
Public

Hi jukebox-revival,
Did you reindex your data successfully?
You can check index status by command: php -f bin/magento indexer:status
Did you clean the Magento 2 cache after reindex data successfully?
Regards,
Mall.
 

#5

Please login or Register to Submit Answer

Written By

Further Reading

Comments