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

Question

在我的magento网站上，我点击了一个产品：

然后我得到了这个错误：

`

处理您的请求时出错

SQLSTATE[42S02]：找不到基表或视图：1146表"davids_newmagento.tag"不存在

跟踪：

0/hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110)：Zend_Db_Statement_Pdo-执行(数组)1/hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Statement.php(300)：Varien_Db_Statement_Pdo_Mysql-execute(数组)2/hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Abstract.php(479)：Zend_Db_Statement-execute(数组)3/hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238)：Zend_Db_Adapter_Abstract-query('SELECTmain_ta...', Array) 4 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract-query('SELECTmain_ta…'，数组)5/hsphere/local/home/davidson/test.davidsonbros.com/lib/Zend/Db/Adapter/Abstract.php(734)：Varien_Db_Adapter_Pdo_Mysql-query('SELECTmain_ta...', Array) 6 /hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract-fetchAll('SELECTmain_ta…'，数组)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…'，数组)8/hsphere/local/home/davidson/test.davidsonbros.com/lib/Varien/Data/Collection/Db.php(566)：Mage_Core模型资源_Db_Collection_Abstract-获取数据()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-集合集合()12/hsphere/local/home/davidson/test.davidsonbros.com/app/design/frontend/base/davidson-bros/template/cacatalog/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('/hspere/local/…')14/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/core/Block/Template.php(272)：Mage_Core _Block_Template-FatchView('fronttend/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("内容"，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("内容")22/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/core/Block/Template.php(241)：include('/hspere/local/…')23/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/core/Block/Template.php(272)：Mage_Core _Block_Template-FatchView('fronttend/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获取输出()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-_，"无路线")30/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/Cms/controllers/IndexController.php(75)：Helper_Page-renderPage(对象(Mage_Cms_IndexController)，"无路线")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_Cor_Controller_Varien_Action-dispatch("无路线")33/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/core/Controller/Varien/Front.php(176)：Mage_Core _Controller_Varien_Router_Standardmatch(对象(Mage_Core-Controller_Request_Http))34/hsphere/local/home/davidson/test.davidsonbros.com/app/code/core/Mage/core/Model/app.php(354)：Mage_Cor_Controller_Varien_Front-dispatch()35/hsphere/local/home/davidson/test.davidsonbros.com/app/Mage.php(687)：Mage_Core _ Model_App-run(阵列)36/hsphere/local/home/davidson/test.davidsonbros.com/index.php(90)：Mage:：run("，"store")37｛main｝

davidso_newmagento是我的数据库。

Answer 1

看起来tag表已被删除。

您可以尝试推送Magento重新执行标记模块设置脚本(_E)。要执行此操作，请查找表">core_resource"中的">tag_setup行"并将其删除。然后在管理面板中注销并登录。

我不确定它是否有效，因为您可能会遇到一些错误，因为某些表已经存在。

如果你有一些错误来修复它们，你可以尝试2个建议之一：

1. 您可以"玩"设置脚本(app/code/core/Mage/Tag/sql/Tag_setup/…)：尝试在mysql4-install-0.7.0.php中取消注释DROP TABLE语句(只是在DROP之前删除"--"…)

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

   (如果你想保留标签数据，然后导出，然后导入…)