搜尋文章時,依照 [作者名稱] 排序會發生錯誤...
比如說,搜尋所有討論區中內含 "Per" 的文章且依照作者排序,
會出現以下的錯誤訊息:
<FONT COLOR=GREEN>
Unknown table 'u' in order clause
SELECT f.forum_id, p.topic_id, p.post_time, t.topic_title, f.forum_name FROM topics t, posts p, forums f
WHERE ( (t.topic_title LIKE '%Per%') OR (p.post_text LIKE '%Per%') ) AND p.topic_id = t.topic_id AND
p.forum_id = f.forum_id AND f.forum_type != 1 GROUP BY p.topic_id ORDER BY u.username LIMIT 30
</FONT>
搜尋文章的bug...
版主: DearHoney