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
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
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.