VinaiKopp_CategoryLink icon indicating copy to clipboard operation
VinaiKopp_CategoryLink copied to clipboard

install error

Open ed29 opened this issue 9 years ago • 0 comments

Hi,Vinai,i install the CategoryLink,an error happen,how to fix it?By the way,my website is in chineses;here is the report:

a:5:{i:0;s:728:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.vinaikopp_link_url' in 'field list', query was: SELECT main_table.entity_id, main_table.name, main_table.path, main_table.is_active, main_table.is_anchor, url_rewrite.request_path, main_table.vinaikopp_link_url AS url FROM ma_catalog_category_flat_store_1 AS main_table LEFT JOIN ma_core_url_rewrite AS url_rewrite ON url_rewrite.category_id=main_table.entity_id AND url_rewrite.is_system=1 AND url_rewrite.store_id = 1 AND url_rewrite.id_path LIKE 'category/%' WHERE (main_table.include_in_menu = '1') AND (main_table.is_active = '1') AND (main_table.path like '1/2/%') AND (level <= 4) ORDER BY main_table.position ASC";i:1;s:5334:"#0 /www/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /www/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /www/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT main_ta...', Array) #4 /www/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT main_ta...', Array) #5 /www/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /www/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(320): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select)) #7 /www/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(383): Mage_Catalog_Model_Resource_Category_Flat->_loadNodes(Object(Xonu_SBE_Model_Category), 3, '1') #8 /www/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(436): Mage_Catalog_Model_Resource_Category_Flat->getNodes('2', 3, '1') #9 /www/app/code/core/Mage/Catalog/Model/Category.php(818): Mage_Catalog_Model_Resource_Category_Flat->getCategories('2', 3, false, false, true) #10 /www/app/code/core/Mage/Catalog/Helper/Category.php(82): Mage_Catalog_Model_Category->getCategories('2', 3, false, false, true) #11 /www/app/code/core/Mage/Catalog/Model/Observer.php(217): Mage_Catalog_Helper_Category->getStoreCategories() #12 /www/app/code/core/Mage/Core/Model/App.php(1338): Mage_Catalog_Model_Observer->addCatalogToTopmenuItems(Object(Varien_Event_Observer)) #13 /www/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Catalog_Model_Observer), 'addCatalogToTop...', Object(Varien_Event_Observer)) #14 /www/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('page_block_html...', Array) #15 /www/app/code/core/Mage/Page/Block/Html/Topmenu.php(74): Mage::dispatchEvent('page_block_html...', Array) #16 /www/app/design/frontend/rwd/default/template/page/html/topmenu.phtml(34): Mage_Page_Block_Html_Topmenu->getHtml('level-top') #17 /www/app/code/core/Mage/Core/Block/Template.php(241): include('/www/app/design...') #18 /www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwd/de...') #19 /www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #20 /www/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #21 /www/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #22 /www/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() #23 /www/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #24 /www/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('topMenu', true) #25 /www/app/design/frontend/rwd/default/template/page/html/header.phtml(86): Mage_Core_Block_Abstract->getChildHtml('topMenu') #26 /www/app/code/core/Mage/Core/Block/Template.php(241): include('/www/app/design...') #27 /www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwd/de...') #28 /www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #29 /www/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #30 /www/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #31 /www/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('header', true) #32 /www/app/design/frontend/rwd/default/template/page/1column.phtml(49): Mage_Core_Block_Abstract->getChildHtml('header') #33 /www/app/code/core/Mage/Core/Block/Template.php(241): include('/www/app/design...') #34 /www/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/rwd/de...') #35 /www/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #36 /www/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml() #37 /www/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #38 /www/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #39 /www/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout() #40 /www/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), 'home') #41 /www/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), 'home') #42 /www/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction() #43 /www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index') #44 /www/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #45 /www/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #46 /www/app/Mage.php(684): Mage_Core_Model_App->run(Array) #47 /www/index.php(87): Mage::run('default', 'store') #48 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

ed29 avatar May 07 '15 10:05 ed29