竹貓星球

發表於 : **2006-01-20 02:34**

各位大大，
我的後台有一個問題遲遲未得到解決，不知道錯誤在哪裡？但其他又可以正常運作，亦試過從新安裝後沒有問題，不過當upload 舊的備份後，錯誤就會再出現：

一般錯誤 
Failed to update general configuration for # If you don't know how to execute sql queries, then copy

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 't know how to execute sql queries, then copy'' at line 3

UPDATE phpbb_config SET config_value = '' WHERE config_name = '# If you don't know how to execute sql queries, then copy'

Line : 62
File : admin_board.php

admin_board.php line：52-72 如下~

代碼: 選擇全部

			$cookie_name = str_replace('.', '_', $new['cookie_name']);
		}

		if( isset($HTTP_POST_VARS['submit']) )
		{
			$sql = "UPDATE " . CONFIG_TABLE . " SET
				config_value = '" . str_replace("\'", "''", $new[$config_name]) . "'
				WHERE config_name = '$config_name'";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Failed to update general configuration for $config_name", "", __LINE__, __FILE__, $sql);
			}
		}
	}

	if( isset($HTTP_POST_VARS['submit']) )
	{
		$message = $lang['Config_updated'] . "<br /><br />" . sprintf($lang['Click_return_config'], "<a href=\"" . append_sid("admin_board.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);
	}

我應該怎麼樣做？或是不用理會呢？

發表於 : **2006-02-02 22:28**

各位大大，
我從 phpmyadmin裡頭的 phpbb_config 中看見一些奇怪的東西並將其del.
就是這些：

代碼: 選擇全部

`phpbb_config` WHERE `config_name` = '#   If you don\'t know how to execute sql queries, then copy' LIMIT 1 ;

 `phpbb_config` WHERE `config_name` = '#   (assuming you use mysql or mssql)' LIMIT 1 ;

`phpbb_config` WHERE `config_name` = '#   If you don\'t use mysql or mssql, you\'ll have to edit these queries accordingly' LIMIT 1 ;

`phpbb_config` WHERE `config_name` = '#   If you have a different table prefix then change this command accordingly.' LIMIT 1 ;

 `phpbb_config` WHERE `config_name` = '#   I have used the default table prefix!' LIMIT 1 ;

 `phpbb_config` WHERE `config_name` = ')' LIMIT 1 ;

1)我想問這些都可以del.嗎？會有影響嗎？
2)這些是什麼東西，看似以前曾經出錯的對話盒？
3)後來再去後台看看，del.這些東西後，把原本的：

代碼: 選擇全部

一般錯誤 
Failed to update general configuration for # If you don't know how to execute sql queries, then copy 

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 't know how to execute sql queries, then copy'' at line 3 

UPDATE phpbb_config SET config_value = '' WHERE config_name = '# If you don't know how to execute sql queries, then copy' 

Line : 62 
File : admin_board.php

轉變成：

代碼: 選擇全部

一般錯誤 
Failed to update general configuration for group_id mediumint(6) NOT NULL default '0',

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 '0','' at line 3

UPDATE phpbb_config SET config_value = '' WHERE config_name = ' group_id mediumint(6) NOT NULL default '0','

Line : 62
File : admin_board.php

這些都會影響後台的運作，幸好我仍可以在phpmyadmin(mysql)裡更新。
1) 各位大大，我應該怎麼辦，從第一次改mod (cash mod)，後台就出現這個問題。

竹貓星球

[問題] 後台問題

[問題] 後台問題