magento 2 backend customer's order infinite loadingOrder Grid is not showing in Customer->Customer Information(Orders) Admin Panel in Magento-2.1?After upgrading to Magento version 2.2.3 the following errors are shown when running the php binmagento setup:static-content:deploy commandError during compilation after upgrade in magento 2.2.3Showing error of unserialize when run upgrade command in Magento2.2.3magento 2.2.3 custom template not loadingError: “Frame callback host must be instance of MagentoBackendBlockWidget” during Customer EditHow to change “Shipping & Handling” label to “Order Shipping & Handling” in admin order create form?configuration products order issue at Admin sideMagento2.2.2 Backend Curl CURLPROTO_HTTP undefinedmagento 2 existing order editBest Seller Block (links not working) - Magento 2.2

Why return a static pointer instead of an out parameter?

Graduate student with abysmal English writing skills, how to help

Why do people keep referring to Leia as Princess Leia, even after the destruction of Alderaan?

How do native German speakers usually express skepticism (using even) about a premise?

Credit score and financing new car

Benchmark problems for combinatorial multi-objective optimisation

This one's for Matthew:

Why didn't Thanos kill all the Dwarves on Nidavellir?

OR-backed serious games

How to tell someone I'd like to become friends without letting them think I'm romantically interested in them?

Why did Harry Potter get a bedroom?

What's the point of having a RAID 1 configuration over incremental backups to a secondary drive?

How can I fix the dull colors I am getting in Ubuntu 19.04 Terminal?

Should disabled buttons give feedback when clicked?

Is a request to book a business flight ticket for a graduate student an unreasonable one?

How were Martello towers supposed to work?

How are mathematicians paid to do research?

Why does this potentiometer in an op-amp feedback path cause noise when adjusted?

String manipulation with std::adjacent_find

Why was hardware diversification an asset for the IBM PC ecosystem?

Received a dinner invitation through my employer's email, is it ok to attend?

Do I have a right to cancel a purchase of foreign currency in the UK?

How can I effectively communicate to recruiters that a phone call is not possible?

How quality assurance engineers test calculations?



magento 2 backend customer's order infinite loading


Order Grid is not showing in Customer->Customer Information(Orders) Admin Panel in Magento-2.1?After upgrading to Magento version 2.2.3 the following errors are shown when running the php binmagento setup:static-content:deploy commandError during compilation after upgrade in magento 2.2.3Showing error of unserialize when run upgrade command in Magento2.2.3magento 2.2.3 custom template not loadingError: “Frame callback host must be instance of MagentoBackendBlockWidget” during Customer EditHow to change “Shipping & Handling” label to “Order Shipping & Handling” in admin order create form?configuration products order issue at Admin sideMagento2.2.2 Backend Curl CURLPROTO_HTTP undefinedmagento 2 existing order editBest Seller Block (links not working) - Magento 2.2






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?



enter image description here



When ever i visit this page, there is a new line in system.log



[2018-06-08 04:31:53] report.INFO: Broken reference: the 'notification.messages' tries to reorder itself towards 'user', but their parents are different: 'header.inner.right' and 'header' respectively. [] []


Anyone know what is the problem?



-----------update-------------

I found in browser console



