[問題] 群組管理出現錯誤訊息

[bc010843]

phpbb:2.0.17
os:linux
快速程式:無\r
空間:竹貓
連線方式:hinet 8M/640

問題
進入後台後點選:群組管理~權限設定~選擇其中一個群組、出現下列錯誤代碼

代碼: 選擇全部

Couldn't obtain user/group 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 'ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id 

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id = ug.user_id

Line : 611
File : admin_ug_auth.php

最近只有升級phpbb，從2.0.16升至2.0.17

請問大概是哪出了問題?

謝謝

[chsa]

代碼: 選擇全部

Couldn't obtain user/group 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 'ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id 

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id = ug.user_id

Line : 611
File : admin_ug_auth.php

跟我之前是一樣的問，我告訴你改法好了。^_^
1.將admin_ug_auth.php的

代碼: 選擇全部

$sql = "SELECT f.* 
      FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
      WHERE f.cat_id = c.cat_id
      ORDER BY c.cat_order, f.forum_order ASC";

2.這部分↑改成下面這部分↓

代碼: 選擇全部

$sql = "SELECT * 
      FROM " . FORUMS_TABLE . " f
      ORDER BY forum_order";

3.然後您在找一次這部份↓ (會有兩個。)

代碼: 選擇全部

$sql = "SELECT * 
      FROM " . FORUMS_TABLE . " f
      ORDER BY forum_order";

4.會找到兩個一樣的，將比較下面的那個在改成這個↓皆可..^_^

代碼: 選擇全部

$sql = "SELECT f.* 
      FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
      WHERE f.cat_id = c.cat_id
      ORDER BY c.cat_order, f.forum_order ASC";

[雷鬼]

代碼: 選擇全部

Couldn't obtain user/group 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 'ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id 

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id = ug.user_id

Line : 611
File : admin_ug_auth.php

跟我之前是一樣的問，我告訴你改法好了。^_^
1.將admin_ug_auth.php的

代碼: 選擇全部

$sql = "SELECT f.* 
      FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
      WHERE f.cat_id = c.cat_id
      ORDER BY c.cat_order, f.forum_order ASC";

2.這部分↑改成下面這部分↓

代碼: 選擇全部

$sql = "SELECT * 
      FROM " . FORUMS_TABLE . " f
      ORDER BY forum_order";

3.然後您在找一次這部份↓ (會有兩個。)

代碼: 選擇全部

$sql = "SELECT * 
      FROM " . FORUMS_TABLE . " f
      ORDER BY forum_order";

4.會找到兩個一樣的，將比較下面的那個在改成這個↓皆可..^_^

代碼: 選擇全部

$sql = "SELECT f.* 
      FROM " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c
      WHERE f.cat_id = c.cat_id
      ORDER BY c.cat_order, f.forum_order ASC";

大大我照您你的改好了。。卻出現以下錯誤訊息\r
Couldn't obtain forum information

DEBUG MODE

SQL Error : 1 Can't create/write to file '/tmp/#sql_7520_0.MYI' (Errcode: 13)

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASC

Line : 578
File : admin_ug_auth.php

line578為\r
message_die(GENERAL_ERROR, "Couldn't obtain forum information", "", __LINE__, __FILE__, $sql);
SORRY.我是超級新手...

[super797]

我之前論壇都沒什麼問題,今天上去看後,進入會員列表及短消息和文章裡頭時,上 面都會出現這些文字,但我找過都沒有問題,那是發生在哪部份????
是中毒了??還是?
只裝過cashMod和跑馬燈外掛

Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/httpdocs/phpbb2/language/lang_chinese_traditional_taiwan/lang_cash.php:345) in /home/httpd/vhosts/httpdocs/phpbb2/viewtopic.php on line 562

Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/httpdocs/phpbb2/language/lang_chinese_traditional_taiwan/lang_cash.php:345) in /home/httpd/vhosts/httpdocs/phpbb2/includes/page_header.php on line 471

Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/httpdocs/phpbb2/language/lang_chinese_traditional_taiwan/lang_cash.php:345) in /home/httpd/vhosts/httpdocs/phpbb2/includes/page_header.php on line 477

Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/vhosts/httpdocs/phpbb2/language/lang_chinese_traditional_taiwan/lang_cash.php:345) in /home/httpd/vhosts/httpdocs/phpbb2/includes/page_header.php on line 478

[flyinghail]

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASCg.group_id = 618 AND ug.group_id = g.group_id AND u.user_id = ug.user_id

這個語句明顯是錯誤的

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order ASC

一個SQL語句就已經完成了，後面的部分接在上面肯定是錯的，看來你的這個文件有問題咯\r

header輸出警告一般是插入廣告或者別的什麽東西已經輸出了WEB header内容，搜索所有phpBB文件中的

代碼: 選擇全部

header(

改成

代碼: 選擇全部

@header(

就不會顯示警告了