[問題] 主題行事曆 1.0.1安裝後發生的問題

[善假郎]

小弟使用phpBB 2.0.10版的討論區
站上環境為\r
OS WIN2000

Apache Web Server Version 1.3.31

PHP Script Language Version 4.3.8

MySQL Database Version 4.0.20

Zend Optimizer Version 2.5.3

phpMyAdmin Database Manager Version 2.6.0-rc1

目前有加裝外掛TOP 5 V3版
今天在加裝主題行事曆 1.0.1版
照說明裝了
MOD-topic_calendar-part1.txt（必裝）
MOD-topic_calendar-part2.txt（未安裝Split topic type 2.0.1 者必裝）
MOD-topic_calendar-part3.txt（未安裝categories hierarchy v 2.0.4 者必裝)

點選文章後出現錯誤訊息如下

代碼: 選擇全部

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 '/-- fin mod : calendar ----------------------------------------

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, t.topic_first_post_id, t.topic_calendar_time, t.topic_calendar_duration, 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 //-- fin mod : calendar ---------------------------------------------------------------------------- FROM phpbb_topics t, phpbb_forums f WHERE t.topic_id = 426 AND f.forum_id = t.forum_id 

Line : 165
File : c:\appserv\www\viewtopic.php

請教各位先進...能否告知這要如何修正

[天霜]

viewtopic.php　165左右\r
拿掉

代碼: 選擇全部

//-- fin mod : calendar ----------------------------------------------------------------------------

#
#-----[ FIND ]------------------------------------------------
#
# this is a partial search : the full lines are longer
#

代碼: 選擇全部

$sql = "SELECT t.topic_id, t.topic_title
	FROM " . TOPICS_TABLE
	WHERE 
		AND f.forum_id =
		$order_sql

#
#-----[ BEFORE, ADD ]-----------------------------------------
#

代碼: 選擇全部

//-- mod : calendar --------------------------------------------------------------------------------
// here we added
//	, t.topic_first_post_id, t.topic_calendar_time, t.topic_calendar_duration
//-- modify

#
#-----[ IN-LINE FIND ]----------------------------------------
#

代碼: 選擇全部

, t.topic_last_post_id

#
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#

代碼: 選擇全部

, t.topic_first_post_id, t.topic_calendar_time, t.topic_calendar_duration

#
#-----[ AFTER, ADD ]------------------------------------------
#

代碼: 選擇全部

//-- fin mod : calendar ----------------------------------------------------------------------------

[善假郎]

感謝天霜大大的指點，已經可以正常運作了

我發現這是我自己誤會說明的意思，應該將
//-- fin mod : calendar ----------------------------------------------------------------------------
放在$order_sql之後，如下所示\r

代碼: 選擇全部

$sql = "SELECT t.topic_id, t.topic_title 
   FROM " . TOPICS_TABLE 
   WHERE 
      AND f.forum_id = 
      $order_sql
//-- fin mod : calendar ----------------------------------------------------------------------------

我卻將它放在$sql = "SELECT t.topic_id, t.topic_title...之後，如下所示\r

代碼: 選擇全部

$sql = "SELECT t.topic_id, t.topic_title 
//-- fin mod : calendar ----------------------------------------------------------------------------
   FROM " . TOPICS_TABLE 
   WHERE 
      AND f.forum_id = 
      $order_sql

產生這種錯誤實在是粗心大意。
再次感謝天霜大大的教導...^^