[問題] 文章遮蔽外掛困難

phpBB 2 MOD Support
無論是官方或非官方認證之外掛,安裝與使用問題討論。
(發表文章請按照公告格式發表,違者砍文)

版主: 版主管理群

主題已鎖定
audios
星球普通子民
星球普通子民
文章: 1
註冊時間: 2005-11-03 17:39

[問題] 文章遮蔽外掛困難

文章 audios »

代碼: 選擇全部

Error in posting

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 'on WHERE post_id = 107' at line 1

UPDATE phpbb_posts SET post_username = '', enable_bbcode = 1, enable_html = 1, enable_smilies = 1, enable_sig = 0, hideit = on WHERE post_id = 107

Line : 297
File : /data/members/free/tripod/uk/b/f/p/bfpccv/htdocs/includes/functions_post.php
$sql = ($mode != "editpost") ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig , hideit) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig , $post_hideit)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig, hideit = $post_hideit WHERE post_id = $post_id";
if (!$db->sql_query($sql, BEGIN_TRANSACTION))
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql); (Line 297)
}

怎麼辦?
主題已鎖定

回到「外掛問題討論」