1 exception(s):
Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once

Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once
#0 /home/m2vtec/public_html/vendor/magento/framework/DB/Select.php(297): Zend_Db_Select->_join('left join', Array, 'main_table.enti...', Array, NULL)
#1 /home/m2vtec/public_html/vendor/magento/zendframework1/library/Zend/Db/Select.php(378): MagentoFrameworkDBSelect->_join('left join', Array, 'main_table.enti...', Array, NULL)
#2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
#3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))
#4 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(153): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->MagentoFrameworkInterceptionclosure()
#5 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(507): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->___callPlugins('load', Array, Array)
#6 /home/m2vtec/public_html/vendor/magento/framework/Data/Collection.php(831): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->load()
#7 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(999): MagentoFrameworkDataCollection->getIterator()
#8 /home/m2vtec/public_html/vendor/magento/module-backend/view/adminhtml/templates/widget/grid/extended.phtml(183): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->getIterator()
#9 /home/m2vtec/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/m2vtec/pu...')
#10 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(270): MagentoFrameworkViewTemplateEnginePhp->render(Object(MagentoCustomerBlockAdminhtmlEditTabOrders), '/home/m2vtec/pu...', Array)
#11 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(300): MagentoFrameworkViewElementTemplate->fetchView('/home/m2vtec/pu...')
#12 /home/m2vtec/public_html/vendor/magento/module-backend/Block/Template.php(124): MagentoFrameworkViewElementTemplate->_toHtml()
#13 /home/m2vtec/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(667): MagentoBackendBlockTemplate->_toHtml()
#14 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(558): MagentoFrameworkViewElementAbstractBlock->toHtml()
#15 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(534): MagentoFrameworkViewLayout->_renderBlock('adminhtml.custo...')
#16 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('adminhtml.custo...')
#17 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('adminhtml.custo...')
#18 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('adminhtml.custo...', true)
#19 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(585): MagentoFrameworkViewLayoutInterceptor->renderElement('adminhtml.custo...')
#20 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(536): MagentoFrameworkViewLayout->_renderContainer('root')
#21 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('root')
#22 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('root')
#23 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('root', true)
#24 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(954): MagentoFrameworkViewLayoutInterceptor->renderElement('root')
#25 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): MagentoFrameworkViewLayout->getOutput()
#26 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(182): MagentoFrameworkViewLayoutInterceptor->getOutput()
#27 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(170): MagentoFrameworkViewResultLayout->render(Object(MagentoFrameworkAppResponseHttpInterceptor))
#28 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Result/Layout/Interceptor.php(89): MagentoFrameworkViewResultLayout->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#29 /home/m2vtec/public_html/vendor/magento/framework/App/Http.php(139): MagentoFrameworkViewResultLayoutInterceptor->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#30 /home/m2vtec/public_html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): MagentoFrameworkAppHttp->launch()
#31 /home/m2vtec/public_html/vendor/magento/framework/App/Bootstrap.php(256): MagentoFrameworkAppHttpInterceptor->launch()
#32 /home/m2vtec/public_html/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor))
#33 main





magento2.2.3







share|improve this question
























  • How about opening the browser developer tools? I suspect this is JS error.

    – PY Yick
    Jun 8 '18 at 4:54











  • @PYYick yes, there is an error in cosole

    – hkguile
    Jun 8 '18 at 5:01











  • @hkguile, You have any order attribute named company_order ?

    – Vivek
    Jun 8 '18 at 5:01











  • @Vivek i didn't find a attribute named company_order

    – hkguile
    Jun 8 '18 at 5:05











  • I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

    – Vivek
    Jun 8 '18 at 5:07

















0















Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?



enter image description here



When ever i visit this page, there is a new line in system.log



[2018-06-08 04:31:53] report.INFO: Broken reference: the 'notification.messages' tries to reorder itself towards 'user', but their parents are different: 'header.inner.right' and 'header' respectively. [] []


Anyone know what is the problem?



-----------update-------------

I found in browser console



