1 頁 (共 1 頁)

[問題]無法更新版面!(已解決)

發表於 : 2006-04-30 20:24
forever3344
問題外掛:不清楚,自己都搞混了
使用版本:phpBB 2.0.20
網站位置:http://www.sfisland.why3s.net/phpBB2
狀況描述: 無法更新版面
論壇風格: MYSMIS
架站主機: why3s.net

代碼: 選擇全部

Couldn't update forum information

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 forum_id = 14' at line 3

UPDATE phpbb_forums SET forum_name = '即時通訊'、cat_id = 7、forum_desc = 'QQ,Skype,MSN ,Yahoo與gmail'、forum_status = 0、prune_enable = 0、forum_topictypes = WHERE forum_id = 14

Line : 440
File : admin_forums.php
440是這一段

代碼: 選擇全部

	$sql = "UPDATE " . FORUMS_TABLE . "
				SET forum_name = '" . str_replace("\'"、"''"、$HTTP_POST_VARS['forumname']) . "'、cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . "、forum_desc = '" . str_replace("\'"、"''"、$HTTP_POST_VARS['forumdesc']) . "'、forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . "、prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "、forum_topictypes = " . str_replace("\'"、"''"、$HTTP_POST_VARS['topictypes'])."'
				WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
			if( !$result = $db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR、"Couldn't update forum information"、""、__LINE__、__FILE__、$sql);
			}

			if( $HTTP_POST_VARS['prune_enable'] == 1 )
			{

Re: [問題]無法更新版面?

發表於 : 2006-04-30 21:53
hentaibbc
forever3344 寫: Couldn't update forum information

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 forum_id = 14' at line 3

UPDATE phpbb_forums SET forum_name = '即時通訊', cat_id = 7, forum_desc = 'QQ,Skype,MSN ,Yahoo與gmail', forum_status = 0, prune_enable = 0, forum_topictypes = WHERE forum_id = 14

Line : 440
File : admin_forums.php
紅色的地方...沒東西...
所以出錯了

發表於 : 2006-05-06 00:44
forever3344
我如果打上東西就換前面出錯了說?
是我哪個地方沒用好?

代碼: 選擇全部

Could not obtain limited topics count information

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 '、phpbb_posts p WHERE t.forum_id = 9 AND p.post_i

SELECT COUNT(t.topic_id) AS forum_topics FROM phpbb_topics t、phpbb_posts p WHERE t.forum_id = 9 AND p.post_id = t.topic_last_post_id AND t.topic_title LIKE '%' 

Line : 301
File : viewforum.php 

代碼: 選擇全部

$sql = "SELECT COUNT(t.topic_id) AS forum_topics 
      FROM " . TOPICS_TABLE . " t、" . POSTS_TABLE . " p 
      WHERE t.forum_id = $forum_id 
      AND p.post_id = t.topic_last_post_id 
      AND t.topic_title LIKE '$types' 
      $limit_topics_time"; 

   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, 'Could not obtain limited topics count information', '', __LINE__, __FILE__, $sql); 
   } 
   $row = $db->sql_fetchrow($result);