Many times when you upgrade magento from 1.3.x to 1.4.x or 1.5.x,you come across strange error while logging in Magento admin panel dashboard… It’s something Column not found: 1054 Unknown column ’synonym_for’ in ’field list’ .. Below is some portion of error.. SQLSTATE[42S22]: Column not found: 1054 Unknown column ’synonym_for’ in ’field list’ Trace: #0 ../lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 ../lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array) #2 ../lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT DISTINCT…’, Array) #3 ../lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT DISTINCT…’, Array) #4 ../lib/Zend/Db/Adapter/Abstract.php(706): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #5 ../lib/Varien/Data/Collection/Db.php(713): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array) #6 ../lib/Varien/Data/Collection/Db.php(626): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select)) #7 ../lib/Varien/Data/Collection/Db.php(596): Varien_Data_Collection_Db->getData() #8 ../app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(484): Varien_Data_Collection_Db->load() #9 ../app/code/core/Mage/Adminhtml/Block/Dashboard/Searches/Top.php(65): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection() …. This is because field name has been changed in new [...]