1 exception(s):
Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once

Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once
#0 /home/m2vtec/public_html/vendor/magento/framework/DB/Select.php(297): Zend_Db_Select->_join('left join', Array, 'main_table.enti...', Array, NULL)
#1 /home/m2vtec/public_html/vendor/magento/zendframework1/library/Zend/Db/Select.php(378): MagentoFrameworkDBSelect->_join('left join', Array, 'main_table.enti...', Array, NULL)
#2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
#3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))
#4 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(153): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->MagentoFrameworkInterceptionclosure()
#5 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(507): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->___callPlugins('load', Array, Array)
#6 /home/m2vtec/public_html/vendor/magento/framework/Data/Collection.php(831): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->load()
#7 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(999): MagentoFrameworkDataCollection->getIterator()
#8 /home/m2vtec/public_html/vendor/magento/module-backend/view/adminhtml/templates/widget/grid/extended.phtml(183): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->getIterator()
#9 /home/m2vtec/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/m2vtec/pu...')
#10 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(270): MagentoFrameworkViewTemplateEnginePhp->render(Object(MagentoCustomerBlockAdminhtmlEditTabOrders), '/home/m2vtec/pu...', Array)
#11 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(300): MagentoFrameworkViewElementTemplate->fetchView('/home/m2vtec/pu...')
#12 /home/m2vtec/public_html/vendor/magento/module-backend/Block/Template.php(124): MagentoFrameworkViewElementTemplate->_toHtml()
#13 /home/m2vtec/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(667): MagentoBackendBlockTemplate->_toHtml()
#14 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(558): MagentoFrameworkViewElementAbstractBlock->toHtml()
#15 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(534): MagentoFrameworkViewLayout->_renderBlock('adminhtml.custo...')
#16 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('adminhtml.custo...')
#17 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('adminhtml.custo...')
#18 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('adminhtml.custo...', true)
#19 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(585): MagentoFrameworkViewLayoutInterceptor->renderElement('adminhtml.custo...')
#20 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(536): MagentoFrameworkViewLayout->_renderContainer('root')
#21 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('root')
#22 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('root')
#23 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('root', true)
#24 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(954): MagentoFrameworkViewLayoutInterceptor->renderElement('root')
#25 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): MagentoFrameworkViewLayout->getOutput()
#26 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(182): MagentoFrameworkViewLayoutInterceptor->getOutput()
#27 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(170): MagentoFrameworkViewResultLayout->render(Object(MagentoFrameworkAppResponseHttpInterceptor))
#28 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Result/Layout/Interceptor.php(89): MagentoFrameworkViewResultLayout->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#29 /home/m2vtec/public_html/vendor/magento/framework/App/Http.php(139): MagentoFrameworkViewResultLayoutInterceptor->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#30 /home/m2vtec/public_html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): MagentoFrameworkAppHttp->launch()
#31 /home/m2vtec/public_html/vendor/magento/framework/App/Bootstrap.php(256): MagentoFrameworkAppHttpInterceptor->launch()
#32 /home/m2vtec/public_html/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor))
#33 main





magento2.2.3







share|improve this question
























  • How about opening the browser developer tools? I suspect this is JS error.

    – PY Yick
    Jun 8 '18 at 4:54











  • @PYYick yes, there is an error in cosole

    – hkguile
    Jun 8 '18 at 5:01











  • @hkguile, You have any order attribute named company_order ?

    – Vivek
    Jun 8 '18 at 5:01











  • @Vivek i didn't find a attribute named company_order

    – hkguile
    Jun 8 '18 at 5:05











  • I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

    – Vivek
    Jun 8 '18 at 5:07













0












0








0








Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?



enter image description here



When ever i visit this page, there is a new line in system.log



[2018-06-08 04:31:53] report.INFO: Broken reference: the 'notification.messages' tries to reorder itself towards 'user', but their parents are different: 'header.inner.right' and 'header' respectively. [] []


Anyone know what is the problem?



-----------update-------------

I found in browser console



