Verison : phpBB 2.0.10
Connect: Hong Kong Netvigator BROADBAND
Domain : http://bharea.hkpts.com
不知何解，我想將會員升級至管理員或降級至會員，當按下送出後，他就寫了以下的句子，請問我應該如何處理呢？
謝謝～
一般錯誤
Couldn't delete auth access info
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 'AND auth_mod = 0' at line 3
DELETE FROM bhf_auth_access WHERE group_id = AND auth_mod = 0
Line : 180
File : /ha/hkpts/public_html/bharea/bhf/admin/admin_ug_auth.php
[ 求助 ] 會員權限設定有問題
版主: 版主管理群
版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
搬回去 
Martinet 寫:錯誤在這裡..DELETE FROM bhf_auth_access WHERE group_id = AND auth_mod = 0
大概是裝了某外掛動到了吧～
/admin/admin_ug_auth.php
180行上下10行貼出來看看..
另外也檢查一下有裝什麼動到那部分的外掛..
還有..下次發問記得依照格式...= =a
代碼: 選擇全部
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
WHERE group_id = $group_id
AND auth_mod = 0";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Couldn't delete auth access info", "", __LINE__, __FILE__, $sql);
}
//
// Delete any entries in auth_access, they are not required if user is becoming an
// admin
//
$sql = "UPDATE " . AUTH_ACCESS_TABLE . "
SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0
WHERE group_id = $group_id";
if ( !($result = $db->sql_query($sql)) )