1 頁 (共 1 頁)

報告 recent.php 不能用

發表於 : 2005-12-03, 14:18
xsoteria
錯誤訊息如下:

Could not obtain main information

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_poster' in 'on clause'

SELECT from_unixtime(p.post_time, '%d.%m.%y %H:%i:%s') as topic_time, f.forum_name as forum_name, f.forum_id as forum_id, u.username as username, u2.username as username2, u2.user_id as user_id2, p.poster_id as poster_id, p.post_username as post_username, p.post_id as post_id, t.*, p.post_time as post_time FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_forums f on p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u on p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 on u2.user_id = t.topic_poster WHERE t.topic_id IN (2...

search.php 也是

發表於 : 2005-12-03, 14:23
xsoteria
無聊抓蟲中,站務辛苦啦!
seach.php 也有問題

---

Could not delete old search id sessions

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM phpbb_search_results WHERE session_id NOT IN ('62b875d46e6786771a08702c58a6a235',