Problem installing ver. 1.9.2.1

[Foncu2015]

Hi all,

I  have installed Magento Community ver. 1.9.2.1 using a MySQL db previously created with another Magento entity (ver. 1.8.1.0). All the installation process was apparently well until the last screen; but trying to move to the frontend (backend works OK) by pushing the corresponding button -or navigating to the shop URL- returns the following message:

"There has been an error processing your request

Exception printing is disabled by default for security reasons.

Error log record number: 1026133429010"

I have extracted the corresponding record file, but  my limited knowledge does not allow me interpreting it to find the problem.

Grateful for any help that you can provide.

Best regards,

[iweb_p3mbo]

Hi,

Can you look for a file called 1026133429010 inside of your var/report directory and paste the contents in here so we can see what the problem is?

Alternatively; rename errors/local.xml.sample to errors/local.xml and refresh / try again and paste the error.

[Foncu2015]

File 1026133429010:

a:5:{i:0;s:971:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.status' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_2` AS `e`
 INNER JOIN `report_compared_product_index` AS `idx_table` ON (idx_table.product_id=e.entity_id) AND (idx_table.visitor_id = '98')
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.category_id = '2'
 LEFT JOIN `core_store` AS `store_index` ON store_index.store_id = idx_table.store_id
 LEFT JOIN `core_store_group` AS `store_group_index` ON store_index.group_id = store_group_index.group_id
 LEFT JOIN `catalog_category_product_index` AS `store_cat_index` ON store_cat_index.product_id = e.entity_id AND store_cat_index.store_id = idx_table.store_id AND store_cat_index.category_id=store_group_index.root_category_id WHERE (e.status = 1) AND (cat_index.visibility IN(3, 2, 4) OR store_cat_index.visibility IN(3, 2, 4))";i:1;s:4505:"#0 /home4/dvallespin/public_html/magento2/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home4/dvallespin/public_html/magento2/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home4/dvallespin/public_html/magento2/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home4/dvallespin/public_html/magento2/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 /home4/dvallespin/public_html/magento2/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 /home4/dvallespin/public_html/magento2/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home4/dvallespin/public_html/magento2/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Reports/Model/Product/Index/Abstract.php(175): Varien_Data_Collection_Db->getSize()
#8 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Reports/Model/Product/Index/Abstract.php(202): Mage_Reports_Model_Product_Index_Abstract->calculate()
#9 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Reports/Block/Product/Abstract.php(186): Mage_Reports_Model_Product_Index_Abstract->getCount()
#10 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Reports/Block/Product/Compared.php(66): Mage_Reports_Block_Product_Abstract->getCount()
#11 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Reports_Block_Product_Compared->_toHtml()
#12 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#13 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
#14 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
#15 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('right', true)
#16 /home4/dvallespin/public_html/magento2/app/design/frontend/rwd/default/template/page/2columns-right.phtml(57): Mage_Core_Block_Abstract->getChildHtml('right')
#17 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Template.php(241): include('/home4/dvallesp...')
#18 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwd/de...')
#19 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#20 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
#21 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#22 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#23 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
#24 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home')
#25 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home')
#26 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
#27 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#28 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#29 /home4/dvallespin/public_html/magento2/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#30 /home4/dvallespin/public_html/magento2/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#31 /home4/dvallespin/public_html/magento2/index.php(83): Mage::run('', 'store')
#32 {main}";s:3:"url";s:20:"/magento2/index.php/";s:11:"script_name";s:19:"/magento2/index.php";s:4:"skin";s:7:"spanish";}

[JLHC]

I wouldn't recommend that you install Magento 1.9.2.1 with the database of an older version like 1.8.1.0 as the database structure may have changed and the cores files are also different. 

You will most likely need to reinstall Magento 1.8.1.0 with the database before upgrading to Magento 1.9.2.1. 

Alternatively, you can install a blank Magento 1.9.2.1 and import all the data from the old installation. 

[Foncu2015]

Many thnx. So I'll do. I'll report results when done.

Best,