[問題]attach mod的"一般錯誤"

phpBB 2 MOD Support
無論是官方或非官方認證之外掛,安裝與使用問題討論。
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

主題已鎖定
sylviao73
星球普通子民
星球普通子民
文章: 5
註冊時間: 2006-01-17 02:55

[問題]attach mod的"一般錯誤"

文章 sylviao73 »

問題外掛:attach mod
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... sc&start=0
使用版本:phpBB 2.0.19
網站位置:電腦休息中..
狀況描述:
當回覆文章後~要返回原文章觀看的時候..
出現..

代碼: 選擇全部

一般錯誤 
  
Could not obtain topic information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_statu

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, COUNT(p2.post_id) AS prev_posts FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_posts p2 WHERE p.post_id = 7 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 7 AND f.forum_id = t.forum_id; GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment ORDER BY p.post_id ASC

Line : 159
File : viewtopic.php 
而且文章版面還會亂掉><..拜託大家幫幫忙了 :cry:


-----
我我...我不想掛這個外掛了.. :-D
雖然問題沒解決..
最後由 sylviao73 於 2006-01-19 15:48 編輯,總共編輯了 1 次。
ethan
星球公民
星球公民
文章: 218
註冊時間: 2002-06-01 09:48
聯繫:

文章 ethan »

f.forum_id = t.forum_id; GROUP BY
請刪除 GROUP BY 前的 ;
主題已鎖定

回到「外掛問題討論」