cancel
Showing results for 
Search instead for 
Did you mean: 

theme installation error

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

theme installation error

Hi Guys,

 

I am trying to install a theme to my Magento store 1.9.2.4 but unfortunately i am getting the following error.

can anyone help me to fix this please.

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'masport1_mag.magentothem_blog' doesn't exist, query was: SELECT COUNT(*) FROM `magentothem_blog` AS `main_table`
 LEFT JOIN `magentothem_blog_store` AS `store_table` ON main_table.post_id = store_table.post_id
 LEFT JOIN (SELECT `magentothem_blog_comment`.`post_id`, COUNT(IF(status = 2, post_id, NULL)) AS `comment_count` FROM `magentothem_blog_comment` GROUP BY `post_id`) AS `comments_select` ON main_table.post_id = comments_select.post_id WHERE (main_table.created_time
Trace: #0 /home/masport1/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/masport1/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/masport1/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /home/masport1/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array) #4 /home/masport1/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array) #5 /home/masport1/public_html/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /home/masport1/public_html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array) #7 /home/masport1/public_html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize() #8 /home/masport1/public_html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber() #9 /home/masport1/public_html/lib/Varien/Data/Collection/Db.php(522): Varien_Data_Collection->getCurPage() #10 /home/masport1/public_html/lib/Varien/Data/Collection/Db.php(569): Varien_Data_Collection_Db->_renderLimit() #11 /home/masport1/public_html/lib/Varien/Data/Collection.php(741): Varien_Data_Collection_Db->load() #12 /home/masport1/public_html/app/code/local/Magentothem/Blog/Block/Menu/Sidebar.php(19): Varien_Data_Collection->getIterator() #13 /home/masport1/public_html/app/design/frontend/ma_kinggym/ma_kinggym_dark_boxed/template/magentothem_blog/blog_slide.phtml(22): Magentothem_Blog_Block_Menu_Sidebar->getRecent() #14 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/masport1/...') #15 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/ma_kin...') #16 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #17 /home/masport1/public_html/app/code/local/Magentothem/Blog/Block/Abstract.php(156): Mage_Core_Block_Template->_toHtml() #18 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Magentothem_Blog_Block_Abstract->_toHtml() #19 /home/masport1/public_html/app/design/frontend/ma_kinggym/ma_kinggym_dark_boxed/template/magentothem/block_group.phtml(25): Mage_Core_Block_Abstract->toHtml() #20 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/masport1/...') #21 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/ma_kin...') #22 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #23 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #24 /home/masport1/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #25 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() #26 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #27 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('block_group', true) #28 /home/masport1/public_html/app/design/frontend/ma_kinggym/ma_kinggym_dark_boxed/template/page/1column.phtml(57): Mage_Core_Block_Abstract->getChildHtml('block_group') #29 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/masport1/...') #30 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/ma_kin...') #31 /home/masport1/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #32 /home/masport1/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #33 /home/masport1/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #34 /home/masport1/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #35 /home/masport1/public_html/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout() #36 /home/masport1/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home') #37 /home/masport1/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home') #38 /home/masport1/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction() #39 /home/masport1/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index') #40 /home/masport1/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)) #41 /home/masport1/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #42 /home/masport1/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array) #43 /home/masport1/public_html/index.php(83): Mage::run('base', 'website') #44 {main}
1 REPLY 1

Re: theme installation error

Hi @min_niyas,

 

 

Basically that message means the table magentothem_blog already exists when the install scritp tries to create the table.

You should find a way to avoid that installer (if the table already exists and the data is OK for you) or you should check if you can remove that table (make a backup first) and then run the installer again.