第 1 頁 (共 1 頁)
[問題]安裝Mod update phpMyAdmin出問題
發表於 : 2004-10-28 12:36
由 help
近期安裝 Mod 先 update 個phpMyAdmin就出問題
有沒有人知道是什麼問題 ? 一向都沒有問題 ....
代碼: 選擇全部
資料庫 xxxxxx_phpbb 在 localhost 執行
錯誤
SQL 語法 :
"ALTER TABLE ".POSTS_TEXT_TABLE. " ADD `post_fpdata` LONGTEXT NOT NULL",
MySQL 傳回：
#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 '"ALTER TABLE ".POSTS_TEXT_TABLE. " ADD `post_fpdata` LONGTEXT N
發表於 : 2004-10-28 12:39
由 help
Warning: Cannot modify header information - headers already sent by (output started at /home/hkwei/public_html/phpBB2/fp_db_install.php:9) in /home/hkwei/public_html/phpBB2/includes/sessions.php on line 210
Warning: Cannot modify header information - headers already sent by (output started at /home/hkwei/public_html/phpBB2/fp_db_install.php:9) in /home/hkwei/public_html/phpBB2/includes/sessions.php on line 211
發表於 : 2004-10-28 15:30
由 x0952060001
請你詳細描述你的問題及作業環境~不然沒人替你解答~
發表於 : 2004-10-28 15:46
由 help
安裝 Flash Paint Mod DB
phpMyAdmin-2.5.6
phpbb 2.04
Mod 位置
http://fokhei.go.to/
發表於 : 2004-10-29 02:12
由 help
我是無法 update
代碼: 選擇全部
<?php
define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style>
<!--
body { font-family: arial; font-size: 9pt; line-height: 1.5em; }
pre { color:#000000; background:#FFF9D8; }
pre.fnd { color:#000000; background:#E6E6E6; }
b { font-size: 9pt; font-weight: bold; color:#008800; }
.title { font-size: 12pt; font-weight: bold; }
.cmd { color:#0000FF; }
.g { color:#00FF00; }
.r { color:#FF0000; }
//-->
</style>
</head>
<body bgcolor="#FEFEFE">
<span class="title">Flash Paint Mod DB Installation</span><p>
<?php
$sql = array(
"INSERT INTO " . CONFIG_TABLE . " (`config_name`, `config_value`) VALUES ('flash_paint', '0|0|640|480|340|280')",
"ALTER TABLE " . POSTS_TEXT_TABLE . " ADD `post_fpdata` LONGTEXT NOT NULL",
"ALTER TABLE " . TOPICS_TABLE . " ADD `topic_flashpaint` TINYINT(1) NOT NULL",
"ALTER TABLE " . POSTS_TABLE . " ADD `post_flashpaint` TINYINT(1) NOT NULL",
"ALTER TABLE " . FORUMS_TABLE . " ADD `auth_flashpaint_post` TINYINT(2) NOT NULL",
"ALTER TABLE " . FORUMS_TABLE . " ADD `auth_flashpaint_view` TINYINT(2) NOT NULL",
"ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD `auth_flashpaint_post` TINYINT(1) NOT NULL",
"ALTER TABLE " . AUTH_ACCESS_TABLE . " ADD `auth_flashpaint_view` TINYINT(1) NOT NULL"
);
for ($i=0; $i<count($sql); $i++)
{
if ( !($db->sql_query($sql[$i])) )
{
message_die(GENERAL_ERROR, 'Could not update db.', '', __LINE__, __FILE__, $sql[$i]);
}
else
{
echo "<b>DB SCRIPT($i).......DONE</b><BR>";
}
}
?>
<p>
<span class="title">You may now remove this file.</span>
</body>
</html>
?>