Query Error: SELECT t.tid,t.fid,t.author,t.authorid,t.subject,t.type,t.postdate,t.hits,t.replies,t.titlefont,t.lastposter,t.lastpost FROM pw_threads t FORCE INDEX (postdate) WHERE t.ifcheck=1 AND t.fid NOT IN (’49’,’72’,’81’,’0′) ORDER BY t.postdate DESC LIMIT 10

The URL Is:
http://www.dazhol.com/index.php?m=bbs

MySQL Server Error:
Key ‘postdate’ doesn’t exist in table ‘t’ ( 1176 ) 查看错误相关信息

You Can Get Help In:
http://www.phpwind.net

出现以上这个问题的处理方法是: 在数据库中执行这段代码  ALTER TABLE `pw_threads` ADD INDEX ( `postdate` );

发表评论

电子邮件地址不会被公开。 必填项已用*标注