[問題]安裝Mod update phpMyAdmin出問題

文章由 **help** » 2004-10-28 12:36

近期安裝 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

文章由 **help** » 2004-10-28 12:39

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

文章由 **x0952060001** » 2004-10-28 15:30

請你詳細描述你的問題及作業環境~不然沒人替你解答~

文章由 **help** » 2004-10-28 15:46

安裝 Flash Paint Mod DB

phpMyAdmin-2.5.6
phpbb 2.04

Mod 位置 http://fokhei.go.to/

文章由 **help** » 2004-10-29 02:12

我是無法 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>
?>