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?
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
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
asked Jun 8 '18 at 4:50
hkguilehkguile
1,0583 gold badges28 silver badges57 bronze badges
add a comment |
0
Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?
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
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
asked Jun 8 '18 at 4:50
hkguilehkguile
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 namedcompany_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'scompany_orderwhat's its relation with order.
– Vivek
Jun 8 '18 at 5:07
add a comment |
0
0
0
Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?
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
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
asked Jun 8 '18 at 4:50
hkguilehkguile
1,0583 gold badges28 silver badges57 bronze badges
Here is the picture of Magento enterprise 2.2.3 in customer->order, anyone know what is the problem?
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
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
asked Jun 8 '18 at 4:50
hkguilehkguile
1,0583 gold badges28 silver badges57 bronze badges
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
asked Jun 8 '18 at 4:50
hkguilehkguile
1,0583 gold badges28 silver badges57 bronze badges
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
edited Jul 2 at 6:50
Kirti Nariya
1,6595 silver badges19 bronze badges
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
asked Jun 8 '18 at 4:50
hkguilehkguile
1,0583 gold badges28 silver badges57 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 namedcompany_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'scompany_orderwhat's its relation with order.
– Vivek
Jun 8 '18 at 5:07
add a comment |
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 namedcompany_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'scompany_orderwhat'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
add a comment |
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.
edited Jun 8 '18 at 5:42
Vivek
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
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
add a comment |
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];
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
add a comment |
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
edited Jun 8 '18 at 5:42
Vivek
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
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
add a comment |
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.
edited Jun 8 '18 at 5:42
Vivek
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
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
add a comment |
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.
edited Jun 8 '18 at 5:42
Vivek
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
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.
edited Jun 8 '18 at 5:42
Vivek
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
edited Jun 8 '18 at 5:42
Vivek
1,9791 gold badge9 silver badges37 bronze badges
edited Jun 8 '18 at 5:42
Vivek
1,9791 gold badge9 silver badges37 bronze badges
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
answered Jun 8 '18 at 5:10
Amit Bera♦Amit Bera
61.8k16 gold badges84 silver badges183 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
add a comment |
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
add a comment |
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];
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
add a comment |
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];
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
add a comment |
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];
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
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];
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
answered Feb 4 at 16:59
Magento DevMagento Dev
588 bronze badges
588 bronze badges
add a comment |
add a comment |
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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_orderwhat's its relation with order.– Vivek
Jun 8 '18 at 5:07