cancel
Showing results for 
Search instead for 
Did you mean: 

Reindex issue and SQL Error Magento 1.9

Reindex issue and SQL Error Magento 1.9

I can't reindex Product prices via SSH and also via admin panel. My web store works fine but when i click on my store category or some article i get this error: 

a:5:{i:0;s:858:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main.entity_id' in 'field list', query was: SELECT `main`.`value_id`, `main`.`value` AS `file`, `main`.`entity_id` AS `product_id`, `value`.`label`, `value`.`position`, `value`.`disabled`, `default_value`.`label` AS `label_default`, `default_value`.`position` AS `position_default`, `default_value`.`disabled` AS `disabled_default` FROM `catalog_product_entity_media_gallery` AS `main`
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `value` ON main.value_id = value.value_id AND value.store_id = 1
LEFT JOIN `catalog_product_entity_media_gallery_value` AS `default_value` ON main.value_id = default_value.value_id AND default_value.store_id = 0 WHERE (main.attribute_id = '88') AND (main.entity_id in ('113')) ORDER BY IF(value.position IS NULL, default_value.position, value.position) ASC";i:1;s:5362:"#0 /home/topluk58/public_html/app/Mage.php(463): Mage_Core_Model_Config->getModelInstance('eav/entity_attr...', 'SQLSTATE[42S22]...')
#1 /home/topluk58/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(661): Mage::getModel('eav/entity_attr...', 'SQLSTATE[42S22]...')
#2 /home/topluk58/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(1641): Mage_Eav_Model_Entity_Abstract->walkAttributes('backend/afterLo...', Array)
#3 /home/topluk58/public_html/app/code/core/Mage/Eav/Model/Entity/Abstract.php(964): Mage_Eav_Model_Entity_Abstract->_afterLoad(Object(Mage_Catalog_Model_Product))
#4 /home/topluk58/public_html/app/code/core/Mage/Catalog/Model/Resource/Abstract.php(698): Mage_Eav_Model_Entity_Abstract->load(Object(Mage_Catalog_Model_Product), 'media_gallery', NULL)
#5 /home/topluk58/public_html/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Catalog_Model_Resource_Abstract->load(Object(Mage_Catalog_Model_Product), 'media_gallery', NULL)
#6 /home/topluk58/public_html/app/code/local/TypoStores/TypoLogancee/Helper/Data.php(171): Mage_Core_Model_Abstract->load('media_gallery')
#7 /home/topluk58/public_html/app/design/frontend/typologancee/default/template/catalog/product/list.phtml(312): TypoStores_TypoLogancee_Helper_Data->getAltImgHtml(Object(Mage_Catalog_Model_Product), '600', '400')
#8 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/topluk58/...')
#9 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/typolo...')
#10 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#11 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#12 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#13 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('product_list', true)
#14 /home/topluk58/public_html/app/code/core/Mage/Catalog/Block/Category/View.php(90): Mage_Core_Block_Abstract->getChildHtml('product_list')
#15 /home/topluk58/public_html/app/design/frontend/typologancee/default/template/catalog/category/view.phtml(70): Mage_Catalog_Block_Category_View->getProductListHtml()
#16 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/topluk58/...')
#17 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/typolo...')
#18 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#19 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#20 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#21 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#22 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#23 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#24 /home/topluk58/public_html/app/design/frontend/typologancee/home12/template/page/2columns-left.phtml(106): Mage_Core_Block_Abstract->getChildHtml('content')
#25 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/topluk58/...')
#26 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/typolo...')
#27 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#28 /home/topluk58/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#29 /home/topluk58/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#30 /home/topluk58/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#31 /home/topluk58/public_html/app/code/local/TypoStores/Filter/controllers/Catalog/CategoryController.php(73): Mage_Core_Controller_Varien_Action->renderLayout()
#32 /home/topluk58/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): TypoStores_Filter_Catalog_CategoryController->viewAction()
#33 /home/topluk58/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view')
#34 /home/topluk58/public_html/app/code/community/Folio3/MaintenanceMode/Controller/Router/Standard.php(57): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#35 /home/topluk58/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Folio3_MaintenanceMode_Controller_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#36 /home/topluk58/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#37 /home/topluk58/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#38 /home/topluk58/public_html/index.php(83): Mage::run('', 'store')
#39 {main}";s:3:"url";s:14:"/trgovina.html";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:9:"english12";}

Can someone please help me to fix this issue ? I don't want to do all from the beginning.

1 REPLY 1

Re: Reindex issue and SQL Error Magento 1.9

I have this to....We need help... Pleaseeeeeeeeeeee