1 exception(s):
Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once

Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once
#0 /home/m2vtec/public_html/vendor/magento/framework/DB/Select.php(297): Zend_Db_Select->_join('left join', Array, 'main_table.enti...', Array, NULL)
#1 /home/m2vtec/public_html/vendor/magento/zendframework1/library/Zend/Db/Select.php(378): MagentoFrameworkDBSelect->_join('left join', Array, 'main_table.enti...', Array, NULL)
#2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
#3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))
#4 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(153): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->MagentoFrameworkInterceptionclosure()
#5 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(507): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->___callPlugins('load', Array, Array)
#6 /home/m2vtec/public_html/vendor/magento/framework/Data/Collection.php(831): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->load()
#7 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(999): MagentoFrameworkDataCollection->getIterator()
#8 /home/m2vtec/public_html/vendor/magento/module-backend/view/adminhtml/templates/widget/grid/extended.phtml(183): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->getIterator()
#9 /home/m2vtec/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/m2vtec/pu...')
#10 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(270): MagentoFrameworkViewTemplateEnginePhp->render(Object(MagentoCustomerBlockAdminhtmlEditTabOrders), '/home/m2vtec/pu...', Array)
#11 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(300): MagentoFrameworkViewElementTemplate->fetchView('/home/m2vtec/pu...')
#12 /home/m2vtec/public_html/vendor/magento/module-backend/Block/Template.php(124): MagentoFrameworkViewElementTemplate->_toHtml()
#13 /home/m2vtec/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(667): MagentoBackendBlockTemplate->_toHtml()
#14 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(558): MagentoFrameworkViewElementAbstractBlock->toHtml()
#15 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(534): MagentoFrameworkViewLayout->_renderBlock('adminhtml.custo...')
#16 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('adminhtml.custo...')
#17 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('adminhtml.custo...')
#18 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('adminhtml.custo...', true)
#19 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(585): MagentoFrameworkViewLayoutInterceptor->renderElement('adminhtml.custo...')
#20 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(536): MagentoFrameworkViewLayout->_renderContainer('root')
#21 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('root')
#22 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('root')
#23 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('root', true)
#24 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(954): MagentoFrameworkViewLayoutInterceptor->renderElement('root')
#25 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): MagentoFrameworkViewLayout->getOutput()
#26 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(182): MagentoFrameworkViewLayoutInterceptor->getOutput()
#27 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(170): MagentoFrameworkViewResultLayout->render(Object(MagentoFrameworkAppResponseHttpInterceptor))
#28 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Result/Layout/Interceptor.php(89): MagentoFrameworkViewResultLayout->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#29 /home/m2vtec/public_html/vendor/magento/framework/App/Http.php(139): MagentoFrameworkViewResultLayoutInterceptor->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#30 /home/m2vtec/public_html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): MagentoFrameworkAppHttp->launch()
#31 /home/m2vtec/public_html/vendor/magento/framework/App/Bootstrap.php(256): MagentoFrameworkAppHttpInterceptor->launch()
#32 /home/m2vtec/public_html/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor))
#33 main





magento2.2.3







share|improve this question
















Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?



enter image description here



When ever i visit this page, there is a new line in system.log



[2018-06-08 04:31:53] report.INFO: Broken reference: the 'notification.messages' tries to reorder itself towards 'user', but their parents are different: 'header.inner.right' and 'header' respectively. [] []


Anyone know what is the problem?



-----------update-------------

I found in browser console



1 exception(s):
Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once

