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

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘link.area’ in ‘where clause’
 
francoisd
Member
 
Total Posts:  39
Joined:  2009-10-14
 

Hi magento forum,

i’m upgrading my 1.3.2.4 to 1.5.1.0.
The database update is made but on the frontend and the backend, I have a an sql error.
The report says :

a:5:{i:0;s:84:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'link.area' in 'where clause'";i:1;s:2772:"#0 D:\xx\xx\xx\monsitev2\lib\Zend\Db\Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 D:\xx\xx\xx\monsitev2\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 D:\xx\xx\xx\monsitev2\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `update`...', Array)
#3 D:\xx\xx\xx\monsitev2\lib\Varien\Db\Adapter\Pdo\Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `update`...', Array)
#4 D:\xx\xx\xx\monsitev2\lib\Zend\Db\Adapter\Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Model\Mysql4\Layout.php(62): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#6 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Model\Layout\Update.php(361): Mage_Core_Model_Mysql4_Layout->fetchUpdatesByHandle('default')
#7 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Model\Layout\Update.php(248): Mage_Core_Model_Layout_Update->fetchDbLayoutUpdates('default')
#8 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Model\Layout\Update.php(224): Mage_Core_Model_Layout_Update->merge('default')
#9 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Controller\Varien\Action.php(307): Mage_Core_Model_Layout_Update->load()
#10 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Cms\Helper\Page.php(107): Mage_Core_Controller_Varien_Action->loadLayoutUpdates()
#11 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Cms\Helper\Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#12 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Cms\controllers\IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#13 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Controller\Varien\Action.php(420): Mage_Cms_IndexController->indexAction()
#14 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Controller\Varien\Router\Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch('index')
#15 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Controller\Varien\Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#16 D:\xx\xx\xx\monsitev2\app\code\core\Mage\Core\Model\App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#17 D:\xx\xx\xx\monsitev2\app\Mage.php(627): Mage_Core_Model_App->run(Array)
#18 D:\xx\xx\xx\monsitev2\index.php(80): Mage::run('', 'store')
#19 {main}"
;s:3:"url";s:23:"/monsitev2/index.php/";s:11:"script_name";s:22:"/monsitev2/index.php";s:4:"skin";s:7:"default";}

Is anybody know an issue ?

Thanks in advance !

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3217
Joined:  2009-02-26
Minneapolis MN
 

Please try re-indexing your site, from ssh you can do this

./shell php indexer.php reindexall
 
Magento Community Magento Community
Magento Community
Magento Community
 
eggi
Jr. Member
 
Total Posts:  1
Joined:  2008-04-03
 

I have the same problem after upgrading from 1.3.2.4 to 1.5.0.1
Did the upgrade with the downloader!!

Even reindex all prooducts, etc, but all i tried nothing works!!!!

Is someone out there how could me??!!

PLEASE!!!

Thats the error Log:

a:5:{i:0;s:84:\\\"SQLSTATE[42S22]: Column not found: 1054 Unknown column \\\’link.area\\\’ in \\\’where clause\\\’\\\";i:1;s:2723:\\\"#0 /home/developer.meinobst.com/httpdocs/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/developer.meinobst.com/httpdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/developer.meinobst.com/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\\\’SELECT `update`...\\\’, Array)
#3 /home/developer.meinobst.com/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(337): Zend_Db_Adapter_Pdo_Abstract->query(\\\’SELECT `update`...\\\’, Array)
#4 /home/developer.meinobst.com/httpdocs/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Layout.php(62): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#6 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Model/Layout/Update.php(361): Mage_Core_Model_Mysql4_Layout->fetchUpdatesByHandle(\\\’default\\\’)
#7 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Model/Layout/Update.php(248): Mage_Core_Model_Layout_Update->fetchDbLayoutUpdates(\\\’default\\\’)
#8 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Model/Layout/Update.php(224): Mage_Core_Model_Layout_Update->merge(\\\’default\\\’)
#9 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(307): Mage_Core_Model_Layout_Update->load()
#10 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(260): Mage_Core_Controller_Varien_Action->loadLayoutUpdates()
#11 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Adminhtml/Controller/Action.php(263): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#12 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
#13 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Adminhtml_DashboardController->indexAction()
#14 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(\\\’index\\\’)
#15 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#16 /home/developer.meinobst.com/httpdocs/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
#17 /home/developer.meinobst.com/httpdocs/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#18 /home/developer.meinobst.com/httpdocs/index.php(80): Mage::run(\\\’\\\’, \\\’store\\\’)
#19 {main}\\\”;s:3:\\\"url\\\”;s:70:\\\"/index.php/admin/dashboard/index/key/e83c65c14c52444618ea582f1db48408/\\\”;s:11:\\\"script_name\\\”;s:10:\\\"/index.php\\\”;s:4:\\\"skin\\\”;s:5:\\\"admin\\\";}

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3217
Joined:  2009-02-26
Minneapolis MN
 

When you ran the indexer from the shell did it complete all the indexes correctly?

 
Magento Community Magento Community
Magento Community
Magento Community
 
pakdevtanzeel
Jr. Member
 
Total Posts:  3
Joined:  2012-03-21
 

yes i have re index all the option in system index management but yet i m getting same error

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