itonomy / magento2-product-visibillitygrid Goto Github PK
View Code? Open in Web Editor NEWMagento 2 module for determining if/when products are showing up in category
Home Page: https://www.itonomy.nl
License: MIT License
Magento 2 module for determining if/when products are showing up in category
Home Page: https://www.itonomy.nl
License: MIT License
I get this in M2.2.4
2 exception(s): Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS
in_flat_table, product_name.value AS
name, product_status.value AS
sta' at line 1, query was: SELECT main_table
., false OR () AS in_flat_table
, product_name.value AS name
, product_status.value AS status
, product_visibility.value AS visibility
, category_collection
.is_online_in_cat
, category_collection
. FROM catalog_product_entity
AS main_table
LEFT JOIN catalog_product_entity_varchar
AS product_name
ON product_name.entity_id = main_table.entity_id AND product_name.attribute_id = '71' AND product_name.store_id = '0'
LEFT JOIN catalog_product_entity_int
AS product_status
ON product_status.entity_id = main_table.entity_id AND product_status.attribute_id = '96' AND product_status.store_id = '0'
LEFT JOIN catalog_product_entity_int
AS product_visibility
ON product_visibility.entity_id = main_table.entity_id AND product_visibility.attribute_id = '102' AND product_visibility.store_id = '0'
LEFT JOIN (SELECT e
.entity_id
AS p_entity_id
, IF(e.entity_id,1,0) AS is_online_in_cat
FROM catalog_product_entity
AS e
INNER JOIN catalog_product_index_price
AS price_index
ON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0
INNER JOIN catalog_category_product_index
AS cat_index
ON cat_index.product_id=e.entity_id AND cat_index.store_id=5 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='436'
LEFT JOIN cataloginventory_stock_status
AS stock_status_index
ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN catalog_product_entity_int
AS at_status_default
ON (at_status_default
.entity_id
= e
.entity_id
) AND (at_status_default
.attribute_id
= '96') AND at_status_default
.store_id
= 0
LEFT JOIN catalog_product_entity_int
AS at_status
ON (at_status
.entity_id
= e
.entity_id
) AND (at_status
.attribute_id
= '96') AND (at_status
.store_id
= 5) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1)) AS category_collection
ON main_table.entity_id = category_collection.p_entity_id ORDER BY main_table.entity_id DESC
LIMIT 20
Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS in_flat_table
, product_name.value AS name
, product_status.value AS `sta' at line 1
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS in_flat_table
, product_name.value AS name
, product_status.value AS sta' at line 1, query was: SELECT
main_table.*, false OR () AS
in_flat_table, product_name.value AS
name, product_status.value AS
status, product_visibility.value AS
visibility,
category_collection.
is_online_in_cat,
category_collection.* FROM
catalog_product_entityAS
main_tableLEFT JOIN
catalog_product_entity_varcharAS
product_nameON product_name.entity_id = main_table.entity_id AND product_name.attribute_id = '71' AND product_name.store_id = '0' LEFT JOIN
catalog_product_entity_intAS
product_statusON product_status.entity_id = main_table.entity_id AND product_status.attribute_id = '96' AND product_status.store_id = '0' LEFT JOIN
catalog_product_entity_intAS
product_visibilityON product_visibility.entity_id = main_table.entity_id AND product_visibility.attribute_id = '102' AND product_visibility.store_id = '0' LEFT JOIN (SELECT
e.
entity_idAS
p_entity_id, IF(e.entity_id,1,0) AS
is_online_in_catFROM
catalog_product_entityAS
eINNER JOIN
catalog_product_index_priceAS
price_indexON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0 INNER JOIN
catalog_category_product_indexAS
cat_indexON cat_index.product_id=e.entity_id AND cat_index.store_id=5 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='436' LEFT JOIN
cataloginventory_stock_statusAS
stock_status_indexON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN
catalog_product_entity_intAS
at_status_default ON (
at_status_default.
entity_id=
e.
entity_id) AND (
at_status_default.
attribute_id= '96') AND
at_status_default.
store_id= 0 LEFT JOIN
catalog_product_entity_intAS
at_status ON (
at_status.
entity_id=
e.
entity_id) AND (
at_status.
attribute_id = '96') AND (
at_status.
store_id= 5) WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1)) AS
category_collectionON main_table.entity_id = category_collection.p_entity_id ORDER BY main_table.entity_id DESC LIMIT 20 #0 /var/www/bulgin/products/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #2 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT
main_ta...', Array)
#4 /var/www/bulgin/products/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query('SELECT main_ta...', Array) #5 /var/www/bulgin/products/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(580): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT
main_ta...', Array)
#6 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#7 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(Magento\Framework\DB\Select), Array)
#8 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(774): Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(Object(Magento\Framework\DB\Select), Array)
#9 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(670): Magento\Framework\Data\Collection\AbstractDb->_fetchAll(Object(Magento\Framework\DB\Select))
#10 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(574): Magento\Framework\Data\Collection\AbstractDb->getData()
#11 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(559): Magento\Framework\Data\Collection\AbstractDb->loadWithFilter(false, false)
#12 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid/Extended.php(480): Magento\Framework\Data\Collection\AbstractDb->load()
#13 /var/www/bulgin/products/vendor/itonomy/productvisibilitygrid/Block/Adminhtml/ProductVisibilityGrid/Grid.php(84): Magento\Backend\Block\Widget\Grid\Extended->_prepareCollection()
#14 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid.php(403): Itonomy\ProductVisibilityGrid\Block\Adminhtml\ProductVisibilityGrid\Grid->_prepareCollection()
#15 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid/Extended.php(507): Magento\Backend\Block\Widget\Grid->_prepareGrid()
#16 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid.php(468): Magento\Backend\Block\Widget\Grid\Extended->_prepareGrid()
#17 /var/www/bulgin/products/vendor/magento/framework/View/Element/AbstractBlock.php(666): Magento\Backend\Block\Widget\Grid->_beforeToHtml()
#18 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(558): Magento\Framework\View\Element\AbstractBlock->toHtml()
#19 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(534): Magento\Framework\View\Layout->_renderBlock('admin.productgr...')
#20 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('admin.productgr...')
#21 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('admin.productgr...')
#22 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('admin.productgr...', true)
#23 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('admin.productgr...')
#24 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('content')
#25 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('content')
#26 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('content')
#27 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('content', true)
#28 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('content')
#29 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('main.col')
#30 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.col')
#31 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.col')
#32 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.col', true)
#33 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main.col')
#34 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('admin.scope.col...')
#35 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('admin.scope.col...')
#36 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('admin.scope.col...')
#37 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('admin.scope.col...', true)
#38 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('admin.scope.col...')
#39 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.main.conta...')
#40 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.main.conta...')
#41 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.main.conta...')
#42 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.main.conta...', true)
#43 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.main.conta...')
#44 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.content')
#45 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.content')
#46 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.content')
#47 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.content', true)
#48 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.content')
#49 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#50 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#51 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper')
#52 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', true)
#53 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper')
#54 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('backend.page')
#55 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('backend.page')
#56 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('backend.page')
#57 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('backend.page', true)
#58 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('backend.page')
#59 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('root')
#60 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root')
#61 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root')
#62 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true)
#63 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(954): Magento\Framework\View\Layout\Interceptor->renderElement('root')
#64 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): Magento\Framework\View\Layout->getOutput()
#65 /var/www/bulgin/products/vendor/magento/framework/View/Result/Page.php(257): Magento\Framework\View\Layout\Interceptor->getOutput()
#66 /var/www/bulgin/products/vendor/magento/framework/View/Result/Layout.php(170): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#67 /var/www/bulgin/products/generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php(193): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#68 /var/www/bulgin/products/vendor/magento/framework/App/Http.php(139): Magento\Backend\Model\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#69 /var/www/bulgin/products/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch()
#70 /var/www/bulgin/products/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http\Interceptor->launch()
#71 /var/www/bulgin/products/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor))
#72 {main}
Exception #1 (PDOException): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS in_flat_table
, product_name.value AS name
, product_status.value AS sta' at line 1 #0 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/bulgin/products/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #3 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT
main_ta...', Array)
#5 /var/www/bulgin/products/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query('SELECT main_ta...', Array) #6 /var/www/bulgin/products/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(580): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT
main_ta...', Array)
#7 /var/www/bulgin/products/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): Magento\Framework\DB\Adapter\Pdo\Mysql->query(Object(Magento\Framework\DB\Select), Array)
#8 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/Db/FetchStrategy/Query.php(21): Zend_Db_Adapter_Abstract->fetchAll(Object(Magento\Framework\DB\Select), Array)
#9 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(774): Magento\Framework\Data\Collection\Db\FetchStrategy\Query->fetchAll(Object(Magento\Framework\DB\Select), Array)
#10 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(670): Magento\Framework\Data\Collection\AbstractDb->_fetchAll(Object(Magento\Framework\DB\Select))
#11 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(574): Magento\Framework\Data\Collection\AbstractDb->getData()
#12 /var/www/bulgin/products/vendor/magento/framework/Data/Collection/AbstractDb.php(559): Magento\Framework\Data\Collection\AbstractDb->loadWithFilter(false, false)
#13 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid/Extended.php(480): Magento\Framework\Data\Collection\AbstractDb->load()
#14 /var/www/bulgin/products/vendor/itonomy/productvisibilitygrid/Block/Adminhtml/ProductVisibilityGrid/Grid.php(84): Magento\Backend\Block\Widget\Grid\Extended->_prepareCollection()
#15 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid.php(403): Itonomy\ProductVisibilityGrid\Block\Adminhtml\ProductVisibilityGrid\Grid->_prepareCollection()
#16 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid/Extended.php(507): Magento\Backend\Block\Widget\Grid->_prepareGrid()
#17 /var/www/bulgin/products/vendor/magento/module-backend/Block/Widget/Grid.php(468): Magento\Backend\Block\Widget\Grid\Extended->_prepareGrid()
#18 /var/www/bulgin/products/vendor/magento/framework/View/Element/AbstractBlock.php(666): Magento\Backend\Block\Widget\Grid->_beforeToHtml()
#19 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(558): Magento\Framework\View\Element\AbstractBlock->toHtml()
#20 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(534): Magento\Framework\View\Layout->_renderBlock('admin.productgr...')
#21 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('admin.productgr...')
#22 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('admin.productgr...')
#23 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('admin.productgr...', true)
#24 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('admin.productgr...')
#25 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('content')
#26 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('content')
#27 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('content')
#28 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('content', true)
#29 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('content')
#30 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('main.col')
#31 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('main.col')
#32 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('main.col')
#33 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('main.col', true)
#34 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('main.col')
#35 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('admin.scope.col...')
#36 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('admin.scope.col...')
#37 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('admin.scope.col...')
#38 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('admin.scope.col...', true)
#39 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('admin.scope.col...')
#40 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.main.conta...')
#41 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.main.conta...')
#42 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.main.conta...')
#43 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.main.conta...', true)
#44 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.main.conta...')
#45 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.content')
#46 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.content')
#47 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.content')
#48 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.content', true)
#49 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.content')
#50 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('page.wrapper')
#51 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('page.wrapper')
#52 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('page.wrapper')
#53 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('page.wrapper', true)
#54 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('page.wrapper')
#55 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('backend.page')
#56 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('backend.page')
#57 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('backend.page')
#58 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('backend.page', true)
#59 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(585): Magento\Framework\View\Layout\Interceptor->renderElement('backend.page')
#60 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(536): Magento\Framework\View\Layout->_renderContainer('root')
#61 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(206): Magento\Framework\View\Layout->renderNonCachedElement('root')
#62 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(489): Magento\Framework\View\Layout\Interceptor->renderNonCachedElement('root')
#63 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(193): Magento\Framework\View\Layout->renderElement('root', true)
#64 /var/www/bulgin/products/vendor/magento/framework/View/Layout.php(954): Magento\Framework\View\Layout\Interceptor->renderElement('root')
#65 /var/www/bulgin/products/generated/code/Magento/Framework/View/Layout/Interceptor.php(492): Magento\Framework\View\Layout->getOutput()
#66 /var/www/bulgin/products/vendor/magento/framework/View/Result/Page.php(257): Magento\Framework\View\Layout\Interceptor->getOutput()
#67 /var/www/bulgin/products/vendor/magento/framework/View/Result/Layout.php(170): Magento\Framework\View\Result\Page->render(Object(Magento\Framework\App\Response\Http\Interceptor))
#68 /var/www/bulgin/products/generated/code/Magento/Backend/Model/View/Result/Page/Interceptor.php(193): Magento\Framework\View\Result\Layout->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#69 /var/www/bulgin/products/vendor/magento/framework/App/Http.php(139): Magento\Backend\Model\View\Result\Page\Interceptor->renderResult(Object(Magento\Framework\App\Response\Http\Interceptor))
#70 /var/www/bulgin/products/generated/code/Magento/Framework/App/Http/Interceptor.php(24): Magento\Framework\App\Http->launch()
#71 /var/www/bulgin/products/vendor/magento/framework/App/Bootstrap.php(256): Magento\Framework\App\Http\Interceptor->launch()
#72 /var/www/bulgin/products/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http\Interceptor))
#73 {main}`
Hi,
This is not an issue per se, I was facing problem in Magento 2.2.6, that any new products added were not displaying in the frontend.
So I found your extension, installed and in fact it is showing an issue for the products which are not displayed in the frontend.
That is the colum is visible in Category
is blank for the products which are not visible in frontend, but I couln't find any resolution, how I can address this and what does this mean, as the products are already in the category.
if you can help me understand the usage of this column It will help me address the issue.
I have already cleared caches, reindexing etc. with no help.
thank you.
composer require itonomy/productvisibilitygrid
Using version ^1.0 for itonomy/productvisibilitygrid
./composer.json has been updated
Loading composer repositories with package information
Could not fetch https://api.github.com/repos/emizentech/magento2-category-list-widget, please review your configured GitHub OAuth token or enter a new one to access private repos
Head to https://github.com/settings/tokens/new?scopes=repo&description=Composer+on+ip-+2019-06-16+2331
to retrieve a token. It will be stored in "/root/.composer/auth.json" for future use by Composer.
Token (hidden):
Hello,
I installed the module in Magento 2.0.17 and get the following error:
[Mon Apr 29 15:51:50.114138 2019] [:error] [pid 18381] [client *********:52547] PHP Fatal error: Uncaught Error: Call to undefined method Magento\\Catalog\\Model\\ResourceModel\\Product\\Interceptor::unserializeFields() in /***/vendor/magento/framework/Model/ResourceModel/Db/Collection/AbstractCollection.php:604\nStack trace:\n#0 /***/vendor/itonomy/productvisibilitygrid/Model/ResourceModel/ProductVisibilityGrid/Collection.php(427): Magento\\Framework\\Model\\ResourceModel\\Db\\Collection\\AbstractCollection->_afterLoad()\n#1 /***/vendor/magento/framework/Data/Collection/AbstractDb.php(586): Itonomy\\ProductVisibilityGrid\\Model\\ResourceModel\\ProductVisibilityGrid\\Collection->_afterLoad()\n#2 /***/vendor/magento/framework/Data/Collection/AbstractDb.php(557): Magento\\Framework\\Data\\Collection\\AbstractDb->loadWithFilter(false, false)\n#3 /***/vendor/magento/module-backend/Block/Widget/Grid/Extended.php(476): Magento\\Framework\\Data\\Collection\\AbstractDb->load()\n#4 /***/vendor/itonomy/productvisibilitygrid/B in /***/vendor/magento/framework/Model/ResourceModel/Db/Collection/AbstractCollection.php on line 604, referer: https://***/admin/admin/dashboard/index/key/bce0c1fe0e90722a531680abe6f6540f9f59f1bddc20d9c35a438fbc20efc8bf/
Also during installation it wouldn't compile. I had to remove ManagerInterface dependency from /itonomy/productvisibilitygrid/Controller/Adminhtml/Index/MassReindex.php and /itonomy/productvisibilitygrid/Controller/Adminhtml/Index/Reindex.php
Any help is appreciated.
Thank you!
Hi, thanks for this module, but it is not compatible with Magento EE 2.3. The error I ran into was
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product_name.entity_id' in 'on clause', query was: SELECT COUNT(*) FROM `catalog_product_entity` AS `main_table`
LEFT JOIN `catalog_product_entity_varchar` AS `product_name` ON product_name.entity_id = main_table.entity_id AND product_name.attribute_id = '73' AND product_name.store_id = '0'
LEFT JOIN `catalog_product_entity_int` AS `product_status` ON product_status.entity_id = main_table.entity_id AND product_status.attribute_id = '97' AND product_status.store_id = '0'
LEFT JOIN `catalog_product_entity_int` AS `product_visibility` ON product_visibility.entity_id = main_table.entity_id AND product_visibility.attribute_id = '99' AND product_visibility.store_id = '0'
LEFT JOIN (SELECT `e`.`entity_id` AS `p_entity_id`, IF(e.entity_id,1,0) AS `is_online_in_cat_sub` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`row_id` = `e`.`row_id`) AND (`at_status_default`.`attribute_id` = '97') AND `at_status_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`row_id` = `e`.`row_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 1) WHERE ((IF(at_status.value_id > 0, at_status.value, at_status_default.value) = 1)) AND (e.created_in <= 1) AND (e.updated_in > 1)) AS `category_collection` ON main_table.entity_id = category_collection.p_entity_id WHERE (main_table.created_in <= 1) AND (main_table.updated_in > 1)
Exception #1 (PDOException): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product_name.entity_id' in 'on clause'
had to change the following lines to resolve the issue
diff --git a/Model/ResourceModel/ProductVisibilityGrid/Collection.php b/Model/ResourceModel/ProductVisibilityGrid/Collection.php
index ab6ff07..58b8960 100644
--- a/Model/ResourceModel/ProductVisibilityGrid/Collection.php
+++ b/Model/ResourceModel/ProductVisibilityGrid/Collection.php
@@ -240,7 +240,7 @@ class Collection extends DataCollection
// Join with default value table for the attribute.
$select->joinLeft(
[$table => $this->getTable('catalog_product_entity') . '_' . $attributeType],
- $table . '.entity_id = main_table.entity_id'
+ $table . '.value_id= main_table.entity_id'
. ' AND ' . $table . '.attribute_id = \'' . $attributeId . '\''
. ' AND ' . $table . '.store_id = \'' . Store::DEFAULT_STORE_ID . '\'',
[]
@@ -252,7 +252,7 @@ class Collection extends DataCollection
// Join with store value table for the attribute.
$select->joinLeft(
[$tableStore => $this->getTable('catalog_product_entity') . '_' . $attributeType],
- $tableStore . '.entity_id = main_table.entity_id'
+ $tableStore . '.value_id = main_table.entity_id'
. ' AND ' . $tableStore . '.attribute_id = \'' . $attributeId . '\''
. ' AND ' . $tableStore . '.store_id = \'' . $this->storeId . '\'',
[]
The root category ID is hard-coded as 2
which results in a site-breaking exception for my store:
Exception #0 (Magento\Framework\Exception\NoSuchEntityException): No such entity with id = 2
These IDs should not be hard-coded as they will not be the same for all Magento installs, especially if data migration tool has been used.
Same for store ID.
The plugin doesn't set a custom page <title> in the admin section; it just appears as "Magento Admin" making it difficult to find amongst other open tabs or browser history entries.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.