Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Cant view items after upgrade
 
InitechDesign
Sr. Member
 
Total Posts:  88
Joined:  2008-11-12
 

I just tried to upgrade to version 1.3 through magento connect and now I get this error message when I go to a page with products on it.

SQLSTATE[42000]Syntax error or access violation1064 You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ') = '-2' OR ( IFNULL(_groupscatalog_hide_group_table.value, ) != '0' AND (IFNULL' at line 3
Trace
:
#0 C:\xampp\htdocs\magento\lib\Zend\Db\Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 C:\xampp\htdocs\magento\lib\Zend\Db\Adapter\Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 C:\xampp\htdocs\magento\lib\Zend\Db\Adapter\Pdo\Abstract.php(230): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#3 C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php(259): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array)
#4 C:\xampp\htdocs\magento\lib\Zend\Db\Adapter\Abstract.php(727): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\Model\Resource\Eav\Mysql4\Product\Collection.php(794): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#6 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\Model\Layer.php(293): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection->getSetIds()
#7 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\Model\Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#8 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\Block\Layer\View.php(90): Mage_Catalog_Model_Layer->getFilterableAttributes()
#9 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\Block\Layer\View.php(53): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#10 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Block\Abstract.php(199): Mage_Catalog_Block_Layer_View->_prepareLayout()
#11 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Layout.php(445): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#12 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Layout.php(229): Mage_Core_Model_Layout->addBlock('Netzarbeiter_Gr...', 'catalog.leftnav')
#13 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Layout.php(195): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#14 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Layout.php(200): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#15 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(295): Mage_Core_Model_Layout->generateBlocks()
#16 C:\xampp\htdocs\magento\app\code\core\Mage\Catalog\controllers\CategoryController.php(94): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#17 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Action.php(367): Mage_Catalog_CategoryController->viewAction()
#18 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(247): Mage_Core_Controller_Varien_Action->dispatch('view')
#19 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Controller\Varien\Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#20 C:\xampp\htdocs\magento\app\Mage.php(457): Mage_Core_Controller_Varien_Front->dispatch()
#21 C:\xampp\htdocs\magento\index.php(52): Mage::run()
#22 {main}

Someone please help ASAP!!!!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top