Exception #0 (Zend_Db_Select_Exception): You cannot define a correlation name 'company_order' more than once
#0 /home/m2vtec/public_html/vendor/magento/framework/DB/Select.php(297): Zend_Db_Select->_join('left join', Array, 'main_table.enti...', Array, NULL)
#1 /home/m2vtec/public_html/vendor/magento/zendframework1/library/Zend/Db/Select.php(378): MagentoFrameworkDBSelect->_join('left join', Array, 'main_table.enti...', Array, NULL)
#2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
#3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))
#4 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(153): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->MagentoFrameworkInterceptionclosure()
#5 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(507): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->___callPlugins('load', Array, Array)
#6 /home/m2vtec/public_html/vendor/magento/framework/Data/Collection.php(831): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->load()
#7 /home/m2vtec/public_html/generated/code/Magento/Sales/Model/ResourceModel/Order/Grid/Collection/Interceptor.php(999): MagentoFrameworkDataCollection->getIterator()
#8 /home/m2vtec/public_html/vendor/magento/module-backend/view/adminhtml/templates/widget/grid/extended.phtml(183): MagentoSalesModelResourceModelOrderGridCollectionInterceptor->getIterator()
#9 /home/m2vtec/public_html/vendor/magento/framework/View/TemplateEngine/Php.php(59): include('/home/m2vtec/pu...')
#10 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(270): MagentoFrameworkViewTemplateEnginePhp->render(Object(MagentoCustomerBlockAdminhtmlEditTabOrders), '/home/m2vtec/pu...', Array)
#11 /home/m2vtec/public_html/vendor/magento/framework/View/Element/Template.php(300): MagentoFrameworkViewElementTemplate->fetchView('/home/m2vtec/pu...')
#12 /home/m2vtec/public_html/vendor/magento/module-backend/Block/Template.php(124): MagentoFrameworkViewElementTemplate->_toHtml()
#13 /home/m2vtec/public_html/vendor/magento/framework/View/Element/AbstractBlock.php(667): MagentoBackendBlockTemplate->_toHtml()
#14 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(558): MagentoFrameworkViewElementAbstractBlock->toHtml()
#15 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(534): MagentoFrameworkViewLayout->_renderBlock('adminhtml.custo...')
#16 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('adminhtml.custo...')
#17 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('adminhtml.custo...')
#18 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('adminhtml.custo...', true)
#19 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(585): MagentoFrameworkViewLayoutInterceptor->renderElement('adminhtml.custo...')
#20 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(536): MagentoFrameworkViewLayout->_renderContainer('root')
#21 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): MagentoFrameworkViewLayout->renderNonCachedElement('root')
#22 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(489): MagentoFrameworkViewLayoutInterceptor->renderNonCachedElement('root')
#23 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): MagentoFrameworkViewLayout->renderElement('root', true)
#24 /home/m2vtec/public_html/vendor/magento/framework/View/Layout.php(954): MagentoFrameworkViewLayoutInterceptor->renderElement('root')
#25 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): MagentoFrameworkViewLayout->getOutput()
#26 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(182): MagentoFrameworkViewLayoutInterceptor->getOutput()
#27 /home/m2vtec/public_html/vendor/magento/framework/View/Result/Layout.php(170): MagentoFrameworkViewResultLayout->render(Object(MagentoFrameworkAppResponseHttpInterceptor))
#28 /home/m2vtec/public_html/generated/code/Magento/Framework/View/Result/Layout/Interceptor.php(89): MagentoFrameworkViewResultLayout->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#29 /home/m2vtec/public_html/vendor/magento/framework/App/Http.php(139): MagentoFrameworkViewResultLayoutInterceptor->renderResult(Object(MagentoFrameworkAppResponseHttpInterceptor))
#30 /home/m2vtec/public_html/generated/code/Magento/Framework/App/Http/Interceptor.php(24): MagentoFrameworkAppHttp->launch()
#31 /home/m2vtec/public_html/vendor/magento/framework/App/Bootstrap.php(256): MagentoFrameworkAppHttpInterceptor->launch()
#32 /home/m2vtec/public_html/index.php(39): MagentoFrameworkAppBootstrap->run(Object(MagentoFrameworkAppHttpInterceptor))
#33 main





magento2.2.3




magento2.2.3






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jul 2 at 6:50









Kirti Nariya

1,6595 silver badges19 bronze badges




1,6595 silver badges19 bronze badges










asked Jun 8 '18 at 4:50









hkguilehkguile

1,0583 gold badges28 silver badges57 bronze badges




