Carregando...
 

Erros SQLSTATE

Parece um problema de re-indexação. Experimente as seguintes etapas para re-indexar

  1. Magento Admin Panel
  2. System
  3. Index Management
  4. Select All
  5. Submit (Re-index Data)

Below are steps to follow if you can't login to the Admin Console
...which is probably the case if you're getting that SQL Error when you access any page...

To do perform the following steps, you'll need to be able to ssh into your hosting provider's terminal console.

  1. ssh into your webhost provider
  2. navigate to the -+/shell+- folder

cd /path/to/magento/installation/folder/shell

Run the indexer to regenerate all indices (this may take a while...)

php -f indexer.php reindexall

If you have compilation enabled (and you probably shouldn't, but if you DO), then re-compile:

php -f compiler.php compile

Clear out all your Magento caches

php -f cleanCache.php clean all


After the above is all said and done then you should have a working installation. You will be able to login to your Admin Console and the error you mention above should go away.

 

Error
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 `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '134' AND cat_index.is_parent=1
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0 WHERE (e.status = 1)
Trace:
Trace:
#0 /home/vcsti354/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/vcsti354/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/vcsti354/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/vcsti354/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array)
#4 /home/vcsti354/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array)
#5 /home/vcsti354/public_html/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/vcsti354/public_html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /home/vcsti354/public_html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /home/vcsti354/public_html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 /home/vcsti354/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1035): Varien_Data_Collection->getCurPage()
#10 /home/vcsti354/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#11 /home/vcsti354/public_html/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 /home/vcsti354/public_html/app/code/core/Mage/Core/Model/App.php(1358): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer))
#13 /home/vcsti354/public_html/app/code/core/Mage/Core/Model/App.php(1331): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), 'catalogBlockPro...', Object(Varien_Event_Observer))
#14 /home/vcsti354/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('catalog_block_p...', Array)
#15 /home/vcsti354/public_html/app/code/core/Mage/Catalog/Block/Product/List.php(161): Mage::dispatchEvent('catalog_block_p...', Array)
#16 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(922): Mage_Catalog_Block_Product_List->_beforeToHtml()
#17 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#18 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('product_list', true)
#19 /home/vcsti354/public_html/app/code/core/Mage/Catalog/Block/Category/View.php(90): Mage_Core_Block_Abstract->getChildHtml('product_list')
#20 /home/vcsti354/public_html/app/design/frontend/base/default/template/catalog/category/view.phtml(70): Mage_Catalog_Block_Category_View->getProductListHtml()
#21 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/vcsti354/...')
#22 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#23 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#24 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#25 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#26 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#27 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#28 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#29 /home/vcsti354/public_html/app/design/frontend/default/theme712/template/page/2columns-left.phtml(53): Mage_Core_Block_Abstract->getChildHtml('content')
#30 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/vcsti354/...')
#31 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#32 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#33 /home/vcsti354/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#34 /home/vcsti354/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#35 /home/vcsti354/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#36 /home/vcsti354/public_html/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout()
#37 /home/vcsti354/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction()
#38 /home/vcsti354/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#39 /home/vcsti354/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#40 /home/vcsti354/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#41 /home/vcsti354/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#42 /home/vcsti354/public_html/index.php(83): Mage::run('', 'store')
#43 {main}

 

Error log record number: 908274443338

 

Fonte: http://magento.stackexchange.com/questions/73641/sqlstate42s22-column-not-found-1054-unknown-column-e-status-after-1-9-2-up

Contribuíram para esta página: admin .
Última modificação da página em Quarta-feira Abril 5, 2017 16:41:41 -03 por admin. (Versão 1)
Page approved by Leonardo Peixoto on Domingo Abril 23, 2017 13:36:30 -03