原帖由
jyhsu 於 2007-9-26 19:29 發表
在首頁點擊『我的話題』時，出現了以下的錯誤
有誰知道該如何解決
SQL: SELECT DISTINCT t.tid, t.closed , COUNT(pp.pid) AS cnum,
p.pid
FROM cdb_posts p, cdb_threads t LEFT JOIN cdb_posts pp ON pp.tid=p.tid
WHERE pp.pid<p.pid AND p.tid=t.tid AND p.invisible='0' AND p.authorid
IN ('1') AND t.lastpost>=1188212082 GROUP BY p.pid ORDER BY tid DESC
LIMIT 500
錯誤根原: Unknown column 'p.tid' in 'on clause'
錯誤代碼: 1054
詳情: 欄位不存在
你在cdb_posts p , 無提取到tid, 所以p.tid不存在.
SQL: SELECT DISTINCT t.tid, t.closed , COUNT(pp.pid) AS cnum, p.pid, p.tid
FROM cdb_posts p, cdb_threads t LEFT JOIN cdb_posts pp ON pp.tid=p.tid
WHERE pp.pid<p.pid AND p.tid=t.tid AND p.invisible='0' AND p.authorid
IN ('1') AND t.lastpost>=1188212082 GROUP BY p.pid ORDER BY tid DESC
LIMIT 500
