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

Magento Help!!! 
 
akoayako
Jr. Member
 
Total Posts:  1
Joined:  2011-01-09
 

I upgraded my Magento Site to ver 1.4.2. And then, when I clicked on one of my products, it gives me this error.

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

Trace:
#0 /home/hunterma/public_html/*/lib/Zend/Db/Statement.php(301): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/hunterma/public_html/*/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/hunterma/public_html/*/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT `catalog...’, Array)
#3 /home/hunterma/public_html/*/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT `catalog...’, Array)
#4 /home/hunterma/public_html/*/lib/Zend/Db/Adapter/Abstract.php(725): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/hunterma/public_html/*/app/code/core/Mage/Eav/Model/Entity/Abstract.php(867): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#6 /home/hunterma/public_html/*/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Abstract.php(647): Mage_Eav_Model_Entity_Abstract->load(Object(Mage_Catalog_Model_Category), Object(Mage_Catalog_Model_Category), NULL)
#7 /home/hunterma/public_html/*/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Catalog_Model_Resource_Eav_Mysql4_Abstract->load(Object(Mage_Catalog_Model_Category), Object(Mage_Catalog_Model_Category), NULL)
#8 /home/hunterma/public_html/*/app/code/core/Mage/Catalog/Block/Product/List.php(80): Mage_Core_Model_Abstract->load(Object(Mage_Catalog_Model_Category))
#9 /home/hunterma/public_html/*/app/code/core/Mage/Catalog/Block/Product/List.php(119): Mage_Catalog_Block_Product_List->_getProductCollection()
#10 /home/hunterma/public_html/*/app/design/frontend/default/gm/template/catalog/product/view.phtml(48): Mage_Catalog_Block_Product_List->getLoadedProductCollection()
#11 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(216): include(’/home/hunterma/...’)
#12 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(247): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#13 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(261): Mage_Core_Block_Template->renderView()
#14 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Template->_toHtml()
#15 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#16 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Text_List->_toHtml()
#17 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_Core_Block_Abstract->toHtml()
#18 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Abstract.php(476): Mage_Core_Block_Abstract->_getChildHtml(’content’, true)
#19 /home/hunterma/public_html/*/app/design/frontend/default/gm/template/page/3columns.phtml(45): Mage_Core_Block_Abstract->getChildHtml(’content’)
#20 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(216): include(’/home/hunterma/...’)
#21 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(247): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#22 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Template.php(261): Mage_Core_Block_Template->renderView()
#23 /home/hunterma/public_html/*/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_Core_Block_Template->_toHtml()
#24 /home/hunterma/public_html/*/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#25 /home/hunterma/public_html/*/app/code/core/Mage/Core/Controller/Varien/Action.php(389): Mage_Core_Model_Layout->getOutput()
#26 /home/hunterma/public_html/*/app/code/core/Mage/Catalog/controllers/ProductController.php(207): Mage_Core_Controller_Varien_Action->renderLayout()
#27 /home/hunterma/public_html/*/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_ProductController->viewAction()
#28 /home/hunterma/public_html/*/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#29 /home/hunterma/public_html/*/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#30 /home/hunterma/public_html/*/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#31 /home/hunterma/public_html/*/app/Mage.php(597): Mage_Core_Model_App->run(Array)
#32 /home/hunterma/public_html/*/index.php(80): Mage::run(’’, ‘store’)
#33 {main}

Is there anybody there who have experienced this kind of problem? If there is, then can you lend me your Big Hand to Help Me with this one? I would really appreciate it. Thank you so much.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ben Marks
Guru
 
Avatar
Total Posts:  452
Joined:  2008-10-09
Charleston, SC
 

You made a backup, right?

 
Magento Community Magento Community
Magento Community
Magento Community
 
akoayako
Jr. Member
 
Total Posts:  1
Joined:  2011-01-09
 

Yes I did. Do you know how to fix this?

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