喜悦国际村 
» 游客:  注册 | 登录 | 搜索 | 统计 | 帮助

RSS 订阅当前论坛  

喜悦证交所已经关闭

上一主题 下一主题
     
标题: Vbb问题,请大家帮帮我!  
 
fengzhixia (fengzhixia)
中级会员
Rank: 3Rank: 3
中级会员



UID 21911
精华 0
积分 249
帖子 242
金钱 249 喜悦币
威望 0
人脉 0
阅读权限 30
注册 2003-7-23
状态 离线
[广告]: q m
Vbb问题,请大家帮帮我!

在用户登录以后,进入主题列表时出现如下情况:



我修复、优化所有数据表情况依旧!



数据库错误在 vBulletin 3.0.0:



无效的 SQL 语句:
  SELECT
   IF(votenum >= 1, votenum, 0) AS votenum,
   IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
   post.pagetext AS preview,
   thread.threadid, thread.title AS threadtitle, lastpost, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
   lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, goodnees, votetotal, thread.attach
   , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
   , NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
    deletionlog.username AS del_username, deletionlog.reason AS del_reason
  FROM thread AS thread
   LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
   LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
  LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
  WHERE thread.threadid IN (0,179,178,177,176,175,151,137,170,129,169,168,167,166,165,159,150,149,148,147,146)
  ORDER BY sticky DESC, lastpost DESC

mysql 错误: Got error 28 from table handler



mysql 错误号: 1030



日期: Saturday 18th of February 2006 09:29:28 AM
脚本: http://www.cskin.cn/bbs.cskin/forumdisplay.php?f=18
来源: http://www.cskin.cn/bbs.cskin/index.php
用户名: fengzhixia
IP 地址: 202.117.**.161
2006-2-18 09:52 AM#1
查看资料  访问主页  发短消息  QQ  顶部
     


  可打印版本 | 推荐给朋友 | 订阅主题 | 收藏主题 | 开通个人空间  


 




Powered by Discuz! 6.1.0  © 2001-2010 Comsenz Inc.
Processed in 0.028268 second(s), 6 queries

(冀ICP备05009913号) 管理员:sadly 邮箱/MSN: sadly@phpx.com QQ:824008(长隐) 清除 Cookies - - Archiver - WAP