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

Can’t reindex stock_status
 
vimzzz
Jr. Member
 
Total Posts:  3
Joined:  2010-09-08
 

Hello.

After upgrading to 1.6.1 i cant reindex the stock status.
When i try to do this it returns the following error:

Cannot get the following configuration: cataloginventory/stock_status_indexer_idx

The frontend returns:

cant get the following configuration: cataloginventory/stock_status

Trace:
#0 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/Resource.php(272): Mage::throwException(’Kan ikke hente ...’)
#1 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(284): Mage_Core_Model_Resource->getTableName(’cataloginventor...’)
#2 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(247): Mage_Core_Model_Resource_Db_Abstract->getTable(’stock_status’)
#3 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/CatalogInventory/Model/Resource/Stock/Status.php(115): Mage_Core_Model_Resource_Db_Abstract->getMainTable()
#4 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/CatalogInventory/Model/Stock/Status.php(477): Mage_CatalogInventory_Model_Resource_Stock_Status->getProductStatus(Array, ‘1’, 1)
#5 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/CatalogInventory/Model/Observer.php(113): Mage_CatalogInventory_Model_Stock_Status->addStockStatusToProducts(Object(Mage_Catalog_Model_Resource_Product_Collection))
#6 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/App.php(1303): Mage_CatalogInventory_Model_Observer->addStockStatusToCollection(Object(Varien_Event_Observer))
#7 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/App.php(1284): Mage_Core_Model_App->_callObserverMethod(Object(Mage_CatalogInventory_Model_Observer), ‘addStockStatusT...’, Object(Varien_Event_Observer))
#8 /var/www/vhosts/steelz.no/httpdocs/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent(’catalog_product...’, Array)
#9 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php(383): Mage::dispatchEvent(’catalog_product...’, Array)
#10 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(883): Mage_Catalog_Model_Resource_Product_Collection->_afterLoad()
#11 /var/www/vhosts/steelz.no/httpdocs/lib/Varien/Data/Collection.php(729): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php(1278): Varien_Data_Collection->getIterator()
#13 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Sales/Model/Resource/Quote/Item/Collection.php(182): Mage_Catalog_Model_Resource_Product_Collection->addOptionsToResult()
#14 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Sales/Model/Resource/Quote/Item/Collection.php(139): Mage_Sales_Model_Resource_Quote_Item_Collection->_assignProducts()
#15 /var/www/vhosts/steelz.no/httpdocs/lib/Varien/Data/Collection/Db.php(536): Mage_Sales_Model_Resource_Quote_Item_Collection->_afterLoad()
#16 /var/www/vhosts/steelz.no/httpdocs/lib/Varien/Data/Collection.php(729): Varien_Data_Collection_Db->load()
#17 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Sales/Model/Quote.php(1582): Varien_Data_Collection->getIterator()
#18 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Sales/Model/Quote.php(1303): Mage_Sales_Model_Quote->isVirtual()
#19 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Checkout/Block/Cart/Sidebar.php(257): Mage_Sales_Model_Quote->getTotals()
#20 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Checkout/Block/Cart/Abstract.php(179): Mage_Checkout_Block_Cart_Sidebar->getTotalsCache()
#21 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Checkout/Block/Cart/Sidebar.php(114): Mage_Checkout_Block_Cart_Abstract->getTotals()
#22 /var/www/vhosts/steelz.no/httpdocs/app/design/frontend/base/default/template/checkout/cart/sidebar.phtml(52): Mage_Checkout_Block_Cart_Sidebar->getSubtotal()
#23 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#24 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/base/d...’)
#25 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#26 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#27 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#28 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#29 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#30 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’left’, true)
#31 /var/www/vhosts/steelz.no/httpdocs/app/design/frontend/default/hellowired/template/page/2columns-left.phtml(51): Mage_Core_Block_Abstract->getChildHtml(’left’)
#32 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#33 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#34 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#35 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#36 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/Layout.php(529): Mage_Core_Block_Abstract->toHtml()
#37 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(391): Mage_Core_Model_Layout->getOutput()
#38 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Cms/Helper/Page.php(132): Mage_Core_Controller_Varien_Action->renderLayout()
#39 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
#40 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
#41 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Cms_IndexController->indexAction()
#42 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#43 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#44 /var/www/vhosts/steelz.no/httpdocs/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#45 /var/www/vhosts/steelz.no/httpdocs/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#46 /var/www/vhosts/steelz.no/httpdocs/index.php(80): Mage::run(’’, ‘store’)
#47 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
vimzzz
Jr. Member
 
Total Posts:  3
Joined:  2010-09-08
 

When trying to reindex from shell i get the following error:

php indexer.php reindexall
PHP Warning:  Directive ‘safe_mode’ is deprecated in PHP 5.3 and greater in Unknown on line 0
PHP Warning:  realpath(): SAFE MODE Restriction in effect.  The script whose uid is 33 is not allowed to access /var/www/vhosts/steelz.no/httpdocs/app owned by uid 0 in /var/www/vhosts/steelz.no/httpdocs/app/Mage.php on line 243
PHP Fatal error:  Uncaught exception ‘Mage_Core_Exception’ with message ‘ is not a directory or not readable by this user’ in /var/www/vhosts/steelz.no/httpdocs/app/Mage.php:563
Stack trace:
#0 /var/www/vhosts/steelz.no/httpdocs/app/Mage.php(248): Mage::throwException(’ is not a direc...’)
#1 /var/www/vhosts/steelz.no/httpdocs/app/Mage.php(578): Mage::setRoot()
#2 /var/www/vhosts/steelz.no/httpdocs/shell/abstract.php(79): Mage::app(’admin’, ‘store’)
#3 /var/www/vhosts/steelz.no/httpdocs/shell/indexer.php(197): Mage_Shell_Abstract->__construct()
#4 {main}
thrown in /var/www/vhosts/steelz.no/httpdocs/app/Mage.php on line 563

 
Magento Community Magento Community
Magento Community
Magento Community
 
vimzzz
Jr. Member
 
Total Posts:  3
Joined:  2010-09-08
 

Well, new status update as i turned off php safe mode, now the shell/indexer.php returns:

Can’t retrieve entity config: cataloginventory/stock_status_indexer_idx
Product Prices index was rebuilt successfully
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Can’t retrieve entity config: cataloginventory/stock_status
Tag Aggregation Data index was rebuilt successfully
Stock Status index was rebuilt successfully

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