竹貓星球

發表於 : **2005-11-03 17:44**

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)
}

怎麼辦?

竹貓星球

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

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