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
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
Hi ! Done ! I’ve sent it a few minutes ago. Thank you in advance for yoru support.
Can you confirm when you receive it ?
Best regards
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.
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.
Problem fixed by upgrading to your latest version, thanks !!!
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
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}
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.
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.
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.
Fantastic ! Thanks a lot for your first-class support !
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
