VinaiKopp_CategoryLink
VinaiKopp_CategoryLink copied to clipboard
install error
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";}