search

outeredge / magento-structured-data-module

Magento Structured Data Module by outer/edge
MIT License
46 stars 13 forks source link

500 Server error when Magento Module-Review is disabled #57

Closed p24-max closed 7 months ago

p24-max commented 11 months ago

Having the Magento module 'Magento_Review' disabled, this extension is causing 500 server error on product detail page:


Exception #1 (Zend_Db_Statement_Exception): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.review_entity_summary' doesn't exist, query was: SELECT `review_entity_summary`.* FROM `review_entity_summary` WHERE (`review_entity_summary`.`entity_pk_value`='17614') AND (store_id = 0)
<pre>#1 Magento\Framework\DB\Statement\Pdo\Mysql->_execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Statement.php:313]
#2 Zend_Db_Statement->execute(array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480]
#3 Zend_Db_Adapter_Abstract->query('SELECT `review_e...', array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238]
#4 Zend_Db_Adapter_Pdo_Abstract->query('SELECT `review_e...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:564]
#5 Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT `review_e...', array()) called at [vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:634]
#6 Magento\Framework\DB\Adapter\Pdo\Mysql->query(&Magento\Framework\DB\Select#000000000001825d0000000000000000#, array()) called at [vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:756]
#7 Zend_Db_Adapter_Abstract->fetchRow(&Magento\Framework\DB\Select#000000000001825d0000000000000000#) called at [vendor/magento/framework/Model/ResourceModel/Db/AbstractDb.php:333]
#8 Magento\Framework\Model\ResourceModel\Db\AbstractDb->load(&Magento\Review\Model\Review\Summary#000000000002ae680000000000000000#, 17614, 'entity_pk_value') called at [vendor/magento/framework/Model/AbstractModel.php:543]
#9 Magento\Framework\Model\AbstractModel->load(17614) called at [vendor/outeredge/magento-structured-data-module/Model/Type/Product.php:430]

Admin setting "Include product reviews" is set to "no"

davidwindell commented 7 months ago

Could easily be fixed with a \Magento\Framework\Module\Manager ->isEnabled('Magento_Review') check.

davidwindell commented 7 months ago

Linked to internal issue 6727, PR's welcome in the meantime.

broopdias commented 7 months ago

PR here https://github.com/outeredge/magento-structured-data-module/pull/61

davidwindell commented 7 months ago

@p24-max done in 4.0.7