Magento Commerce
Magento Commerce

There has been an error processing your request

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') 
            AND hide_discount = 1
            GROUP BY catalogrule.rule_id' at line 4, query was: SELECT catalogrule.rule_id FROM catalogrule_product 
            JOIN catalogrule 
                ON catalogrule.rule_id = catalogrule_product.rule_id
            WHERE product_id IN () 
            AND hide_discount = 1
            GROUP BY catalogrule.rule_id
Trace: #0 /var/www/html/lingedemaison/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/html/lingedemaison/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /var/www/html/lingedemaison/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/html/lingedemaison/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT catalogr...', Array) #4 /var/www/html/lingedemaison/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT catalogr...', Array) #5 /var/www/html/lingedemaison/lib/Zend/Db/Adapter/Abstract.php(794): Varien_Db_Adapter_Pdo_Mysql->query('SELECT catalogr...', Array) #6 /var/www/html/lingedemaison/app/code/local/Digitalhome/CatalogRule/Helper/Data.php(29): Zend_Db_Adapter_Abstract->fetchCol('SELECT catalogr...') #7 /var/www/html/lingedemaison/app/code/local/Digitalhome/Catalog/Block/Product/Data.php(95): Digitalhome_CatalogRule_Helper_Data->discountHiddenForProduct('234964') #8 /var/www/html/lingedemaison/app/design/frontend/digitalhome/default/template/catalog/product/superGrouped.phtml(20): Digitalhome_Catalog_Block_Product_Data->coloramaconfigbundle() #9 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/html/l...') #10 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/digita...') #11 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #12 /var/www/html/lingedemaison/app/code/local/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Template->_toHtml() #13 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #14 /var/www/html/lingedemaison/app/code/local/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Text_List->_toHtml() #15 /var/www/html/lingedemaison/app/code/local/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #16 /var/www/html/lingedemaison/app/code/local/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true) #17 /var/www/html/lingedemaison/app/design/frontend/digitalhome/default/template/page/2columns-right.phtml(55): Mage_Core_Block_Abstract->getChildHtml('content') #18 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(241): include('/var/www/html/l...') #19 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/digita...') #20 /var/www/html/lingedemaison/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #21 /var/www/html/lingedemaison/app/code/local/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Template->_toHtml() #22 /var/www/html/lingedemaison/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #23 /var/www/html/lingedemaison/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #24 /var/www/html/lingedemaison/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout() #25 /var/www/html/lingedemaison/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'no-route') #26 /var/www/html/lingedemaison/app/code/core/Mage/Cms/controllers/IndexController.php(75): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'no-route') #27 /var/www/html/lingedemaison/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->noRouteAction() #28 /var/www/html/lingedemaison/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(267): Mage_Core_Controller_Varien_Action->dispatch('noRoute') #29 /var/www/html/lingedemaison/app/code/local/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #30 /var/www/html/lingedemaison/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #31 /var/www/html/lingedemaison/app/Mage.php(700): Mage_Core_Model_App->run(Array) #32 /var/www/html/lingedemaison/index.php(168): Mage::run('yvesdelorme_fr', 'store') #33 {main}

Error log record number: 1065858829399