第 1 頁 (共 1 頁)
[問題]建個新的討論版就會發生錯誤!!
發表於 : 2003-09-03 23:54
由 phantasy
●架設主機作業系統：Windows XP
●快速架站程式：Appserv 1.9.0
●的上網方式：東森CABLE
●安裝的程式：Apache + php + MySql
●phpBB2 版本：phpBB 2.0.6
只要一建新的討論版...就會出現\r
Could not query forums information
DEBUG MODE
SQL Error : 1 Can't create/write to file 'C:\TEMP\#sqlc08_2b0_0.MYI' (Errcode: 2)
SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order
Line : 165
File : c:\appserv\www\phpbb\tmpbefbjknakl.php
代碼：
代碼: 選擇全部
default:
$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order";
break;
}
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
那位大大可以幫幫我ㄚ!!!
換三個phpBB都一樣有這個問題!!!
把所有的檔案殺掉重灌也是一樣~"~
發表於 : 2003-10-30 15:03
由 pcsony
喔！我遇到的問題跟您很像！
可是我是架在 lycos ，今天忽然就....
===============================================
一般錯誤
Could not obtain user/online information
DEBUG MODE
SQL Error : 1 Can't create/write to file '/tmp/#sql7bf_136ba_1.MYI' (Errcode: 13)
SELECT u.*, s.session_logged_in, s.session_time, s.session_page, s.session_ip FROM phpbb_users u, phpbb_sessions s WHERE u.user_id = s.session_user_id AND s.session_time >= 1067496382 ORDER BY u.username ASC, s.session_ip ASC
Line : 154
File : /data/members/free/tripod/de/n/o/r/nordentw/htdocs/includes/page_header.php
» 一般錯誤
===============================================
真不知要怎麼解決，管理員控制台可以正常進入。
發表於 : 2003-10-30 17:09
由 Mac
應該是 lycos 方面的問題
錯誤訊息指有某一個資料庫的檔案（MYI）無法增加或寫入\r
或許可以試試看進入 phpmyadmin 修復資料表\r
phantasy - phpbb_forums
pcsony - phpbb_users
如果還是不行
那除了 lycos 方面可以幫你外
大概就剩下換一個主機了
~Mac
發表於 : 2003-10-31 08:57
由 pcsony
謝謝 Mac 兄的建議
我有試過了！修護和最佳化
不過還是都沒用
進入管理員控制台則是正常的
嘗試備份下來放到自己電腦還原一切正常
再還原回 lycos 出現新的錯誤訊息：
Couldn't access list of Forums
DEBUG MODE
SQL Error : 1 Can't create/write to file '/tmp/#sql7bf_2f252_0.MYI' (Errcode: 13)
SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_last_post_id, t.topic_title FROM ((( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) LEFT JOIN phpbb_topics t ON t.topic_last_post_id = p.post_id AND t.forum_id = f.forum_id) ORDER BY f.forum_order, f.forum_id
Line : 250
File : /data/members/free/tripod/de/n/o/r/nordentw/htdocs/includes/functions.php
function.php 此段內容
代碼: 選擇全部
// read forums
$forums = array();
$sql = "SELECT
f.*,
p.post_time, p.post_username,
u.username, u.user_id,
t.topic_last_post_id, t.topic_title
FROM ((( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
LEFT JOIN " . TOPICS_TABLE . " t ON t.topic_last_post_id = p.post_id AND t.forum_id = f.forum_id)
ORDER BY f.forum_order, f.forum_id";
if ( !$result = $db->sql_query($sql) ) message_die(GENERAL_ERROR, "Couldn't access list of Forums", "", __LINE__, __FILE__, $sql);
while ($row = $db->sql_fetchrow($result))
{
$main_type = (empty($row['main_type'])) ? POST_CAT_URL : $row['main_type'];
$row['main'] = ($row['cat_id'] == 0) ? 'Root' : $main_type . $row['cat_id'];
if ( count($orig_word) )
{
$row['topic_title'] = preg_replace($orig_word, $replacement_word, $row['topic_title']);
}
$forums[] = $row;
}