1,0583 gold badges28 silver badges57 bronze badges












  • How about opening the browser developer tools? I suspect this is JS error.

    – PY Yick
    Jun 8 '18 at 4:54











  • @PYYick yes, there is an error in cosole

    – hkguile
    Jun 8 '18 at 5:01











  • @hkguile, You have any order attribute named company_order ?

    – Vivek
    Jun 8 '18 at 5:01











  • @Vivek i didn't find a attribute named company_order

    – hkguile
    Jun 8 '18 at 5:05











  • I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

    – Vivek
    Jun 8 '18 at 5:07

















  • How about opening the browser developer tools? I suspect this is JS error.

    – PY Yick
    Jun 8 '18 at 4:54











  • @PYYick yes, there is an error in cosole

    – hkguile
    Jun 8 '18 at 5:01











  • @hkguile, You have any order attribute named company_order ?

    – Vivek
    Jun 8 '18 at 5:01











  • @Vivek i didn't find a attribute named company_order

    – hkguile
    Jun 8 '18 at 5:05











  • I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

    – Vivek
    Jun 8 '18 at 5:07
















How about opening the browser developer tools? I suspect this is JS error.

– PY Yick
Jun 8 '18 at 4:54





How about opening the browser developer tools? I suspect this is JS error.

– PY Yick
Jun 8 '18 at 4:54













@PYYick yes, there is an error in cosole

– hkguile
Jun 8 '18 at 5:01





@PYYick yes, there is an error in cosole

– hkguile
Jun 8 '18 at 5:01













@hkguile, You have any order attribute named company_order ?

– Vivek
Jun 8 '18 at 5:01





@hkguile, You have any order attribute named company_order ?

– Vivek
Jun 8 '18 at 5:01













@Vivek i didn't find a attribute named company_order

– hkguile
Jun 8 '18 at 5:05





@Vivek i didn't find a attribute named company_order

– hkguile
Jun 8 '18 at 5:05













I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

– Vivek
Jun 8 '18 at 5:07





I dont know what is it But its causing issue for your orders grid, Check and find what's company_order what's its relation with order.

– Vivek
Jun 8 '18 at 5:07










2 Answers
2






active

oldest

votes


















0














This issue are raise due to a extension module-company



Seems ,Some mysql join happen happen via this extension,



#2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
#3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))


If you see that error then you understand



MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin
this plugin class is responsible for this error.



If you disabled plugin for this class of this module then you issue will be resolved.






share|improve this answer

























  • I found this module is Magento_Company that is official? You mean disable this module?

    – hkguile
    Jun 8 '18 at 5:29











  • It is don't thought not magento own-mdule

    – Amit Bera♦
    Jun 8 '18 at 5:32


















0














I was having same issue,
This will work if you want to use company-module in Magento.
Finally after some digging we need to add a piece of code to CollectionPlugin.php



before $subject->getSelect()



