点击标签的时候打开页面中出现 MySQL Query Error

点击标签的时候打开的页面中在Powered by SupeSite 7.0 alpha © 2001-2008 Comsenz Inc. 下面会出现以下信息：

SupeSite info: MySQL Query Error

User: xvpindex
Time: 2008-12-22 1:00am
Script: /index.php

SQL: REPLACE INTO [Table]tagcache_8 (cachekey, uid, cachename, value, updatetime) VALUES ('8b78188d8bac25ad', '0', 'category', 'a:10:{i:0;a:19:{s:5:\"catid\";s:1:\"1\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"控制系统\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-1\";s:8:\"subcatid\";s:1:\"1\";}i:1;a:19:{s:5:\"catid\";s:1:\"2\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:7:\"PLC技术\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-2\";s:8:\"subcatid\";s:1:\"2\";}i:2;a:19:{s:5:\"catid\";s:1:\"3\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"电力电子\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-3\";s:8:\"subcatid\";s:1:\"3\";}i:3;a:19:{s:5:\"catid\";s:1:\"4\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:6:\"传感器\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-4\";s:8:\"subcatid\";s:1:\"4\";}i:4;a:19:{s:5:\"catid\";s:1:\"5\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"伺服系统\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-5\";s:8:\"subcatid\";s:1:\"5\";}i:5;a:19:{s:5:\"catid\";s:1:\"6\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"仪器仪表\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-6\";s:8:\"subcatid\";s:1:\"6\";}i:6;a:19:{s:5:\"catid\";s:1:\"7\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"变频传动\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-7\";s:8:\"subcatid\";s:1:\"7\";}i:7;a:19:{s:5:\"catid\";s:1:\"8\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"现场总线\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-8\";s:8:\"subcatid\";s:1:\"8\";}i:8;a:19:{s:5:\"catid\";s:1:\"9\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"工业电器\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:43:\"http://www.zdh8.cn/?action-category-catid-9\";s:8:\"subcatid\";s:1:\"9\";}i:9;a:19:{s:5:\"catid\";s:2:\"10\";s:4:\"upid\";s:1:\"0\";s:4:\"name\";s:8:\"其它论文\";s:4:\"note\";s:0:\"\";s:4:\"type\";s:4:\"news\";s:9:\"ischannel\";s:1:\"0\";s:12:\"displayorder\";s:1:\"0\";s:3:\"tpl\";s:0:\"\";s:7:\"viewtpl\";s:0:\"\";s:5:\"thumb\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:5:\"image\";s:40:\"http://www.zdh8.cn/images/base/nopic.gif\";s:10:\"haveattach\";s:1:\"0\";s:8:\"bbsmodel\";s:1:\"0\";s:10:\"bbsurltype\";s:0:\"\";s:10:\"blockmodel\";s:1:\"1\";s:14:\"blockparameter\";s:0:\"\";s:9:\"blocktext\";s:0:\"\";s:3:\"url\";s:44:\"http://www.zdh8.cn/?action-category-catid-10\";s:8:\"subcatid\";s:2:\"10\";}}', '1229889622')
Error: Table 'sq_xvpindex.[Table]tagcache_8' doesn't exist
数据表缺失,请恢复备份数据

顶！！！！！！！希望解决！

那是因为你把 tagcache 表删除了导致的，重新升级试试吧~

看了一下，tagcache表存在，我不是升级的，我根本就是全新安装的。

哈哈，解决了，我优化了一下数据库就没事了，想不明白！

LZ你是怎么优化的？

问题完全解决!!
需要帮助的联系QQ21881044

LZ,我和你遇到相同的问题,也是新装的,请问如何解决,谢谢
已经加你QQ

LZ共享一下哈

因为你supesite数据库没有自动生成tagcache_8表 , 你可以复制tagcache表，字段名也都一样，添加一个tagcache_8表，你更新后会发现还缺少tagcache_4表，同样方法添加一个tagcache_4表。
复制tagcache表的方法是，先找到tagcache，打开后点导出，然后点SOL导入表，把名字改成tagcache_8就可以了