cancel
Showing results for 
Search instead for 
Did you mean: 

SQLSTATE Error : After Migrating the content from Magento 1.x to 2.1 !! HELP

SQLSTATE Error : After Migrating the content from Magento 1.x to 2.1 !! HELP

Hi Guys,

 

I Migrated my website from uber theme migration tool everything works quite well, expect the index page, When i click on home page it gives me this error. 

 

ta:4:{i:0;s:1074:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (stock_status_index.stock_status = 1)' at line 4, query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` 
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='3'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (((IFNULL(`e`.`entity_id`, 0) IN (SELECT `catalog_category_product`.`product_id` FROM `catalog_category_product` WHERE (category_id IN ('5')))) AND )) AND (stock_status_index.stock_status = 1)";i:1;s:7561:"#0 /home/plumbli2/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/plumbli2/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /home/plumbli2/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/plumbli2/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 /home/plumbli2/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(459): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 /home/plumbli2/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(514): Magento\Framework\DB\Adapter\Pdo\Mysql->_query(Object(Magento\Framework\DB\Select), Array)
#6 /home/plumbli2/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(828): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#7 /home/plumbli2/public_html/vendor/magento/framework/Data/Collection/AbstractDb.php(218): Zend_Db_Adapter_Abstract->fetchOne(Object(Magento\Framework\DB\Select), Array)
#8 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1272): Magento\Framework\Data\Collection\AbstractDb->getSize()
#9 /home/plumbli2/public_html/vendor/magento/framework/Data/Collection.php(259): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getSize()
#10 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1506): Magento\Framework\Data\Collection->getLastPageNumber()
#11 /home/plumbli2/public_html/vendor/magento/framework/Data/Collection.php(245): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getLastPageNumber()
#12 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1493): Magento\Framework\Data\Collection->getCurPage(0)
#13 /home/plumbli2/public_html/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(1100): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getCurPage()
#14 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1103): Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false)
#15 /home/plumbli2/public_html/vendor/magento/module-eav/Model/Entity/Collection/AbstractCollection.php(910): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->_loadEntities(false, false)
#16 /home/plumbli2/public_html/vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php(727): Magento\Eav\Model\Entity\Collection\AbstractCollection->load(false, false)
#17 /home/plumbli2/public_html/vendor/magento/framework/Interception/Interceptor.php(146): Magento\Catalog\Model\ResourceModel\Product\Collection->load(false, false)
#18 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(195): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->___callPlugins('load', Array, Array)
#19 /home/plumbli2/public_html/vendor/magento/framework/Data/Collection.php(820): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->load()
#20 /home/plumbli2/public_html/var/generation/Magento/Catalog/Model/ResourceModel/Product/Collection/Interceptor.php(1740): Magento\Framework\Data\Collection->getIterator()
#21 /home/plumbli2/public_html/vendor/magento/module-catalog-widget/Block/Product/ProductsList.php(335): Magento\Catalog\Model\ResourceModel\Product\Collection\Interceptor->getIterator()
#22 /home/plumbli2/public_html/var/generation/Magento/CatalogWidget/Block/Product/ProductsList/Interceptor.php(115): Magento\CatalogWidget\Block\Product\ProductsList->getIdentities()
#23 /home/plumbli2/public_html/vendor/magento/module-page-cache/Model/Layout/LayoutPlugin.php(71): Magento\CatalogWidget\Block\Product\ProductsList\Interceptor->getIdentities()
#24 /home/plumbli2/public_html/vendor/magento/framework/Interception/Interceptor.php(152): Magento\PageCache\Model\Layout\LayoutPlugin->afterGetOutput(Object(Magento\Framework\View\Layout\Interceptor), '    <script>\n  ...')
#25 /home/plumbli2/public_html/var/generation/Magento/Framework/View/Layout/Interceptor.php(494): Magento\Framework\View\Layout\Interceptor->___callPlugins('getOutput', Array, Array)
#26 /home/plumbli2/public_html/vendor/magento/framework/View/Result/Page.php(243): Magento\Framework\View\Layout\Interceptor->getOutput()
#27 /home/plumbli2/public_html/vendor/magento/framework/View/Result/Layout.php(164): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#28 /home/plumbli2/public_html/vendor/magento/framework/Interception/Interceptor.php(74): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#29 /home/plumbli2/public_html/vendor/magento/framework/Interception/Chain/Chain.php(70): MGS\Mpanel\Block\Framework\Page\Interceptor->___callParent('renderResult', Array)
#30 /home/plumbli2/public_html/vendor/magento/framework/Interception/Chain/Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('MGS\\Mpanel\\Bloc...', 'renderResult', Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Array, 'result-builtin-...')
#31 /home/plumbli2/public_html/vendor/magento/module-page-cache/Model/Controller/Result/BuiltinPlugin.php(67): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#32 /home/plumbli2/public_html/vendor/magento/framework/Interception/Chain/Chain.php(67): Magento\PageCache\Model\Controller\Result\BuiltinPlugin->aroundRenderResult(Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#33 /home/plumbli2/public_html/vendor/magento/framework/Interception/Interceptor.php(138): Magento\Framework\Interception\Chain\Chain->invokeNext('MGS\\Mpanel\\Bloc...', 'renderResult', Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Array, 'result-varnish-...')
#34 /home/plumbli2/public_html/vendor/magento/module-page-cache/Model/Controller/Result/VarnishPlugin.php(74): MGS\Mpanel\Block\Framework\Page\Interceptor->Magento\Framework\Interception\{closure}(Object(Magento\Framework\App\Response\Http\Interceptor))
#35 /home/plumbli2/public_html/vendor/magento/framework/Interception/Interceptor.php(142): Magento\PageCache\Model\Controller\Result\VarnishPlugin->aroundRenderResult(Object(MGS\Mpanel\Block\Framework\Page\Interceptor), Object(Closure), Object(Magento\Framework\App\Response\Http\Interceptor))
#36 /home/plumbli2/public_html/var/generation/MGS/Mpanel/Block/Framework/Page/Interceptor.php(143): MGS\Mpanel\Block\Framework\Page\Interceptor->___callPlugins('renderResult', Array, Array)
#37 /home/plumbli2/public_html/vendor/magento/framework/App/Http.php(139): MGS\Mpanel\Block\Framework\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#38 /home/plumbli2/public_html/vendor/magento/framework/App/Bootstrap.php(258): Magento\Framework\App\Http->launch()
#39 /home/plumbli2/public_html/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#40 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";}

Any help much appreciated, Thanks 

2 REPLIES

Re: SQLSTATE Error : After Migrating the content from Magento 1.x to 2.1 !! HELP

Hi @saurabhnxtgen,



What is the process you followed for the migration?
Have you followed the Magento migration guide? http://devdocs.magento.com/guides/v2.0/migration/bk-migration-guide.html

 


Best regards.

Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

Re: SQLSTATE Error : After Migrating the content from Magento 1.x to 2.1 !! HELP

Hi 

 

Thanks for your reply, i have followed migration flow diagram.

Yes followed that too. 

 

Also, my products are displaying on backend - but few products are not displaying in front end.