Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

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

[复制链接]
xvpindex 发表于 2008-12-22 01:04:37 | 显示全部楼层 |阅读模式
本帖最后由 xvpindex 于 2008-12-22 11:20 编辑

点击标签的时候打开的页面中在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
数据表缺失,请恢复备份数据
qq3050221 发表于 2008-12-22 09:31:38 | 显示全部楼层
顶!!!!!!!希望解决!
回复

使用道具 举报

紫琼 发表于 2008-12-22 10:46:08 | 显示全部楼层
那是因为你把 tagcache 表删除了导致的,重新升级试试吧~
回复

使用道具 举报

 楼主| xvpindex 发表于 2008-12-22 11:17:44 | 显示全部楼层
看了一下,tagcache表存在,我不是升级的,我根本就是全新安装的。
回复

使用道具 举报

 楼主| xvpindex 发表于 2008-12-22 11:20:06 | 显示全部楼层
哈哈,解决了,我优化了一下数据库就没事了,想不明白!
回复

使用道具 举报

qq3050221 发表于 2008-12-22 14:32:50 | 显示全部楼层
LZ你是怎么优化的?
回复

使用道具 举报

qq3050221 发表于 2008-12-22 16:06:52 | 显示全部楼层
问题完全解决!!
需要帮助的联系QQ21881044
回复

使用道具 举报

淘生活 发表于 2008-12-23 05:34:15 | 显示全部楼层
LZ,我和你遇到相同的问题,也是新装的,请问如何解决,谢谢
已经加你QQ
回复

使用道具 举报

long488 发表于 2008-12-23 18:16:08 | 显示全部楼层
LZ共享一下哈
回复

使用道具 举报

qq3050221 发表于 2008-12-23 19:13:29 | 显示全部楼层
因为你supesite数据库没有自动生成tagcache_8表 , 你可以复制tagcache表,字段名也都一样,添加一个tagcache_8表,你更新后会发现还缺少tagcache_4表,同样方法添加一个tagcache_4表。
复制tagcache表的方法是,先找到tagcache,打开后点导出,然后点SOL导入表,把名字改成tagcache_8就可以了
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-11-16 05:54 , Processed in 0.032682 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表