[問題]Advanced_Hide_Post

[Raymond690]

我setup了後可以發表文章...但左下角會說網頁發生錯誤><....而所有功能(如quote,code等等)都用唔到><

[Raymond690]

我把我setup前備份了的phpbb file還原便沒有事了~但再把我setup後的phpbb file貼上去又有問題了><

[Raymond690]

唉~我setup多次了.......今次進了少少><當我發表文章要送出時,,,,,,,,一按送出就會:
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 ')' at line 1

INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, hiding_type, hiding_condition_value, hiding_cash_id) VALUES (49, 2, 2, '', 1092849460, 'cbdae283', 1, 0, 1, 0, 0, 0, )

Line : 271
File : d:\appserv\www\phpbb\includes\functions_post.php

我的fuctions_post.php line 266-276:
266
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";267
$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, hiding_type, hiding_condition_value, hiding_cash_id) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig, $hiding_type, $hiding_value, $hiding_cash_id)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig, hiding_type = $hiding_type, hiding_condition_value=$hiding_value, hiding_cash_id=$hiding_cash_id" . $edited_sql . " WHERE post_id = $post_id";268
if (!$db->sql_query($sql, BEGIN_TRANSACTION))269
{270
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);271
}272
273
if ($mode != 'editpost')274
{275
$post_id = $db->sql_nextid();276

[Raymond690]

我只裝一開始那個Advanced Hide Post是沒有事的.........但一裝上[修正昇級]進階隱藏 for CashMod2 1.0.4便會這樣了><

[不滅之火]

唉~我setup多次了.......今次進了少少><當我發表文章要送出時,,,,,,,,一按送出就會:
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 ')' at line 1

INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, hiding_type, hiding_condition_value, hiding_cash_id) VALUES (49, 2, 2, '', 1092849460, 'cbdae283', 1, 0, 1, 0, 0, 0, )

Line : 271
File : d:\appserv\www\phpbb\includes\functions_post.php

我的fuctions_post.php line 266-276:
266
$edited_sql = ($mode == 'editpost' && !$post_data['last_post'] && $post_data['poster_post']) ? ", post_edit_time = $current_time, post_edit_count = post_edit_count + 1 " : "";267
$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, hiding_type, hiding_condition_value, hiding_cash_id) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig, $hiding_type, $hiding_value, $hiding_cash_id)" : "UPDATE " . POSTS_TABLE . " SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig, hiding_type = $hiding_type, hiding_condition_value=$hiding_value, hiding_cash_id=$hiding_cash_id" . $edited_sql . " WHERE post_id = $post_id";268
if (!$db->sql_query($sql, BEGIN_TRANSACTION))269
{270
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);271
}272
273
if ($mode != 'editpost')274
{275
$post_id = $db->sql_nextid();276

我也有這樣的問題。

[messagebox]

SQL語法錯誤～
INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, hiding_type, hiding_condition_value, hiding_cash_id) VALUES (49, 2, 2, '', 1092849460, 'cbdae283', 1, 0, 1, 0, 0, 0, )
VALUE最後一項應為一個整數\r
不應該沒有任何東西～
如果為空～應為NULL或""

因為沒附上外掛網址～所以請自己判斷錯在哪～