[問題]建個新的討論版就會發生錯誤!!

[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都一樣有這個問題!!!
把所有的檔案殺掉重灌也是一樣~"~

[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



» 一般錯誤
===============================================

真不知要怎麼解決，管理員控制台可以正常進入。

[Mac]

應該是 lycos 方面的問題
錯誤訊息指有某一個資料庫的檔案（MYI）無法增加或寫入\r
或許可以試試看進入 phpmyadmin 修復資料表\r
phantasy - phpbb_forums
pcsony - phpbb_users

如果還是不行
那除了 lycos 方面可以幫你外
大概就剩下換一個主機了

~Mac

[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;
	}