SQL error when enabling flat products

Hi,
When enabling the flat products model, we get an SQL error in List.php. Please find the stacktrace below.
Thanks a lot for your help ! 
 

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.visibility' in 'where clause', query was: SELECT count(DISTINCT e.entity_id) FROM `report_event` AS `report_table_views`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = report_table_views.object_id AND e.entity_type_id = 4
 LEFT JOIN `catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id) WHERE (report_table_views.event_type_id = 1) AND (e.visibility = '4')
Trace: #0 /home/jmg/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jmg/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/jmg/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/jmg/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT count(DI...', Array) #4 /home/jmg/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT count(DI...', Array) #5 /home/jmg/magento/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /home/jmg/magento/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array) #7 /home/jmg/magento/app/code/local/Mage/Eav/Model/Entity/Collection/Abstract.php(174): Varien_Data_Collection_Db->getSize() #8 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(198): Mage_Eav_Model_Entity_Collection_Abstract->getSize() #9 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(116): JoomlArt_JmProductsSlider_Block_List->getListMostViewedProducts() #10 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(91): JoomlArt_JmProductsSlider_Block_List->getListProducts()

21 answers

Profile photo of ubdev Staff 98030.00 $tone November 14, 2017
Public

Hi Jean-Marie Geffroy,
We wonder if you have another profile at Ubertheme or you purchased via Themeforest? Kindly send a copy of your payment receipt to our info(at)ubertheme.com. 
We’re sorry for this extra step as our technical support requires active subscription though. Thanks for your understanding.
Regards,
Ubertheme team

#1
Profile photo of Ziven Staff 100280.00 $tone November 14, 2017
Public

Hi There,
Please PM me your site’s url, admin and ftp credentials, I’ll detect the root of issue for troubleshooting.
Best Regards,
Ziven.

#4
Profile photo of Ziven Staff 100280.00 $tone November 14, 2017
Public

Hi Jean,
We need the SSH access. Please add this IP to whitelist and send me the account.\

113.190.252.133
118.70.176.221
113.190.254.239

Best Regards,
Ziven.
 

#6
Profile photo of ubdev Staff 98030.00 $tone November 14, 2017
Public

Hi Jean, 
Glad we can help. We have this ticket closed for now. 
Please submit a new ticket or reach us here, if you have any additional question.
Regards,
Ubertheme team

#8
Profile photo of Jean-Marie Geffroy 110.00 $tone November 15, 2017
Public

Hi !
Bad news today: I have the problem again, with different line numbers because I have updated the template to your latest version. Here is the new stacktrace:
 

There has been an error processing your request

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.visibility' in 'where clause', query was: SELECT count(DISTINCT e.entity_id) FROM `report_event` AS `report_table_views`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = report_table_views.object_id AND e.entity_type_id = 4
 LEFT JOIN `catalog_category_product` AS `at_category_id` ON (at_category_id.`product_id`=e.entity_id) WHERE (report_table_views.event_type_id = 1) AND (e.visibility = '4')
Trace: #0 /home/jmg/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/jmg/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/jmg/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/jmg/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT count(DI...', Array) #4 /home/jmg/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT count(DI...', Array) #5 /home/jmg/magento/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /home/jmg/magento/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array) #7 /home/jmg/magento/app/code/local/Mage/Eav/Model/Entity/Collection/Abstract.php(174): Varien_Data_Collection_Db->getSize() #8 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(245): Mage_Eav_Model_Entity_Collection_Abstract->getSize() #9 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(150): JoomlArt_JmProductsSlider_Block_List->getListMostViewedProducts() #10 /home/jmg/magento/app/code/local/JoomlArt/JmProductsSlider/Block/List.php(125): JoomlArt_JmProductsSlider_Block_List->getListProducts() #11 /home/jmg/magento/app/code/core/Mage/Core/Block/Abstract.php(919): JoomlArt_JmProductsSlider_Block_List->_toHtml() #12 /home/jmg/magento/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #13 /home/jmg/magento/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() #14 /home/jmg/magento/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #15 /home/jmg/magento/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('left', true) #16 /home/jmg/magento/app/design/frontend/default/jm_book/template/page/2columns-left.phtml(153): Mage_Core_Block_Abstract->getChildHtml('left') #17 /home/jmg/magento/app/code/core/Mage/Core/Block/Template.php(241): include('/home/jmg/magen...') #18 /home/jmg/magento/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...') #19 /home/jmg/magento/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #20 /home/jmg/magento/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #21 /home/jmg/magento/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #22 /home/jmg/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #23 /home/jmg/magento/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout() #24 /home/jmg/magento/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home') #25 /home/jmg/magento/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home') #26 /home/jmg/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction() #27 /home/jmg/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index') #28 /home/jmg/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #29 /home/jmg/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #30 /home/jmg/magento/app/Mage.php(684): Mage_Core_Model_App->run(Array) #31 /home/jmg/magento/index.php(122): Mage::run('', 'store') #32 {main}

 

#9
Profile photo of Mall Staff 184060.00 $tone November 16, 2017
Public

Hi there,
Let’s provide me the admin credentials, ftp credentials and web root path of your site. 
I will check further and get back you soon.
Regards,
Mall.

#10
Profile photo of Mall Staff 184060.00 $tone November 16, 2017
Public

Hi there,
I still couldn’t use that: http://i.prntscr.com/qSaKnwU9TDC1uhNXzoCmLw.png
Also, for your case i need only a ftp credentials. Do you have a ftp credentials?
Regards,
Mall.

#14
Profile photo of Mall Staff 184060.00 $tone November 17, 2017
Public

Hi there,
I have added more tweak code in our extension in the PHP file at:
app/code/local/JoomlArt/JmProductsSlider/Block/List.php
And now the issue was solved. Kindly help re-check and contact me if you need further assistance.
Regards,
Mall.

#19
Profile photo of ubdev Staff 98030.00 $tone November 17, 2017
Public

Hi three,
Glad we can help. 
We have this ticket closed for now. Should you have additional question, please accept our apology for certain delay in response, as we are off in the weekend.
Regards,
Ubertheme team

#21

Please login or Register to Submit Answer

Written By

Comments