第 1 頁 (共 1 頁)
[問題]Advanced_Hide_Post
發表於 : 2004-08-18 23:09
由 Raymond690
我setup了後可以發表文章...但左下角會說網頁發生錯誤><....而所有功能(如quote,code等等)都用唔到><
發表於 : 2004-08-18 23:23
由 Raymond690
我把我setup前備份了的phpbb file還原便沒有事了~但再把我setup後的phpbb file貼上去又有問題了><
發表於 : 2004-08-19 00:41
由 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
發表於 : 2004-08-19 13:05
由 Raymond690
我只裝一開始那個Advanced Hide Post是沒有事的.........但一裝上[修正昇級]進階隱藏 for CashMod2 1.0.4便會這樣了><
發表於 : 2004-08-23 19:02
由 不滅之火
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
我也有這樣的問題。
發表於 : 2004-08-23 19:12
由 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或""
因為沒附上外掛網址～所以請自己判斷錯在哪～