//bug fixes for customerinfo->ordertab
 $select = $subject->getSelect()->__toString();
 if(preg_match('/company_name/', $select)){
 return [$printQuery, $logQuery];





share|improve this answer

























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "479"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f229095%2fmagento-2-backend-customers-order-infinite-loading%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    This issue are raise due to a extension module-company



    Seems ,Some mysql join happen happen via this extension,



    #2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
    #3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))


    If you see that error then you understand



    MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin
    this plugin class is responsible for this error.



    If you disabled plugin for this class of this module then you issue will be resolved.






    share|improve this answer

























    • I found this module is Magento_Company that is official? You mean disable this module?

      – hkguile
      Jun 8 '18 at 5:29











    • It is don't thought not magento own-mdule

      – Amit Bera♦
      Jun 8 '18 at 5:32















    0














    This issue are raise due to a extension module-company



    Seems ,Some mysql join happen happen via this extension,



    #2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
    #3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))


    If you see that error then you understand



    MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin
    this plugin class is responsible for this error.



    If you disabled plugin for this class of this module then you issue will be resolved.






    share|improve this answer

























    • I found this module is Magento_Company that is official? You mean disable this module?

      – hkguile
      Jun 8 '18 at 5:29











    • It is don't thought not magento own-mdule

      – Amit Bera♦
      Jun 8 '18 at 5:32













    0












    0








    0







    This issue are raise due to a extension module-company



    Seems ,Some mysql join happen happen via this extension,



    #2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
    #3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))


    If you see that error then you understand



    MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin
    this plugin class is responsible for this error.



    If you disabled plugin for this class of this module then you issue will be resolved.






    share|improve this answer















    This issue are raise due to a extension module-company



    Seems ,Some mysql join happen happen via this extension,



    #2 /home/m2vtec/public_html/vendor/magento/module-company/Plugin/Sales/Model/ResourceModel/Order/Grid/CollectionPlugin.php(32): Zend_Db_Select->joinLeft(Array, 'main_table.enti...', Array)
    #3 /home/m2vtec/public_html/vendor/magento/framework/Interception/Interceptor.php(121): MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin->beforeLoad(Object(MagentoSalesModelResourceModelOrderGridCollectionInterceptor))


    If you see that error then you understand



    MagentoCompanyPluginSalesModelResourceModelOrderGridCollectionPlugin
    this plugin class is responsible for this error.



    If you disabled plugin for this class of this module then you issue will be resolved.







    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited Jun 8 '18 at 5:42









    Vivek

    1,9791 gold badge9 silver badges37 bronze badges




    1,9791 gold badge9 silver badges37 bronze badges










    answered Jun 8 '18 at 5:10









    Amit Bera♦Amit Bera

    61.8k16 gold badges84 silver badges183 bronze badges




    61.8k16 gold badges84 silver badges183 bronze badges












    • I found this module is Magento_Company that is official? You mean disable this module?

      – hkguile
      Jun 8 '18 at 5:29











    • It is don't thought not magento own-mdule

      – Amit Bera♦
      Jun 8 '18 at 5:32

















    • I found this module is Magento_Company that is official? You mean disable this module?

      – hkguile
      Jun 8 '18 at 5:29











    • It is don't thought not magento own-mdule

      – Amit Bera♦
      Jun 8 '18 at 5:32
















    I found this module is Magento_Company that is official? You mean disable this module?

    – hkguile
    Jun 8 '18 at 5:29





    I found this module is Magento_Company that is official? You mean disable this module?

    – hkguile
    Jun 8 '18 at 5:29













    It is don't thought not magento own-mdule

    – Amit Bera♦
    Jun 8 '18 at 5:32





    It is don't thought not magento own-mdule

    – Amit Bera♦
    Jun 8 '18 at 5:32













    0














    I was having same issue,
    This will work if you want to use company-module in Magento.
    Finally after some digging we need to add a piece of code to CollectionPlugin.php



    before $subject->getSelect()



    //bug fixes for customerinfo->ordertab
     $select = $subject->getSelect()->__toString();
     if(preg_match('/company_name/', $select)){
     return [$printQuery, $logQuery];





    share|improve this answer



























      0














      I was having same issue,
      This will work if you want to use company-module in Magento.
      Finally after some digging we need to add a piece of code to CollectionPlugin.php



      before $subject->getSelect()



      //bug fixes for customerinfo->ordertab
       $select = $subject->getSelect()->__toString();
       if(preg_match('/company_name/', $select)){
       return [$printQuery, $logQuery];





      share|improve this answer

























        0












        0








        0







        I was having same issue,
        This will work if you want to use company-module in Magento.
        Finally after some digging we need to add a piece of code to CollectionPlugin.php



        before $subject->getSelect()



        //bug fixes for customerinfo->ordertab
         $select = $subject->getSelect()->__toString();
         if(preg_match('/company_name/', $select)){
         return [$printQuery, $logQuery];





        share|improve this answer













        I was having same issue,
        This will work if you want to use company-module in Magento.
        Finally after some digging we need to add a piece of code to CollectionPlugin.php



        before $subject->getSelect()



        //bug fixes for customerinfo->ordertab
         $select = $subject->getSelect()->__toString();
         if(preg_match('/company_name/', $select)){
         return [$printQuery, $logQuery];






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 4 at 16:59









        Magento DevMagento Dev

        588 bronze badges




        588 bronze badges



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f229095%2fmagento-2-backend-customers-order-infinite-loading%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

            Image
            Natural numbersSquare numbersCategories requiring diffusion Help Category:9 (number) From Wikimedia Commons, the free media repository Jump to navigation Jump to search number: 9 (nine) instance of: natural number, deficient number, square number, composite number, odd number, centered cube number, centered octagonal number and nonagonal number other integers: -8 • -4 • -2 • -1 • 0 • 1 • 2 • 3 • 4 • 5 • 6 • 7 • 8 • 9 • 10 • 11 • 12 • 13 • 14 • 15 • 16 • 17 • 18 • 19 • 20 • 21 • 22 • 23 • 24 • 25 • 26 • 27 • 28 • 29 -20 • 0 • 10 • 20 • 30 ...
            Read more

            Circuit construction for execution of conditional statements using least significant bitHow are two different registers being used as “control”?How exactly is the stated composite state of the two registers being produced using the $R_zz$ controlled rotations?Efficiently performing controlled rotations in HHLWould this quantum algorithm implementation work?How to prepare a superposed states of odd integers from $1$ to $sqrtN$?Why is this implementation of the order finding algorithm not working?Circuit construction for Hamiltonian simulationHow can I invert the least significant bit of a certain term of a superposed state?Implementing an oracleImplementing a controlled sum operation

            Image
            How to attach cable mounting points to a bicycle frame? Is Jon Snow the last of his House? A steel cutting sword? I know that there is a preselected candidate for a position to be filled at my department. What should I do? Is the field of q-series 'dead'? How to cut a climbing rope? Do photons bend spacetime or not? Where have Brexit voters gone? Is it legal to have an abortion in another state or abroad? Did this character show any indication of wanting to rule before S8E6? How to respond to upset student? Compaq Portable vs IBM 5155 Portable PC Is the Indo-European language family made up? Can I summon an otherworldly creature with the Gate spell without knowing its true name? USPS Back Room - Trespassing? Can my floppy disk still work without a shutter spring? Alternatives to achieve certain output format Are black holes spherical during merger? Can the product of any two aperiodic functions which are defined on the entire number line be p...
            Read more

            Magento 2 “No Payment Methods” in Admin New OrderHow to integrate Paypal Express Checkout with the Magento APIMagento 1.5 - Sales > Order > edit order and shipping methods disappearAuto Invoice Check/Money Order Payment methodAdd more simple payment methods?Shipping methods not showingWhat should I do to change payment methods if changing the configuration has no effects?1.9 - No Payment Methods showing upMy Payment Methods not Showing for downloadable/virtual product when checkout?Magento2 API to access internal payment methodHow to call an existing payment methods in the registration form?

            Image
            What is the meaning of [[:space:]] in bash? Is this artwork (used in a video game) real? What happens on Day 6? Link of a singularity Should I be able to keep my company purchased standing desk when I leave my job? Alternator dying so junk car? A scene of Jimmy diversity Is the Gritty Realism variant incompatible with dungeon-based adventures? What could be reasoning of male prison in VR world to only allow undershirt and sarong as nightwear to male prisoners Why does FFmpeg choose 10+20+20 ms instead of an even 16 ms for 60 fps GIF images? Sending a photo of my bank account card to the future employer Advice for paying off student loans and auto loans now that I have my first 'real' job If I stood next to a piece of metal heated to a million degrees, but in a perfect vacuum, would I feel hot? What made Windows ME so crash-prone? Can a dragon's breath weapon pass through Leomund's Tiny Hut? Did 007 exist before James Bond? Is there a sour...
            Read more