竹貓星球

求救喔...沒辦法發表新主題了....

架設主機作業系統：Windows Xp Pro
快速架站程式：Appserv
上網方式：CABLE
phpBB2 版本：phpBB 2.0.6
錯誤情況顯示如下:

SQL Error : 1064 You have an error in your SQL syntax near 'AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_ti' at line 4

SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_time DESC LIMIT 15

Line : 114
File : c:\appserv\www\phpbb2\includes\topic_review.php

之前裝了什麼外掛呢而且改到了 topic_review.php 這個檔？
這裡有改錯了：
SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_time DESC LIMIT 15

應該是\r
SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 這裡還有字 AND p.poster_id = u.user_id AND p.post_id = pt.post_id ORDER BY p.post_time DESC LIMIT 15

原始檔是：WHERE p.topic_id = $topic_id

~Mac

謝謝 MAC 兄
我查了原始檔內$topic_id 並無刪去\r
還有topic_review.php 之前都沒有動過

剛把VIEW_TOPIC_NAME_WHILE_POSTING_MOD1-0-5給取消後
就正常了
如果我還想裝前面的MOD,那該如何做.....才不會有問題

對了那個MOD我是裝了一天後才發生上述情況.....這期間有發了幾篇文章都沒問題...真是怪