[問題]安裝 custom_mass_pm_1.4.7em 的錯誤訊息求教[已解決]
發表於 : 2005-06-30 18:15
問題外掛:custom_mass_pm_1.4.7em
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... om+mass+PM
安裝完成後到了後台設定權限出現這樣的訊息,我有對照過367行附近的修改,跟修改說明上沒有發現差異,想請大家幫幫忙......
我先將367行前後貼上來,如果不夠請告訴我再貼其他,以節省版面....
在此拜託了...........
謝謝
參考連結:http://phpbb-tw.net/phpbb/viewtopic.php ... om+mass+PM
安裝完成後到了後台設定權限出現這樣的訊息,我有對照過367行附近的修改,跟修改說明上沒有發現差異,想請大家幫幫忙......
代碼: 選擇全部
一般錯誤
Could not update group
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 'WHERE group_id = 28' at line 3
UPDATE phpbb_groups SET group_type = 0, group_name = '版面管理員', group_description = '', group_moderator = 3, group_allow_pm = '5', WHERE group_id = 28
Line : 367
File : admin_groups.php
代碼: 選擇全部
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Failed to obtain current group moderator info', '', __LINE__, __FILE__, $sql);
}
if ( !($row = $db->sql_fetchrow($result)) )
{
$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
VALUES (" . $group_id . ", " . $group_moderator . ", 0)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update group moderator', '', __LINE__, __FILE__, $sql);
}
}
}
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_type = $group_type, group_name = '" . str_replace("\'", "''", $group_name) . "', group_description = '" . str_replace("\'", "''", $group_description) . "', group_moderator = $group_moderator, group_allow_pm = '$group_allow_pm',
WHERE group_id = $group_id";
if ( !$db->sql_query($sql) )
{
第367行 message_die(GENERAL_ERROR, 'Could not update group', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Updated_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;
message_die(GENERAL_MESSAGE, $message);
}
else if( $mode == 'newgroup' )
{
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_type, group_name, group_description, group_moderator, group_allow_pm, group_single_user)
VALUES ($group_type, '" . str_replace("\'", "''", $group_name) . "', '" . str_replace("\'", "''", $group_description) . "', $group_moderator, '$group_allow_pm', '0')";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not insert new group', '', __LINE__, __FILE__, $sql);\r
}
$new_group_id = $db->sql_nextid();
$sql = "INSERT INTO " . USER_GROUP_TABLE . " (group_id, user_id, user_pending)
VALUES ($new_group_id, $group_moderator, 0)";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not insert new user-group info', '', __LINE__, __FILE__, $sql);
}
$message = $lang['Added_new_group'] . '<br /><br />' . sprintf($lang['Click_return_groupsadmin'], '<a href="' . append_sid("admin_groups.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');;
message_die(GENERAL_MESSAGE, $message);謝謝
