QLSTATE [42S02]：基表或视图未找到：1146表“davidso_newmagento.tag”不存在

Question

在我的Magento站点，我点击一个产品：

然后我得到这个错误：

`

已经有一个错误处理请求

SQLSTATE [42S02]：基表或视图未找到：1146表 'davidso_newmagento.tag' 不存在

跟踪：

0 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo-_execute(Array) 1 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql-_execute(Array) 2 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement-execute(Array) 3 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-query('SELECT main_ta...', Array) 4 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-query('SELECT main_ta...', Array) 5 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql-query('SELECT main_ta...', Array) 6 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract-fetchAll('SELECT main_ta...', Array) 7 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db-_fetchAll('SELECT `main_ta...', Array) 8 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract-getData() 9 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Tag/Model/Resource/Tag/Collection.php(83): Varien_Data_Collection_Db-load(false, false) 10 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Tag/Block/Product/List.php(68): Mage_Tag_Model_Resource_Tag_Collection-load() 11 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Tag/Block/Product/List.php(45): Mage_Tag_Block_Product_List-_getCollection() 12 /hsphere/local/home/davidson/test.davidsonbros.com/app/design/frontend/base/davidsonbros/template/catalog/product/view.phtml(58): Mage_Tag_Block_Product_List-getTags() 13 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(241): include('/hsphere/local/...') 14 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-fetchView('frontend/base/d...') 15 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-renderView() 16 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template-_toHtml() 17 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract-toHtml() 18 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List-_toHtml() 19 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract-toHtml() 20 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract-_getChildHtml('content', true) 21 /hsphere/local/home/davidson/test.davidsonbros.com/app/design/frontend/base/default/template/page/2columns-right.phtml(48): Mage_Core_Block_Abstract-getChildHtml('content') 22 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(241): include('/hsphere/local/...') 23 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-fetchView('frontend/base/d...') 24 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-renderView() 25 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template-_toHtml() 26 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract-toHtml() 27 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout-getOutput() 28 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action-renderLayout() 29 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page-_renderPage(Object(Mage_Cms_IndexController), 'no-route') 30 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Cms/controllers/IndexController.php(75): Mage_Cms_Helper_Page-renderPage(Object(Mage_Cms_IndexController), 'no-route') 31 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Cms_IndexController-noRouteAction() 32 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action-dispatch('noRoute') 33 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard-match(Object(Mage_Core_Controller_Request_Http)) 34 /hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front-dispatch() 35 /hsphere/local/home/davidson/test.davidsonbros.com/app/Mage.php(687): Mage_Core_Model_App-run(Array) 36 /hsphere/local/home/davidson/test.davidsonbros.com/index.php(90): Mage::run('', 'store') 37 {main}

davidso_newmagento是我的数据库。

Answer 1

它看起来像tag表已被删除。

您可以尝试推Magento re_execute标记模块设置脚本。 要做到这一点'tag_setup'在表'core_resource'行中并将其删除。 然后注销并登录管理面板。

我不确定它会起作用因为您可能会因为某些表已存在而导致一些错误。

如果你有一些错误需要修正他们，你可以尝试2建议之一：

1. 你可以“玩”与设置脚本（应用程序/代码/核心/法师/标签/ SQL/tag_setup/...）：尝试取消注释mysql4-install-0.7.0.php中的DROP TABLE语句（只是在删除' - '之前删除...）

2. 您可以手动删除表给出问题。

   （如果你想保存标签数据，之后再出口和进口...）