網站位置：http://www.ponmin.com
狀況描述：
已經安裝的
版面外掛有fourm_access,簡易子分區1.2,fourm_icons
已爬文也對過程式碼\r
始終找不到錯誤在哪....
錯誤訊息\r
代碼: 選擇全部
Couldn't insert row in forums table
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 ' 'icon15.gif', 0, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1)' at line 2
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, forum_icon, forum_access, prune_enable , auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('40', '人民樂', 3, 'Ｍusic', 120, 0, 0, 0, , 'icon15.gif', 0, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1)
Line : 542
File : /home/ponmin/public_html/phpbb/admin/admin_forums.php貼上錯誤處之上下十行
}
}
//forum_sub end
}
// There is no problem having duplicate forum names so we won't check for it.
$sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, forum_sub, sort_sub, main_sub, forum_icon, forum_access, prune_enable " . $field_sql . ")
VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . $c . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . $forum_sub . ", " . $sort_sub . ", " . $main_sub . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumicon']) . "', " . intval($HTTP_POST_VARS['forumaccess']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
}
if( $HTTP_POST_VARS['prune_enable'] )
{
if( $HTTP_POST_VARS['prune_days'] == "" || $HTTP_POST_VARS['prune_freq'] == "")
{
message_die(GENERAL_MESSAGE, $lang['Set_prune_data']);
}
$sql = "INSERT INTO " . PRUNE_TABLE . " (forum_id, prune_days, prune_freq)
懇請大大幫幫忙..