●快速架站程式:Appserv
●您的上網方式:學術網\r
●您安裝的程式:Apache + php + MySql
●您的 phpBB2 版本:phpBB 2.0.4
●錯誤代碼:
代碼: 選擇全部
一般錯誤
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 'WHERE topic_id = 71' at line 3
UPDATE phpbb_topics SET topic_replies = topic_replies - 1, topic_last_post_id = WHERE topic_id = 71
Line : 477
File : e:\appserv\www\phpbb\includes\functions_post.php
●錯誤狀態:我自己發了一些文章並連續回覆很多次\r
之後我刪除最後一次回覆的文章則會出現以上的錯誤
個人覺得可能是因為裝了虛擬貨幣所產生的
不知道有沒有人遇過的
另外我把funtions_post.php第477的上下幾行秀出來
代碼: 選擇全部
if ( $topic_update_sql != '' )
{
$sql = "UPDATE " . TOPICS_TABLE . " SET
$topic_update_sql
WHERE topic_id = $topic_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
}
if ( $mode != 'poll_delete' )
{
// Virtual_Money_MOD added $reward_sql
$sql = "UPDATE " . USERS_TABLE . "
SET user_posts = user_posts $sign , user_money = user_money $money
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql, END_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
}
}

統編 70591921